ExcelRpt_SetCellValue
- Updated2023-02-21
- 1 minute(s) read
HRESULT ExcelRpt_SetCellValue (CAObjHandle worksheetHandle, char cellRange[], enum ExREnum_ExDataType dataType, ...);
Purpose
Set the value of a cell in Excel.
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. | ||||||||||||||||||||
| dataType | enum ExREnum_ExDataType | The type of the value parameter being passed. You must select one of the following values:
|
||||||||||||||||||||
| value | ... | The value of the cell. The table below specifies the type of parameter that should be passed based on the selected value of the dataType parameter.
|
||||||||||||||||||||
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