Excel value range with Report Generation Toolkit

[jyang72211]

I have an excel sheet.  I want to find out the range for cells with values.  At least, I want the find out what's the last row that has values in it.  I tried "Excel Get Last Row.vi" in the report generation toolkit, but it would treat a blank cell as a valued cell if it is filled with another color.  Therefore, that won't work. 

I don't want to use active x, and I don't want to write a separate vi to search for the last row.  I want to see is there a way to use the report generation toolkit.  Can I somehow get a hidden method from the class?  I would think that, since they are charging for the report generation toolkit, a simple function like that should be included.  Thanks!

[Kenny_K]

I am pretty sure that the Report Generation Toolkit does use ActiveX, so you are using it even if you dont want to.

Seems to be how the UsedRange function is being used in the toolkit.

See here for some examples: http://blog.contextures.com/archives/2012/03/01/select-actual-used-range-in-excel-sheet/

I tried, and it does not find the blank cells with colored backgrounds.

This will require some activeX modifications though.

[jyang72211]

So you tried Excel get last row.vi, and it worked?  Try this, besidies filling the cell with color, put a border around the cell as well. 

[PackersFan]

Kenny is correct, the Report Generation Toolkit is nothing but VIs that use ActiveX.  As such, you will not find any "hidden" methods.

From what you are saying the Report Generation Toolkit does get the last used row in and Excel sheet, just not in the particular way you want.

You can try to use ActiveX to extend the toolkit, but the toolkit's functionality is limited to whatever ActiveX interface Microsoft exposes for Excel.  If there is not ActiveX method for that, you can be certain the Report Generation Toolkit will not be able to do it either.