Hi
I wonder if it is possible to create (add data) a excel file while the software (MS Office) is not installed on the machine itself. I have somewhere on the system a excel template (work.xlt) but the software is not installed. Is it possible then to still create an object in lotusscript to fill the template with data?
Regards
Subject: Creating an excel file in lotusscript
No not possible at all
Subject: Creating an excel file in lotusscript
Creating an MS Excel object is not possible.But it is possible to create a file in MS Excel format and save it.
For a very simple Excel spreadsheet you can create simple text files with tabs and newlines.
You have the option to create comma-separated files that Excel can read.
And - as I said - it is possible to create a file in ‘pure’ MS Excel format. This is not something I’d recommend anyone to do but it is technically possible. If you open an excel file using a text-editor you can see what it looks like.
Subject: RE: Creating an excel file in lotusscript
Hi
Thank you for the response.
But can i perform excel operations like autofit, font operations, etc.?
The lotusscript code is performed in the background by an scheduled agent.
Regards
Subject: RE: Creating an excel file in lotusscript
“The lotusscript code is performed in the background by an scheduled agent.”
Then MS Excel needs to be installed on the server where it is running. If you cannot meet this condition, then only other way I can think of, would be to write an XML file that excel is capable of reading.