Writing and Retrieving data from an Excel spreadsheet

[Rishabh]

Hi all

I am working on some battery chargers and need to record the data from my DAQ to an Excel Spreadsheet. How do i do that?

I don't wanna purchase the Office toolkit from Labview!

Please Help!

RJ

[smercurio_fc]

Did you try a search? No, really, did you actually try? Because your question gets asked, like twice a week.

First, try the Write to Spreadsheet File. No, it doesn't create an Excel workbook. It creates a text file which you can open in Excel.

Next, try the Write to Measurement File. Same deal.

Finally, if you don't like any of the above, go back to that search which you didn't do and look over the examples that use ActiveX to manipulate Excel. Including the examples that actually ship with LabVIEW. Did you look in there? You can also look in the Excel thread. NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD. It is a thread of links only.

[Rishabh]

Hi smercurio_fc

Hi Smercurio_fc,

Thanks for the reply. I really appreciate your help.

However, I would like to point out that after making numerous searches, I could not get any VI or thread working for my case. Most of the files complain regarding any of their missing sub-VI(s).

I myself don't understand the problem. I have even re-installed the application to shoot any of the possible installation errors. I m not a spammer.

I'll try to do what you have suggested in the former part of your reply.

Regards,

RJ

[smercurio_fc]

I never accused you of being a spammer. Where did that come from?

What examples/VIs have you looked at? Please post links so someone else can take a look at them.

As I noted, unless you absolutely have to have Excel workbooks (which requires that you use ActiveX), you are far better off using either the Write to Spreadsheet File or Write to Measurement File. 

[Rishabh]

Hi Smercurio_fc

Sry, I didn;t wanted to sound the way I did. 

My sole purpose is to record the data in a tabular form if possible so that it is easily observable at a later stage!

RJ

[smercurio_fc]

Then based on that, the simplest way is to use Write to Spreadsheet File VI. It's in the file I/O palette. The input to that VI is a 2D array of values. If your data is coming from DAQ VIs, such as the DAQ Express VIs then you can use the Write to Measurement File Express VI as it handles the evil dynamic data.

Please take a look at the examples that are installed with DAQmx. Help -> Find Examples ->  Hardware Input and Output -> DAQmx.