 |
| |
Frequently Asked Questions (FAQ's)
|
Summary:
How do I write a CSV file on the second worksheet in XLS?
Answer:
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. |
|
|
|
|
|
|
|
|
|
