Format excel files sent from Office Integrator
From Support
| If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
Do you have a method of formatting information in Excel Spreadsheets when sending data from the AS400 to a PC using Office Integrator?
[edit]
Solution:
In order to make this work, you first have to generate the data file and send it to the PC. Then you need to make an Excel template. In the template import the data file and format the data as required. When you save the template Excel will ask if you want to clear the data and reload it when the template is opened - answer Yes. In the AS400 CL generate the data file as required and send it to the PC. Then call the template - Example:
OFCRUNPC CMD('S:\DP\Asset Inventory\BCCopy.xlt') OPTION(*LAUNCH)
When Excel opens the template you will get a box that asks if you want to import the file - select the "Import" button.
