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