6415_en-US

liliconcom

Saving to an XLS, how do I specify the Worksheet name?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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!

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

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);