Your SAS programs, embedded in web apps and elsewhere

Stored Process to Excel

Accepted Solution Solved
Reply
Super Contributor
Posts: 321
Accepted Solution

Stored Process to Excel

Hi,

I got curious with this example. http://support.sas.com/kb/40/683.html

How do you rename the name of the worksheet/s?

Thanks!


Accepted Solutions
Solution
‎09-23-2011 04:01 AM
Contributor RSB
Contributor
Posts: 72

Stored Process to Excel

Use this Option

  ods tagsets.ExcelXP options(sheet_name='Sheet Name Here');

View solution in original post


All Replies
Solution
‎09-23-2011 04:01 AM
Contributor RSB
Contributor
Posts: 72

Stored Process to Excel

Use this Option

  ods tagsets.ExcelXP options(sheet_name='Sheet Name Here');

Super Contributor
Posts: 321

Stored Process to Excel

Hi,

Thanks for the help! I used TAGSETS.MSOFFICE2K instead because I was getting an error with EXCELXP. I couldn't open the file.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 264 views
  • 0 likes
  • 2 in conversation