replace data in spreadsheet

[shrekt]

Hi all,

I have to replace a data present at specific index in a spreadsheet file which already exists.

one way is to read the spreadsheet file replace the element and again write it to the file but the file in which i am writing 

will be having huge number of entries, so it would be difficult to go by this method,

anyone can suggest another method

regards

[Gak]

Hi shrekt,

I think you should use ActiveX control. To access particular Cell that you want to update.

[DFGray]

Is the spreadsheet file a binary Excel file or a tab separated text file?  If the former is the case, then you can use ActiveX.  If the latter, the complexity of the solution will depend on how regular the field width of your data is.

Field Width Constant

This is an easy case.  You can directly calculate the offset to the location in the file and simply overwrite it.  Make sure you overwrite with exactly the same field width.

 Field Width Not Constant

 Search for the row first by searching for CR/LF pairs in the file.  Once you find the row, search for field separators (probably TAB) to find the field.  Find the start and the end of the field you want to overwrite, then overwrite the whole thing, but nothing more.  You can cache line position inforrmation as you go so that subsequent searches are much faster.

[shrekt]

Hi,

Thanks for your reply,

I am not that comfortable in using the activex, i have not studied it yet throughly,

I will try to do it, can you suggest any examples for it?

Thanks,

[LV_user1]

you can use this vi to read data from excel and then can modified it using item put property.

[Gak]

One more example

[Somil]

hi

To write to an excel sheet, following VI can also be used.

[shrekt]

Hi all,

Thanks for your support, I am working on it

Regards