How to extract data to the various excel sheets in a CL.
Hi,
I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files.
Can someone show me how to use the various sheets in excel to store the data and how to create additional sheets?
* Create Spreadsheet of all Numbers by branch*/
* EXECUTE VIEW (CUSIGQ1)PCFMT(*XLS) TOFLR(&FOLDER) +
TODOC(CUSIG.XLS) REPLACE(*YES) +
TEXT('Program lists all Numbers +
by Branch.')*/
Software/Hardware used:
Software/Hardware used:
ASKED:
March 2, 2009 8:14 PM
UPDATED:
March 13, 2009 11:32 PM
RELATED QUESTIONS
- Excel that increments number when created from template?
- Create Excel file on web server by using SQL
- Automatic Publish web page when excel data changes
- Comparing 2 files .CSV and getting the missing data using AS400.
- Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400
Answer Wiki:
CL is probably not the best choice for this.
Scott Klement wrote some articles for iSeries Network that explain
how to use Java POI/HSSF classes to read and write directly to
Excel spreadsheets. Here is a link to the third article in the series. Links to the other two are at the bottom.
http://systeminetwork.com/node/60969
You can also try http://faq.midrange.com/data/cache/533.html
To see all answers submitted to the Answer Wiki: View Answer History.
I use biterscripting for manipulating spreadsheet files. It allows me to directly transfer data between web pages and CSV (comma separated values) files.
There is a good sample script posted at http://www.biterscripting.com/SS_CSV.html . Do take a look.
If you don’t have biterscripting, download it at http://www.biterscripting.com . It takes under two minutes from my computer. Several sample scripts, including the one above, are included. To install all sample scripts at once, use the following command
script “http://www.biterscripting.com/Download/SS_AllSamples.txt”
Turns out it can execute scripts directly from a web site.
Jenni