07-27-2010 09:53 PM
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?
Solved! Go to Solution.
07-28-2010 03:57 AM
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.
07-28-2010 03:57 AM
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.
07-28-2010 04:40 AM
how do you unbundle it to become position (Excel).row ?
i got it like this instead of your example
07-28-2010 04:47 AM
Right click on the unbundle by name node, and select the output you need.
Remember : "Right click in LabVIEW is always your friend"
07-28-2010 08:49 PM
thanks alot!
thats was a great help
still new to labview. haha
07-28-2020 06:48 AM
Could you please share the vi?
Thank you in advance!
07-28-2020 09:31 AM
@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.