I want data from AS400 PF to my windows system in form of XL sheet.

5 pts.
Tags:
Microsoft Excel
PF
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.

Answer Wiki

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

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.

Discuss This Question:  

 
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

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