How do you generate an Excel file?

[vrozen1]

Clifton, I think the easiest way will be generate coma separated file. This file can be converted by Excel to .xsl file.

[Guest.Visitor]

I know you can create an Excel formatted file from a AS/400 db file via Client Access. What I was wondering is wether this conversion can be done on the AS/400 via some API. What I'm talking here is Excel format and not CSV Excel readable. Has anybody ever done this or pondered doing this before? I imagine that there is some API (maybe a codepage value on CPYTOSTMF?) that would allow this. Thanx in advance for any thoughts.

[Guest.Visitor]

I haven't tried this but there are two ways I can think of that might work: 1. Install Excel in a folder on the IS and run a transfer script to put the file into Excel and start a Macro to save the file. 2. Do a RUNPCCMD and start Excel and a macro to start the transfer script, run the transfer and save the file. Either way in order to get the data to become and Excel file it will have to be brought into Excel and saved as an Excel file.