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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!