how to read the column format date from excel and convert it to 1D array in labview

[jimmykingboy]

hi, guys, got a problem.#

with CAN analyser i saved all the date from the maschine in excel file(csv)( Attention: the date was save as only in one column).

Now i need the date to be read synchronized by LABVIEW. So I designed a small program.(Principle of the program: use spreadsheet string to Array function to read the excel date, then use Array Size Function to detect the size of the 1D array, the size minus one is the index of the last value of the date, at last by using Index Array Function to get the last date within a sample rate time ) as you can see below:

The problem is,  the Spreadsheet String to Array Function can only read the date from excel in row format. This means, Labview can only read A1, with the value  23. and then it readed B1(I tried once to write a value in B1 and labview can really read it), but not A2, A3,A4..... Of course it shows nothing from the second Read as you can see below:

I tried all the functions in Array but still cannot find one to solve it. 

Following is the file, if you want

[RavensFan]

Why don't you use Read From Spreadsheet File?

(I'm assuming your real file is actually a .csv and not an .xlsx like you posted.)

It gives you a 2-D array.  Then you can use index Array to get the 1st column.

[jimmykingboy]

thx. i tried your method but still didnt work

[RavensFan]

Post what you tried.  It worked for me.

[jimmykingboy]

Labview 2012

[jimmykingboy]

man can not upload csv file, i think it is not difficult for u to generate one by yourself. Thx

Spoiler

Spoiler

[apok]

[jimmykingboy]

thank u so much

[RavensFan]

No need for a loop.  The file shouldn't be reread every 100 milliseconds,