BookmarkSubscribeRSS Feed
CHUNantes
Obsidian | Level 7

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.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Discussion stats
  • 0 replies
  • 547 views
  • 0 likes
  • 1 in conversation