How to determine the size of the data in an excel worksheet using Actice X?

[TulaRen]

What is the method or property to use to determine the data size of an excel worksheet using Active X?

Thanks.

Ian

[aputman]

There is an Excel Get Last Row function.  Ctrl+Space in the block diagram to search for it.  Is that what you are looking for?

[TulaRen]

Aputman,

Well, I need to know the numbers of the last row and the last column, and also I would like to read all the data of an excel worksheet dynamically from LabVIEW using ActiveX, assuming I do not always have Report Generation Toolkit.

Thanks.

Ian

[aputman]

---

@TulaRen wrote:

.... assuming I do not always have Report Generation

---

Why would you not always have it, if you sometimes have it?  I'm not sure what that statement means.  

If you do have it, the Excel Get Data VI will return an array of data for the entire worksheet, if the Start and End values are left unwired.  

If you don't actually have the RGT, I don't know what to tell you.  There has been another toolkit mentioned before but I don't remember the name.  The code for the RGT is not password protected so it's easy to open the block diagram and see how to do something.  However, in order to recreate that functionality, it would be a rather time-consuming endeavor, especially if you "don't always have Report Generation Toolkit."

[TulaRen · Accepted solution]

Actually, the "Excel_Calc_Bottom_RowNum" vi in RGT which gets the "Bottom Row Number" is pretty simple to understand (and modify)...

So now I do not always need RGT

Many thanks for your help.

Ian

[aputman · Accepted solution]

For your future questions on the board, it is probably not a good idea to ask someone a question and then mark your restatement of their answer as the solution.  Just sayin.....

[TulaRen]

point taken