Writing Excel report using Write to Spreadsheet File

[LHX]

I have done up a VI that writes all of my 7 inputs and column headers into a csv Excel file for my report. However, most of column headers and data values of my Excel file are all squeezed together into 1 cell. How do I make each value and header occupy only 1 cell each?

[Norbert_B · Accepted solution]

Your "report file" is illformatted.

You name it "csv" which means "comma separated values". This file format requires the columns to be separated using a ','. Hence, the decimal point has to be a '.'. This is a common ASCII text file format for measurement values in american regions.

In Europe, the equivalent file format is a spreadsheet with tabulator as column separator (as you have in your csv). This gives the user the opportunity to either use '.' OR ',' as decimal point (regional dependency).

Excel has import filters for specific file formats. As far as i know, csv is a file format where such a filter is predefined... so it searches the file for ',' as column separator. Your file doesnt contain any.....

Norbert