2d array of strings write to measurement file.

[HEWI]

Does anyone know a funtion or trick to convert a 2d array of strings (with text and data) to dynamic data so that I can wire to write to measurement file function. I want to write the 2d array to excel file.

And no I dont have report generation toolkit.

Best regards,

WHW

[aputman]

Don't use the Write to Measurement File VI.  Instead use the Array to Spreadsheet String to convert the data to delimited format and the write it to a CSV file.  Or simply use the Write to Spreadsheet File (or the 2015 equivalent function).  CSV format is a text file but it will open up into Excel.

[HEWI]

Hi aputman,

Thanks for your reply. I understand the option for writing to CSV file but I need to have it written into an excel file.

Anyone any other options?

Regards,

WHW

[Kyle97330]

You can use ActiveX to open Excel and control it from within LabVIEW.

See here

[GerdW]

Hi HEWI,

use the functions from RGT (ReportgenerationToolkit), which is included in recent LabVIEW versions…

Or use ActiveX functions. Search the forum on this "How to write Excel files" topic, you will find a lot of threads here…

[aputman]

I thought RGT was standard these days, at least in the professional edition?  It can be accomplished using ActiveX if you have excel installed on the machine that will be running the program. 

[RTSLVU]

---

@HEWI wrote:

Hi aputman,

Thanks for your reply. I understand the option for writing to CSV file but I need to have it written into an excel file.

Anyone any other options?

Regards,

WHW

---

Well a CSV is an Excel file.

But if you want to write actual .XLSX files without the Excel report toolkit then activeX or a third party add-on like XLR8 is your only option.

[aputman]

---

@RTSLVU wrote:

---

@HEWI wrote:

Hi aputman,

Thanks for your reply. I understand the option for writing to CSV file but I need to have it written into an excel file.

Anyone any other options?

Regards,

WHW

---

Well a CSV is an Excel file.

But if you want to write actual .XLSX files without the Excel report toolkit then activeX or a third party add-on like XLR8 is your only option.

---

Not true.  CSV was around way before Excel.  It is simply a text document that was used for transfering data between machines.  Excel added support for reading the format but it is not an Excel file.  

[Bob_Schor]

It is not possible to put text as an element of a Dynamic Wire (so that it can be written to an .xlsx file by Write to Measurement File) because the Dreaded Dynamic Wire is a "wrapper" for arrays of Waveforms, which contain an array of numerics inside them.  Can't stuff text into a waveform.

Bob Schor