Hello,
a new version is available here: http://www.tcoq.org/composants,
correcting glitches and adding improvements (see below).
A direct link to the download is here:
http://www.tcoq.org/SpreadsheetInterface_sources_V0.11.zip
N° of rows and columns not yet implemented. I could have them next
week-end.
My usual practice is to loop on the cells in a given row or column
until a
condition is met, for example 'end' in the cell value, or '' empty.
New functions are introduced on the ISheet interface: GetLastColumn and
GetLastRow. That should help you. It took me a little time: I coded them
in both Excel and OpenOffice.
Some remarks.
There is something wrong with TWorkBook.Close. When I have
DisplayAlerts=TRUE then it always ask "File FALSE.xlsx already exists.
overwrite it ?". Maybe it should have DISPID_CLOSE instead of
DISPID_SAVEAS.
What should look like the correct procedure for closing Excel without
save file ?
I use:
ExcelWb.Close(false); // Close with DISPID_CLOSE
ExcelApp.Quit;
You're right. This is corrected. The Close now calls DISPID_CLOSE.
You should Save or SaveAs the workbook before closing, or set
displayalerts to false if you wish to close without saving.
and Excel process still exists untl I close my app.
With DISPID_CLOSE I see that the process releases some memory
(probably correctly closes sheet) but the process still exists (hangs?).
Yes, I don't why yet. Certainly a bug in the interface somewhere. It
doesn't happen for OpenOffice, though. I'm still looking into it. In the
meantime, there should be no remaining compiler warnings or hints,
except in the Pas_Uno_Bridge (needs some investigating).
I hope this helps,
Best regards,
Thierry
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
