Subscribe Bookmark RSS Feed

Saving to an XLS, how do I specify the Worksheet name?

whom

Community Trekker

Joined:

Jun 23, 2011

After processing data in JMP, I need to create a new XLS file with all of the data.  I need to follow a specific naming convention for the worksheet tab names.  How do I specify the name of the worksheet name within JMP?  The file will be written out to MS Excel 2003.   Thanks!

1 REPLY
wmwinn

Community Trekker

Joined:

Jun 23, 2011

Here's an example that works for me.  "sheetname" is the string variable containing the worksheet name.

dtout << save database("DSN=Excel Files;DBQ=c:\users\yourname\...\your-workbook.xls",sheetname);