Reports to be pulled from iSeries

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

Answer Wiki

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

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 Files\IBM\Client Access\Shared click <b>cwbtfxla.xll</b>

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
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Jaymz69
    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
    765 pointsBadges:
    report
  • Teandy
    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 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.
    5,860 pointsBadges:
    report
  • HMSSL2K
    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.
    3,175 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