using spreadsheet input csv data,how to get more row and column

[jinantan]

i just save excel file into csv format ,and then used  spreadsheet fuction to input csv data,but it only input  1 row,i need more 2 row and 4069 column data , how to do that  thanks !

[GerdW]

Hi jinantan,

can't look at your VI, but do you use the correct delimiter when parsing the spreadsheet data?

[crossrulz]

Why did you put the read function into a FOR loop?  And then you are only reading 2 lines at a time.

Your indicator "First Row" should actually be putting out the 3rd row while the "All Rows" should be showing the 3rd and 4th rows.  Get rid of the FOR loop and just read the entire file.

[jinantan]

because spreadsheet only read one column ,then i add for loop in order to acquire more data ,but it seems no useful

[jinantan]

my eidtion has been  2012 fall

[crossrulz]

The delimiter is likely a comma.  Change the delimiter (input on the botton of the VI) to be a comma.

[jinantan]

oh, i just  solved my question , to put semicolon delimiter under spreadsheet