How to use write to spreadsheet VI to export data to excel?

[GerdW]

Hi Vanessa,

that's ReplaceArraySubset.

You don't need it. Use a BuildArray instead, no need for shift register, array constant and ReplaceArraySubset…

[VanessaWen]

Hi Gerald,

I am referring to the array block that is connected to an empty string and a comma. Is it replace array subset as well?

Vanessa

[GerdW · Accepted solution]

Hi Vanessa,

that is ArrayToSpreadsheetString, also to be found in the array palette…

[VanessaWen]

Gerald,

Thanks a lot! 😄

Vanessa

[VanessaWen]

Hi Anand,

I have tried to use your code exactly. It works. However, I would like to add in header for each column. Any idea how should I start? Thanks!

Regards,

Vanessa

[P@Anand]

Check the attached VI. You don't need Insert into array when you are using Replace Array subset.

(I am not able to attach VI, thats why I have attached zip file.

[VanessaWen]

Hi Anand, 

The zipfile does not contain any vi. Perhaps you can share to me the basic idea to implement the column header?  Thanks!

Regards,

Vanessa

[P@Anand]

Check the attached snippet. This writes the header before starting the data acquisition.

Note: The data can be 1D or 2D array. If you find the data is not in proper column/row try to use Transpose array (While using the 2D array).

[VanessaWen]

HI Anand,

Great! Thank you so much for the explanation. I really appreciate it. Thank again. 

Regards,

Vanessa

[Neil_Helsel]

How did you get that to save as an .xlsx file because when I attempt to open the file excel says it can't read it?