How do I write a CSV file on the second worksheet in XLS?
If you are writing a CSV file, you can not simply write to the second worksheet in an XLS. Below are some ways it can be done; there may be more.
1) Produce a CSV file for each worksheet desired. Then pre-build an Excel Worksheet with a Macro that reads the CSV files and loads them in as desired. I have used this method, and it worked great in 7.5. In 8.4, it is more cumbersome; each user must download the XLS file and CSV files to their hard drive, then execute the macro.
2) Create an XML document in SQR that can be read in Microsoft’s Excel. One limitation is that the user must have a newer version of Excel to read the XML effectively. If you have Excel 2003 (maybe Excel XP), take a look at the output of saving an Excel document in XML. It comes back into Excel with the same level of detail.
*Questions excerpted from ITToolBox.com*
Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by PeopleSoft-Planet.com.