Kirill S. Palagin wrote:
One approach, that will work across Calc/Excel and any otherspreadsheet app would be to construct .xls yourself (either with the help of 3rd party modules or by using description of .xls http://sc.openoffice.org/excelfileformat.pdf ).
If you want to write the files yourself, creating them in the OpenDocument format is probably easier, especially if a user-supplied template is used that has to be loaded first.
The other approach would be usng OLE/DDE/UNO and suchlike to directly feed cell contents into available spredasheet, but our experience shows that it is very CPU/RAM intensive, so we are constructing binary .xls.
Loading and saving will take similar time and memory as when done from the UI. Filling cells using the UNO API is quite fast when done right (reduce the number of calls: set multiple attributes in one call, fill blocks of values at once).
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
