Write array data and mean to a Excel

[Costa]

I want to write an array of data to a excel file and the same time i want to write average of that data array to the same excel file at the bottom. (Also Max and Min values with headings) Please help

[aderogba]

Attached is a sample VI. There are many ways to accomplish what you want to do. I'll suggest you check FIle I/O Examples in LabVIEW help for additional example vis.

[Costa]

Hi Aderogba, thank you for the reply. Please have a look at the test.xls. Then you will understand what im trying to do. Please explain how can i achieve this, sort of writing?

[Randy_H]

Costa,

I agree with Aderogba that there are many ways to do this. You could take his example and add a few extra functions to add the text that you want. You can then import this text file into excel to save it as a worksheet.
If you do not want to do the import part, then you will need to use ActiveX and place the data into an Excel worksheet manually. There are many shipping examples that demonstrate how to add data to an Excel spreadsheet.
I have attached an example that is very similar to the original one, but adds a few more items to get the data you needed and the format you want. You will then need to save this string to a file and then import it into Excel.

Randy Hoskin
Applications Engineer
National Instruments
http://www.n
i.com/ask

[Costa]

Hi Randy Hoskin, Thanks for the help,i got it working. Thanks gaing..