LabWindows/CVI

ExcelRpt_Fill

HRESULT ExcelRpt_Fill (CAObjHandle worksheetHandle, enum ExREnum_ExFillOptions direction, char cellRange[]);

Purpose

Fills the entire range with values and formatting from another part of the range.

Parameters

Input
Name Type Description
worksheetHandle CAObjHandle A handle to an Excel Worksheet object.
direction enum ExREnum_ExFillOptions Specifies the direction used when filling the range. Selecting Down will take the values and formatting from the top of the range and apply it to all cells further down in the range.

It must be one of the following values:

ExRConst_UP = 1
ExRConst_DOWN = 2
ExRConst_LEFT = 3
ExRConst_RIGHT = 4
cellRange char [] A range of cells. This value should be a string containing the cell range, such as "A1" or "A1:D5".

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

Log in to get a better experience