CVTPFXLS command options

980 pts.
Tags:
CVTPFXLS
Microsoft Excel
Microsoft Excel spreadsheet
Hi people, I need some help with formatting Excel spreadsheets within the IFS. My program currently prepares a physical file on the iSeries and uses the CVTPFXLS command to create a Excel sheet. However, this sheet is pretty bland and I wish to add some formatting before the user gets it. The CVTPFXLS command does not have any option to do this. I do have a template of the sheet prepared. Can this be be somehow applied to the new sheet (format only) before passing it on to the user. Does the IFS provide for this? Or is there some other command I can use to achieve this? Any help will be appreciated. Thanks.

Software/Hardware used:
iseries, Windows 2000
ASKED: September 5, 2012  11:53 PM
UPDATED: June 14, 2013  7:04 PM

Answer Wiki

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

Discuss This Question: 2  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
    Does the IFS provide for this?   I'm not sure what that question is really asking. The IFS doesn't provide for it. But FAT, FAT32, NTFS, HPFS and any other file system you can think of don't provide for it either. That's not what file systems do. It's what Excel does, not the file system where documents are stored.   And Excel can apply formatting to spreadsheets that are stored in the IFS just like it can for NTFS or whatever file system you use.   But CVTPFXLS doesn't create Excel spreadsheets nor any kind of Excel file. It creates a type of text file that Excel can import. Excel can't apply any formatting to it until it has been imported into Excel.   Actually, there is no programming that will apply Excel formatting to the output of CVTPFXLS. However, you could create programming that read the CVTPFXLS output and wrote its output to an actual Excel file with Excel formatting. Of course, if you did that there would be no need for CVTPFXLS in the first place. It would be easier just to read the original database file than to read what CVTPFXLS creates.   Essentially, if you want to create an Excel spreadsheet with formatting, you have two basic choices. You can use Excel to access the database file and to format the output. Or you can use the Apache POI Java API to create programming on your AS/400 to output Excel files with the formatting that you want. (And the result could be stored in the IFS.)   Tom
    125,585 pointsBadges:
    report
  • tjgm88
    Thanks Tom. The last paragraph is of interest to me and shall investigate the two options.
    980 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