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]

Duplicate Post

[jimmykingboy]

do not know how to delete on of them

Spoiler

[RavensFan]

You can't.  That is a pointer to the first message so people don't waste time responding to a second message when you'd already be getting helped in the first.