09-26-2013 11:11 AM
Hello LabVIEW community. I am going through a bumnch of ActiveX subVIs trying to figure out how to do something very simple. All I want to do is read an entire Excel Sheet and display it in an array. Single Page. Any help would be hot.
Solved! Go to Solution.
09-26-2013 11:37 AM
@DailyDose wrote:
Hello LabVIEW community. I am going through a bumnch of ActiveX subVIs trying to figure out how to do something very simple. All I want to do is read an entire Excel Sheet and display it in an array. Single Page. Any help would be hot.
Try this:
09-26-2013 01:42 PM
Is it possible to program this example to simply read all the columns and rows until it comes across like maybe 3 repetitive empty cells instead of having to specify which which row/column to end at?
09-26-2013 01:49 PM
@DailyDose wrote:
Is it possible to program this example to simply read all the columns and rows until it comes across like maybe 3 repetitive empty cells instead of having to specify which which row/column to end at?
Sure. Give it a shot and let us know how you solved it.
Cameron
09-26-2013 04:23 PM
@camerond wrote:
@DailyDose wrote:
Is it possible to program this example to simply read all the columns and rows until it comes across like maybe 3 repetitive empty cells instead of having to specify which which row/column to end at?
Sure. Give it a shot and let us know how you solved it.
Cameron
You're right! It was possible. Use For loops and check to see when empty cells begin to repeat. I named it GetXL_CellValues_2D_String_All.vi
I made mine though very dependent on my excel sheet. It's easy to make it excel sheet independent.