Writing and reading from same excel file

[shubhi]

Hi.

I wanted to write some measured values to the excel sheet and after doing some calculation there I want to read the same file.

Can I do this? Or there is any better way of performing the same task.

Kindly help.

Thanks 🙂

[P@Anand]

Are you going to use the MS Excel file or a tab delimited file?. Any way you can read and write to the same file but you need to maintain the file position so that when you write again yor data will not be overwritten

[shubhi]

Thanks Anand

I am going to use a MS Excel file.

But I first want to write to it and then modify it so that I could read the modified version back and display on the front panel.

How will this work.

Sorry new to Labview. So deep questions.

[P@Anand]

If you want to use MS Excel you have lot work compared to the delimited files. You have 2 option Report Generation and ActiveX you can choose one and do it. In Excel Board you have all the examples required to do, what is the purpose for you to go for a MS Excel file any specific reason?

[shubhi]

Thanks Anand.

I actually need to find out the difference in the values measured , as in x2-x1.. x3-x2. So thought of doing in Excel only as I could not find a better way in Labview as I m looping it  . Pretty new to Labview..So struggling 

[P@Anand · Accepted solution]

For doing this you do not need a file. Check the attached example I guess this would work

[crossrulz]

Hmmmm....this sounds familiar...http://forums.ni.com/t5/LabVIEW/Difference-of-measured-values/m-p/2132166