I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data.
PROBLEM: How can I format the spreadsheet with headers and column fonts and colors, etc. and just load the data beginning in cell A2? I can manually run the same DTF through add-in feature to keep formatting but I need this completely automated.
Software/Hardware used: excel 2007 / IBM iSeries Access 6.0
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!