How can I determine changes of data ?

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Fyger
Posts: 2
Joined: Wed Feb 11, 2009 10:49 am

How can I determine changes of data ?

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: How can I determine changes of data ?

Post 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?
Lars Arvidsson, Axolot Data
Fyger
Posts: 2
Joined: Wed Feb 11, 2009 10:49 am

Re: How can I determine changes of data ?

Post 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
Post Reply