Store Multimeter data (outputs) in Excel file

[Mr. Samir]

Hello,

I am using multimeter and i have it's own VI's. and I want to store outputs to the excel file. what should I do?

I am using FLUKE Multimeter. I am attaching my Program. Plz.. give me suggetions.

Thank you,

Samir

[tbob]

Your attached vi has 3 subvi's that are missing.  But anyway, do you want to create an actual Excel spreadsheet or would a tab delimited file work.  A tab delimited file contains the data, but does not have the special Excel formating (like Bold, Font, Text Color, etc).  This is what most people use.  Tab delimited files can be opened by Excel and look like real Excel files.  They can also be opened by Notepad because it is just plain text.

To write to a tab delimited file, simply use the Write To Spreadsheet File function found in the File palette.  To write to an actual Excel file with all of its formatting, you need the Report Generation Toolkit for Microsoft Office.  This contains special subvi's that will create and read actual fully formatted Excel files.

It is a lot easier to just use a tab delimited file.

[Mr. Samir]

Hi ttob,

What other 3 vi's are missing?

and thank you fro telling me that for excel sheet. but I want to know that at what vi's i have to use to connect to the "write to the excel sheet" vi's. what pin and wht vi's i have to use?

Thank you once again,

Samir

[RavensFan]

3 subVI's Initialize, Read, and Close that come from the Fluke's driver library.  Your VI consists of nothing but them and a loop.

I don't know what you mean by "what pin and what VI's do I have to use".  What do you mean by "pin"?

The Write to Spreasheet File in the File I/O palette is the one to use to output data to a delimited text file that Excel can open/import.

[Verne_D]

Hi Samir,

You may want to examine some of the LabVIEW examples. If you navigate to Help>Find Examples and then look in the Fundamentals>File Input and Output folder. The Using Spreadsheet Format.vi example might be a helpful starting point.

Also, for Excel specifically (if you have the Report Generation for Microsoft Office toolkit), try the example finder folder Toolkits and Modules> Report Generation for Microsoft Office and select the Sample Report (Excel).vi, which may offer other insight to your problem. Hopefully this helps!

[Tia77]

Hi i want to know how can i store the readings of graph in a file

[GerdW]

Hi Tia77,

is your question related to the one of the OP? Or don't you know how to create a new thread?

A possible solution is shown in the attachment!

[Tia77]

Thanks for your help..i modified program little bit, so that it can save data only when i want to save.

But it is replacing all the values took last time and overwriting it.

Can you please help me i want to store all the values whenever i run the program

according to time and date.

[kekin]

Its really simple dud.

Use "Get Date/Time string" function & then use "build array" on date & time string output to form a 1D array which is input to "write to spreadsheet file.vi".

The first write the data & then again use "write to spreadsheet file.vi" & make sure that "append to file" input is set to TRUE.

If u want to write time first then writh time first with append to file input FALSE & then write data with append to file input TRUE. The choice is yours.

[Tia77]

Can you please show me in program..i think i am making some mistake...thanks