Saving data from loops to excel file.

[huskeraztec]

Hello all,

Okay I am jammed up on this topic.   What I have is two while loops in parallel and I need to save the data from each loop in the same spreed sheet but on different pages.  I don't know if this is possible.  If not then just one spreed sheet with the data saved in columns.

On the one page I would need the Interlock data (supply pressure, return pressure, flow rate, and change in pressure) an on the next page I would need the power supply info,  (supply current, supply voltage, and voltage across the diode).  I also have a date time stamp and an operator initials and diode serial number that I would like to have on each page but not 100% a must just need to save somewhere in the file. 

I have the data going into table and table two respectivly, but don't need to view the tables.  I just used them as a test to see if the data was being passed correctly.

Any help would be much appriciated, and If anyone has any question about the problem I would be more then happy to answer them.  Thanks.

[Joe_H]

Hi, In order to save data to an excel file you will have to use ActiveX. I have posted a number of examples and a collection of VI's on the excel board in the breakpoint area.

Do you have the report generation toolkit?

Can you save all of your VI'S so that we can see how you are doing the save.

It's really not that difficult. Have a look at the example called write table to excel .VI

[huskeraztec]

I have the report generation toolkit, but not the MS toolkit.  I am really unfamililar with activeX. 

All my VI's are saved, but I have a few from a llb that was given to us from Sorsegn, (power supply) and Fluke.  I don't know it I can post those llb.

Do you have a suggestion on where to look for help with activex .

[Joe_H]

Yes I have already given you two. Look around the forum about ActiveX and also look in the example finder for activeX and you will find write table to excel example regardlees if you have the MStoolkit. Have a look at the excel board there are many VI'S in there for working with excel.

What version of labview are you using?

Message Edited by Jhoskins on 11-08-2006 04:18 PM

[Isa_pm]

Hi,

I use a very simple subVI to write my data to Excel. I collect my data to an array which is the input of the VI and that's it. In fact I have 2 subVI's: one for an array of strings and another one for array of nº. It is quiet simple and it writes to only one sheet, maybe it can help you. I join you a project where you can see the subVI in action.

Isabel

[Joe_H]

you are not writing to excel directly. You are writing data to a tab delimited file that excel has the ability to open. Doing it this way you cannot have it on seperate pages in excel. You MUST use activeX to write to excel directly you are not doing this. Look at the example called write table to excel. Also have a look in the excel board linked above.