topic Re: replace data in spreadsheet in LabVIEW

replace data in spreadsheet

shrekt — Mon, 05 Oct 2009 07:48:51 GMT

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

Re: replace data in spreadsheet

Gak — Mon, 05 Oct 2009 08:05:57 GMT

Hi shrekt,

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

Re: replace data in spreadsheet

DFGray — Mon, 05 Oct 2009 14:17:32 GMT

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.

Re: replace data in spreadsheet

shrekt — Tue, 06 Oct 2009 04:46:22 GMT

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,

Re: replace data in spreadsheet

LV_user1 — Tue, 06 Oct 2009 05:29:30 GMT

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

Re: replace data in spreadsheet

Gak — Wed, 07 Oct 2009 03:55:06 GMT

One more example

Re: replace data in spreadsheet

Somil — Wed, 07 Oct 2009 06:59:24 GMT

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

Re: replace data in spreadsheet

shrekt — Wed, 07 Oct 2009 07:41:57 GMT

Hi all,

Thanks for your support, I am working on it

Regards