I want data from AS400 PF to my windows system in form of XL sheet.
I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If number of rows in PF are greater than what an XL sheet can accomodate, then remaining data should be put in a new XL sheet. This process of creation of new XL sheets should continue till all the records are fetched into the XL sheet. Name of PF should be a parameter for this program.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 5, 2009 1:20 PM
UPDATED:
January 15, 2009 10:30 PM
Answer Wiki:
You are correct. The last time I checked, depending on the version, Excel had a limit of 65000 rows. The best thing I have found for this is to use the to use Java POI/HSSF classes in RPGLE. Check out http://faq.midrange.com/data/cache/533.html for how to do this.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
