How to extract data to the various excel sheets in a CL.

5 pts.
Tags:
CL programming
Microsoft Excel
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.')*/
ASKED: March 2, 2009  8:14 PM
UPDATED: March 13, 2009  11:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JenniC
    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
    70 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following