Hello,
The Excel Report instrument driver can be found in the following location.
C:\program files\national instruments\CVI71\toolslib\activex\excel\excelreport.fp
In this instrument there is a GetWorksheetAttribute function panel. It can be found under:
Excel Report>>Worksheet>>GetWorksheetAttribute
Using this function, you can access the ER_WS_ATTR_USED_RANGE and ER_WS_ATTR_USED_RANGE_LEN attributes. This will give you the information you need to determine what range of cells are used in the worksheet.
Scott Y
NI
