Create spreadsheet from AS400 file

320 pts.
Tags:
AS/400
How can I create a spreadsheet on PC from AS400 file without operator intervention?

Answer Wiki

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

A CL program with the command CPYTOIMPF can send a comma delimited file to the IFS.
Phil

Discuss This Question: 7  Replies

 
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
  • Teandy
    Here are three suggestions just off the top of my head. 1.) As Phil said, you can use CPYTOIMPF. 2.) Google for a command called CVTPFXLS. This will covert a PF to an excel sheet. You would still need to find some way of getting it to the user. I works fairly well when combined with email. This is what I used until I found option 3. The only problem I have with this command is that it clears the job log when it runs. That means that if there is a problem in the job, it can be hard to track down. 3.) You can use the HSSF POI API's to create your sheet directly with RPG. This coupled with email is now my "preferred" method when some one ask for data to be imported into excel. See Scott Klement’s tutorial at http://systeminetwork.com/node/60969. This is part 3 of the tutorial, but it has links to parts 1 & 2 at the bottom.
    5,860 pointsBadges:
    report
  • tjgm88
    Hi Teandy, I am also interested in this topic. However, I cannot get to Part 1 or Part 2 of the articles. Points to something else. Are you able to check this out please. Thanks.
    995 pointsBadges:
    report
  • djac
    I may be missing something here, but what's the problem with using the Client Access (or iSeries Access) data transfer? You can set the transfer up using the normal interactive method, then save the definition file. This can then be used with the RTOPCB command on the PC to create a desktop icon for the user to run the transfer whenever they want.
    900 pointsBadges:
    report
  • Joy Stalnecker
    I also use HSSF. The benfit is that you can create spreadsheets that include all types of formatting, formulas, freeze panes, and multiple sheets within a work book, just to name a few. I also allows you to use RPG and does not restrict you to SQL as Client Access does. Another benefit is that you can read an excel file and add more data. I would recommend it to people that need to create more complex spreadsheets. Here's some working links for Part 1 and 2: Part 1- http://systeminetwork.com/node/60954 Part 2 - http://systeminetwork.com/node/60962
    170 pointsBadges:
    report
  • Teandy
    Djac, There is nothing wrong with using Client Access and it would probably be a good fit for most applications. It's just that the original question asked how to do this with out operator intervention.
    5,860 pointsBadges:
    report
  • Cunninjoe
    This is my first time on this site and thanks to all for the pertinent info. I used the cvtpfxls and it is fine for my purposes. Client Access requires either saving .fdf files for each user or going through somewhat unwieldy screens for each occurrence. Cpytoimpf to .csv is fine for many purposes but doesn't seem to produce a header line. Both seem to be a challenge for some of our users and with so many requests for spreadsheets with headers, the cvtpfxls is fine. Maybe I will get ambitious enough to try the API's one day. Thanks again for comments.
    320 pointsBadges:
    report
  • Cunninjoe
    Thanks Teandy especially.
    320 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