How can I convert 400 data points from a spreadsheet file to an array?

[H-man]

The spreadsheet file contains over 5000 data points (in one column) of which I only want the first 400 and want to convert them to an array in Labview. I tried to use the 'readfromspreadsheet' vi but it wasn't much help. Please tell me how i should approach this problem and what vi's to use.

[aderogba]

Use the number of row feature of "Read From Spreadsheet File" vi to specify that the first 400 row should be read. The default is -1 (all row). The output is either 1 or 2D array, in this case you only need to select 1-D array as your output.

[H-man]

the problem is that the data is in a column, not row and when i transpose in excel (to make data into a row), the data doesn't fit in the horizontal space. Please let me know if you know of any other ways or ideas.

[aderogba]

I attach a model vi that you can experiment with. You will need to know the formatting of the data in your file, from there -plus the delimiter- you'll be able to estimate how many characters makes the first 400 data point. It's possible to develop a more robust vi to do this, in the mean time, the attached vi can quickly give some answer.