SAS Add-In Office Excel + Stored Process : specify the filename of the worksheet

CHUNantes — Wed, 26 Jul 2023 12:25:45 GMT

Hello.

Our users are using Add-in Office Excel to run a Store Process and generate a dashboard in Excel.

When running the STP, user is prompted to choose between storing the result in a new worksheet or use the current one and specify the cell to use.

No matter which option you choose, Excel open a new worksheet to display the result and the file is always named Main.xlsx

Here is the start of our STP where we specify the name wanted :

%global _odsdest _odsstyle _odsstylesheet;

%let _odsdest=excel;
%let _odsstyle=sasweb;
%let _odsstylesheet=;

data _null_;
rc = stpsrv_header('Content-type','application/vnd.ms-excel;');
rc = stpsrv_header('Content-disposition','attachment; filename=BilanDesLits.xlsx');
run;

*ProcessBody;
%stpbegin;

What's wrong ? Is there another option to set the filename ?

Regards.

topic SAS Add-In Office Excel + Stored Process : specify the filename of the worksheet in Microsoft Integration with SAS

SAS Add-In Office Excel + Stored Process : specify the filename of the worksheet