From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
10-04-2019 09:06 AM
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?
Solved! Go to Solution.
10-04-2019 09:19 AM
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
10-04-2019 11:45 AM
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.
10-04-2019 12:51 PM
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.
10-04-2019 10:56 PM
@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?
Bob Schor