Create Excel Workbook - help

uday_guntupalli

All, 

    I am doing the following: 

 

If(OutputFlag & DirectoryExists(OutputFolderName),
	WorkBookName = OutputFolderName || "\" || "ComparisionResults.xlsx" ;
	Create Excel Workbook(WorkBookName,TablesList);
  ); 

   From checking in the log, and the background, I know the JMP data tables are open and TablesList is a list with table names. Output Flag is set to 1 . 

   Every time I call on Create Excel Workbook function - it returns an "Unknown" error .Any guidance on how to fix this ? 

 

 

cwillden

Got your pm.  I can't seen anything wrong with what you have. The 2-table example I ran shows there's nothing explicitly wrong with the code you shared.  I wonder if the issue might have anything to do with the number of tables you are putting into the workbook.  See if you can get it to work with a small subset of the tables list.  If it works, try to isolate the issue by playing with the tablelist until it you can find the trigger for the error.