write in 2 columns

[noa_]

This VI writes in two columns, but it doesn't change commas by . and I need this

[noa_]

It works ok now.

Thanks a lot

[devchander]

Most welcome

[feanorou]

Hello Devchander,

your solution helped me as well. I see you used 'Array to spreadsheet string'. May I ask a for a check of the attached code?

I tried another way, treating 1D data and 2D data as separate arrays, but I get only the first column.

How would you modify this structure to get both? Maybe bundling to a single 2D array, then to Write To Spreasheet.vi?

Thank you

George

[johnsold]

George,

Did you look at the date of the last post in this thread before yours? It was 5 years ago.  Devchander has not been on the Forum for six months, unless he changed his user ID.  When a thread is that old, you are usually better off creating a new one and mentioning that you had read the old one but it did not solve your problem.

To answer your question: Look at the Detailed Help for the Write to Spreadsheet File VI.  It indicates that only one of the array inputs should be used at any time.  It the 1D array input is wired, the 2D array will be ignored.

Combine your two arrays into one 2D array and wire that to the Write to Spreadsheet File VI.

Lynn

[feanorou]

Thank you Lynn, you are right. I did not check the date and I thought it was better to keep a post in the same thread instead of creating another one for the same subject.