Read and Display an Excel Sheet

[DailyDose]

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.

[AnkitG]

---

@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:

How Can I Read Excel Data Into LabVIEW?

[DailyDose]

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?

[camerond]

---

@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

[DailyDose · Accepted solution]

---

@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.