exporting data to excel

[chirs73]

Look at the following Word document. I think it should explain better what I am trying to achieve.

Thanks

Chris Gallo

[Corny]

I see your problem, you are writing to the wrong row?

Just change the cell number you are writing to should do the trick each time you run the VI? (instead of A1, use A2, A3 etc..)

If you do not know at what row there is data, read all rows or cells and then look for in what row/cell your last data is, and write to the row just below that one.

There is also a report generation toolkit  you can use, this makes it pretty easy and fast to make excel reports without making the code yourself.

Message Edited by Corny on 06-12-2008 03:00 PM

[chirs73]

Yes I want to add new lines of data.

I don't have the Report Generation Toolkit.

Thanks for your input. I will try that.

Chris Gallo

[MikeS81]

Hi chris,

attached you will find an example. Create an excel file "Mappe1.xls" and copy it in the same folder as "unbenannt 1.vi". There is one sub vi missing but you can simply delete the sub vi call.
Hope it helps.

Mike

[chirs73]

Here is my updated Test VI. I am now getting an error message from the ActiveX when I am running it and trying to export the data to excel. Any help from anybody would be very much appreciated.

[Joe_H]

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

this board is dedicated to using Excel with LV.

[MikeS81]

Hi chris73,

you have to connect a row in the write case!

Mike

[chirs73]

Here it is fixed....I still can't get it to export data. Any help anybody can give me would be greatly appreciated.

Chris

[MikeS81]

Hi Chris,

i think your code to write to excel runs independently to the other code. I recommend to insert some communication structure. If you don´t connect the "row wire" in the open case then it is 0 in the other case, but row 0 is not available in excel.
I changed your vi and it works for me.

Hope it helps.
Mike