Admin Production ni-theme
Current Publication

ExcelRpt_GetCellDataType

LabWindows/CVI

ExcelRpt_GetCellDataType

HRESULT ExcelRpt_GetCellDataType (CAObjHandle worksheetHandle, char cellRange[], enum ExREnum_ExDataType *dataType);

Purpose

Gets the data type of the cell.

Parameters

Input
Name Type Description
worksheetHandle CAObjHandle A handle to an Excel Worksheet object.
cellRange char [] The range of an individual cell. This value should be a string containing the cell range, such as "A1". If the range contains multiple cells, this function will examine the uppper leftmost cell in the range.
Output
Name Type Description
dataType enum ExREnum_ExDataType The data type will be one of the following values:

ExRConst_dataDouble = CAVT_DOUBLE
ExRConst_dataString = CAVT_CSTRING
ExRConst_dataEmpty = CAVT_EMPTY
ExRConst_dataCurrency = CAVT_CY
ExRConst_dataDate = CAVT_DATE

Return Value

Name Type Description
status HRESULT A value indicating whether an error occurred. Function failure is indicated by a negative error code.

Error codes are defined in CVIversion\include\cviauto.h and <Program Files>\National Instruments\Shared\MSDTRedistributables\SDKHeaderFiles\8.1\winerror.h.

You can use CA_GetAutomationErrorString to get the description of an error code.

Additional Information

Library: Excel Report

Include file: activex\excel\ExcelReport.h

LabWindows/CVI compatibility: LabWindows/CVI 7.0 and later