Home > IT Answers > AS/400 > Convet pf file to Excel
1510
15 pts.
0
Q:
Convet pf file to Excel
AS/400, PF, Microsoft Excel
I had copyed spool file to pf and i want that should be copied to execl format.
ASKED: Jun 25 2009  2:04 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24105 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Jun 25 2009  2:12 PM GMT by Philpl1jb   24105 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Teandy   2860 pts.  |   Jun 25 2009  2:34PM GMT

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.

 

Rickmcd   590 pts.  |   Jun 26 2009  6:16AM GMT

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

 

RonBender   155 pts.  |   Jun 26 2009  1:11PM GMT

Hi Rickmcd,

How do you add the iSeries addins to Excel?

 

DHLSameday1   60 pts.  |   Jun 29 2009  3:54PM GMT

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

 
0