Page 1 of 1

How can I determine changes of data ?

Posted: Wed Feb 11, 2009 11:14 am
by Fyger
Hello!

Does "Modified" property or similar function exist ?
I would like to write data into file if something changed :

XLS.FileName := 'test.xls';
XLS.Read;
...
process
...
if XLS.Modified then
XLS.Write;

Thanks

Re: How can I determine changes of data ?

Posted: Fri Feb 13, 2009 8:14 am
by larsa
Hello

No, there is nothing in the excel file format that let you detect changes to a file. Can't you use windows api functions and check if the date/time of the file has changed?

Re: How can I determine changes of data ?

Posted: Tue Feb 17, 2009 7:20 am
by Fyger
Hi

You misunderstood me.
I would like check the changes of the memory (cellstorage) before writing back to the file.
Example:
I set an cell with
XLS.Sheets[0].AsString[0,0] := 'text';
and the data in the memory has changed, not in the excel file.

How can I detect the changes of cells' data ?
Is there something solution ("XLS.Sheets[0].Modified" property) or can you will establish it sometime ?

Thanks