Convet pf file to Excel

15 pts.
Tags:
AS/400
Microsoft Excel
PF
I had copyed spool file to pf and i want that should be copied to execl format.

Answer Wiki

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

You can use CPYTOIMPF to copy a physical file to an Excel file.

It sounds like your physical file would be a single field 80 or 132 char wide.
When it gets to Excel each row will be a long character entry in Column A.
Probably not what you were hoping for.

When the physical file has actual columns the CPYTOIMPF does a great job of transfering it.

Phil

Discuss This Question: 4  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 is something else you can try. Using iNav, click on the plus sign next to the iSeries you are working on. Navigate to Basic Operations/Printer Output and drag the spool file to your desktop. This will convert the document to a text file which you can then import into excel.
    5,860 pointsBadges:
    report
  • Rickmcd
    In Excel if you installed from Client Access you should have Excel Addins which will put Iseries data to a spreadsheet ot place spreadsheet data onto ISeries
    1,605 pointsBadges:
    report
  • RonBender
    Hi Rickmcd, How do you add the iSeries addins to Excel?
    155 pointsBadges:
    report
  • DHLSameday1
    To insert as400 Add-ins: Open a spreadsheet, Click on tools and Add-ins window is displayed, Click "Browse on Add-ins window, Within Browse window, locate "Program files" folder and double click on it, Now locate IBM folder and double click on it, Now locate "Client Access" folder and double click on it, Now locate "Shared" folder and double click on it, You should see "cwbtfxla.xll" and select it. Regards, Alex Bernardo
    85 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