Save excel book

[oddesycircuit]

I have a program that takes 3 different measurements 200 different times, and sends them into a book in excel.  Therefore, I would like to have it automatically save the Excel book containing the measurements after all 200 have been taken.  I am using labview 7.0 (express).  Can somebody help me? My VI is attached for reference.

[Steve.Briggs]

Hey odd,

I'd like to help.  But I can't open a bunch of your subVIs. 

From what I see tho, simply try turning the loop into a for loop that runs 200 times and stops thereafter.  Once the loop stops you can dump all the data into an Excel spreadsheet.

Regards,

[oddesycircuit]

I apologize if my explanation was not clear enough.  My program is already capable of exporting the data to an excel book.

What I want to realize is means of having my LabView program automatically save the excel book once the measurements have ended.

Does anybody know how to do this?

[Joe_H]

On the excel board there is a lot of VI's for working with excel. On this board is also some toolkits that you can use free of charge. Here is a portion of it. Inside the llb is a file called save workbook.VI

Sorry, I do not have it in 7.0 but I think the one one the excel board is.

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

[Joe_H]

all you have to do is to take the reference from the open workbook and create a method and select save or save as. Another thing that you need to do is to be sure to close all of the references

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

[oddesycircuit]

Jhoskins,

That VI titled "Save Workbook" would be so perfect, but unfortunately I can't access it seeing as how I have an earlier version of LabView.  Is there any way that I can get it in 7.0?

[Joe_H]

I think the one on the excel board is 7.0 but I could be wrong. That VI is simple to make though.

1. Right click the reference coming out of the open workbook.vi
2. Select create method.
3. Select save or save as (your pick)
4. place the node wherever you need to put it on the block diagram and make sure you wire the workbook reference to it just like you did the open sheet. (use the same reference with a wire branch)

This should get you going.

Message Edited by Jhoskins on 08-01-2007 04:19 PM

Message Edited by Jhoskins on 08-01-2007 04:20 PM

[oddesycircuit]

Jhoskins,

I'm having some trouble finding the vi in the excel forum. 

Could you kindly link me to the thread where it was attached?

Thank you.

[Joe_H]

If you look on the excel board on reply # 2. I post a zip file of the toolkit in version 6I. The VI is burried in that toolkit.

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

Here is an older version that i found on my PC it may work for you.