2011/2/9 <[email protected]> > Selon faber <[email protected]>: > Hello, > thanks for you trying the software. I have a warning on GetItem, which is > hiding > an ancester method. > > 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. > > 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; 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?). I found some workaround for RowCount in TSheet.GetLastRowFilledIn best regards faber
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
