Exporting Data with Multiple Columns in excel using Write Delimited Spreadsheet.vi

[jasonrenz]

Hello,

I am trying to export data into an excel file and I found that it is possible by using the Write Delimited Spreadsheet.vi. However, I would want to insert the data in two columns as shown in the code attached. When I wire this 2d data into the vi function, I was able to export the 2d array data in csv format (also attached). But, the columns of the 2d array are just separated by commas(,) and are stored in just one column. Is there a way wherein each columns of the 2d array from LabVIEW will also be separated by columns in the excel file?

[crossrulz]

I just opened up your CSV file in Excel 2013 and I see two rows and a bunch of columns.  Perhaps you have a bad setting somewhere in your copy of Excel?

[jasonrenz]

I am using Excel 2016, and this is what I see. Do you have an idea where that setting could be changed?

[jasonrenz · Accepted solution]

I found a solution. The problem was not with the code. The settings of my excel was the problem. I just followed the instructions here for changing the setting. 

https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/

[Gregory]

You can also use "text to columns" if your data is already open in Excel.