Home > IT Answers > Microsoft Windows > Reports to be pulled from iSeries
Ausboi09
5 pts.
 Reports to be pulled from iSeries
excel, iSeries, iSeries administration
Hi. I have a query regarding pulling the report from i series, am working on I series when i pull the report into txt format in notepad,when  i copy and paste it into excel it displays unwanted rows with blanks and some special characters and word like particulars would be splitted like parti cula rs in separate columns. Could u please helpme out in resolving this Thanks& Regards, Susheel Kumar

Software/Hardware used:
ASKED: January 17, 2011  4:46 PM
UPDATED: January 19, 2011  9:37 PM
RELATED QUESTIONS
Answer Wiki:
Transfer iSeries files to Excel using Client Access. In Microsoft Excel go to TOOLS select ADD-INS then Client Access data transfer to enable client access data transfer to go C:Program FilesIBMClient AccessShared click <b>cwbtfxla.xll</b>
Last Wiki Answer Submitted:  January 19, 2011  2:20 am  by  tedsoh   210 pts.
All Answer Wiki Contributors:  tedsoh   210 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

when i copy and paste it into excel… help me out in resolving this…

Don’t copy and paste it into Excel. A spooled file isn’t intended to be pasted anywhere. It’s intended to be printed.

If you must get it into Excel, try starting Excel, then use File-> Open… to access the text version of the spooled file. That should allow you to specify where column breaks may be set.

For unwanted rows and characters, we’d need to know what was in the text file before guessing what to do about Excel. And we might need to know what was in the spooled file before knowing how to interpret the resulting text file.

We might need to know the printer file definition as well as the associated printer description. There might be control characters in the spooled file that only the printer understands.

Tom

TomLiotta
 108,175 pts.
 

That is what I do when users want it in Excel.

iSeries/printer-output

Open Excel
Open the text file
adjust the columns as needed

then clean-up/beautify as needed

Jaymz69
 765 pts.
 

Unless this is a third party program, why not have the program that runs the report create the excel sheet and email it to the receipient?

Scott Klement wrote a tutorial showing how to create excel sheets from RPG.

See http://www.scottklement.com/presentations/#RPGHSSF

Also this thread may help as well. http://itknowledgeexchange.techtarget.com/itanswers/how-to-export-data-from-as400-in-excel/

Look at http://www.easy400.net for tutorials on how to email documents from the i5. You may need to register with the site (free) to access the downloads area.

Teandy
 5,830 pts.
 

What I do is copy the spooled file from the iSeries to my desk top. In Excel I go to the data tab, then get external data, from text, find your spooled file, click import. Go with fixed width and click next. Then just follow the steps on the next screen to create the Excel worksheet.
Works fine for me.

HMSSL2K
 3,175 pts.