Read value from excel

[kimtae]

I'm using LabVIEW 2015 without Report Generation Toolkit.

And I wanna read value from excel.

I got  a useful VI for that.

But It seems it had a limit on the number of columns.

I wanna read about 40 columns but it read only 26 columns.

Can you show me what property I should change?

[GerdW · Accepted solution]

Hi Kim,

---

@kimtae wrote:

I wanna read about 40 columns but it read only 26 columns.

---

Because of the way the cell "range" is created…

Compare the column labels in Excel with the column labels/ranges created in that VI!

Suggestion: You need to refine the way how those ranges are created…

[kimtae]

Hello, GerdW.

Thank you for write a comment about this.

I appreciate about it.

---

---

Because of the way the cell "range" is created…

Compare the column labels in Excel with the column labels/ranges created in that VI!

---

Where I should compare is these red circles?

I try changing the 'column' constant to 100 but it didn't work. 

The number of columns was limited to 26.

Or did you mean something else?

[RamonG · Accepted solution]

There are 26 letters in the Latin alphabet. After column "Z" Excel expects column "AA".

The range is calculated here:

The attached VI is from an old library which has served me well and should work for you.

Note that the rows and columns start at 1 not 0.

[kimtae · Accepted solution]

Ah That 26 was the number of Alphabet!!!!!

Thank you very much.

I will try to change my coding, referring your VI file.

Thank you very much and God bless you and have a good day and 

you will make many money.