Read data from excel and add to another excel file without replacing

[atulchemistry]

Hello Experts,

I need help to read from excel file.

I have two columns in excel file to be read and in the first coulmn there is name of parameter and in second the corresponding value.

And this file replaced after every 10 minutes with new data parameters.

What i am trying to do is to read the data from this file and export these parameters to excel in which the new parameters will be logged one after another.

I have serached forums but unable to get from where to start.

All the help will be highly appreciated.

Thanks

[Joe_H]

Since Excel files are proprietary from Microsoft then reading and writing to and from excel requires you to use ActiveX or the Office toolkit from NI. If you are just starting out then I would not use this approach or if you must use Excel then save the files as a .csv instead of .xls that way you can just use the native LabVIEW read and write to spreadsheet files, however if you must use excel in the .xls format then you can search the forums on how to do that. I have wrote many example programs and even some toolkits.

For more information and some sample VI's and tool kits, you can go to the excel board

[atulchemistry]

Thanks for information.

Other than excel i have possibility for generating the ASCII file but the output file where i will be exporting data should be excel.

You did a great job in excel board.

thanks

[atulchemistry]

I have installed microsoft office toolkit and went through  vi´s in order to prepare what i am looking for !

But unable to start up with it. Since the data coming from instrument is not always in the same cell i need to find for specific name and then to read data

from the next cell. Attached can see the file with comments , ¨to be read¨ and the output file in which it will be appended.

All the ideas and examples are welcome and will be appreciated much in terms of maximum kudos i can .

Got completely stuck Help me out !

[atulchemistry]

No any clues about this !

[atulchemistry]

NO any experts available in forum ?

[MikeS81]

Hi,

did you check the link Joe posted?

Mike

[atulchemistry]

Hello,

Thanks for reply. Indeed i have gone through maximum possibilities to solve this.

I could able to read data from file and it shows on the labview panel. So far i have reached this much (see the attached Vi and excel file ).

And can export data to excel to ASCII file readable by excel. But i am completely stuck since every export replaces the earlier data instead of writing to next row.

Since i am at very learning stage, i dont know how to deal with this.

Every information will be greatly appreciated.

Thanks

[atulchemistry]

Although the VI is very bulky. I tried build as much i can.

thanks

[Joe_H]

The way that your VI is written I cannot make heads or tails out of what you are trying to accomplish. YOu have lots of Excel functions that do the same thing over and over again. In a flat sequence. You should just build a subvi with a input for the string to find. Also on your write to the csv file. you open the file, write to it and then close it. the reason why the data gets overwritten is because the open file path is set to replace or create and it should be set to open or create.