LabVIEW
Select all rows in a specific column
Solved!
64864050 a écrit :
hi,
i have an excel file full of data and i would like to display it in labview table control
the number of rows in excel file is undefine but i know which colume there is.
so now im using report generation tool kit to read my excel file by setting the row and colume position, but if i set "-1" on both rows which is to read all, and the column position, an error occur.
anyway to solve it?
There is no problem with the -1 row index, as long as you read a single column.
To read multiple column you must define the start and end of the array block. Since you know your column number, you just have to determine the row number. You can use the Excel Get Last Row.vi, as shown below.
64864050 a écrit :
hi,
i have an excel file full of data and i would like to display it in labview table control
the number of rows in excel file is undefine but i know which colume there is.
so now im using report generation tool kit to read my excel file by setting the row and colume position, but if i set "-1" on both rows which is to read all, and the column position, an error occur.
anyway to solve it?
There is no problem with the -1 row index, as long as you read a single column.
To read multiple column you must define the start and end of the array block. Since you know your column number, you just have to determine the row number. You can use the Excel Get Last Row.vi, as shown below.
how do you unbundle it to become position (Excel).row ?
i got it like this instead of your example
Right click on the unbundle by name node, and select the output you need.
Remember : "Right click in LabVIEW is always your friend"
@Mdr20 wrote:
Could you please share the vi?
This thread is over 10 years old and there are at least two different VIs pictured. If you want the first code, recognize that it is a LabVIEW snippet and the picture already contains all you need.
