AS400 V5R2 RLU AFPDS Printer Files transfer to Excel

15 pts.
Tags:
AS/400
V5R2
How can I take a printer file created in AS400 V5R2 RLU AFPDS Printer Files transfer to it to an Excel spread sheet?
ASKED: January 24, 2008  4:05 PM
UPDATED: March 9, 2010  6:56 AM

Answer Wiki

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

Hi,

do you mean you want the source of the PRTF transfered to excel or you want the created spool to be inserted inside excel. ?

If this is option 2, please explain your goal for wishing that because i do not understand what that will bring to you.

Using Operation navigator you may move your spool to a .TXT file pc based.
And this one may be easily, like any other file/object.

br.

T.

=============================================================

Generally, you would do it the same way you’d take the spooled output from a print request of a formatted Windows Word document and open that in Excel. (Most likely you’d get garbage in Excel because Excel has no idea what to do with spooled files created in a complex printer data stream.)

In short, an AFPDS object isn’t compatible with a program like Excel. AFPDS isn’t a trivial data stream.

Create the output as a SCS printer file instead of AFPDS. Extracting clean text out of SCS objects is far easier.

Tom

Discuss This Question:  

 
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

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