how to read spreadsheet in labview

[ASHLY19]

hello every one;

I want to read Excel sheet consist of a Matrix 3000x6825  using Labview, I already used the Read delimited spreadsheet block, but the problem is that the output array is only 3000x1 missing all other columns, How I can solve this problem?

[Bob_Schor · Accepted solution]

I notice you have not wired the "Delimiter" input (the pink dot on the bottom of the function).  By default, LabVIEW makes the delimiter for a Comma-separated Values (.csv) file the <tab> (\t) character (go figure!).  Replace this with a "," and see if you separate the (I'm assuming "comma-separated values") into 6825 columns.

Bob Schor

[aputman · Accepted solution]

I'm shocked that Bob didn't mention this  but a CSV file is not an Excel sheet.  An Excel sheet will have a file extension of XLS, XLSX or similar. 

Excel is capable of importing CSV files but so is every other spreadsheet application (Open Office Calc, Apple Numbers, etc). 

Proper terminology is important when solving a problem. 

[altenbach · Accepted solution]

I agree with Bob that you need to wire the delimiter with a comma (alternatively, you can export your excel sheet as txt instead of csv, giving you a tab as delimiter).

To see what's going on, read your file as string instead of numeric and you'll see that each array element is an entire row, converting an entire row to a numeric will of course give you only the first value.

[Bob_Schor]

---

@aputman wrote:

I'm shocked that Bob didn't mention this  but a CSV file is not an Excel sheet.  An Excel sheet will have a file extension of XLS, XLSX or similar. 

---

I "gave that lecture" already once today.  What, do you want me to sound like a Broken Record?

• BS Rant #1:  "Attach Code, not Pictures!?" 
• BS Rant #2:  "A CSV file is not an Excel file, just a Microsoft trick." 
• BS Rant #3:  "NIPM (in its current incarnation) can be a Nightmare." 
• BS Favorite:  "Asynchronous Channel Wires are the Cat's Meow".

Bob Schor