LabWindows/CVI

ExcelRpt_RangeDelete

HRESULT ExcelRpt_RangeDelete (CAObjHandle worksheetHandle, char cellRange[], enum ExREnum_ExDeleteShiftDirection deleteShiftDirection);

Purpose

Deletes cells from the worksheet.

Parameters

Input
Name Type Description
worksheetHandle CAObjHandle A handle to an Excel Worksheet object.
cellRange char [] A range of cells. This value should be a string containing the cell range, such as "A1" or "A1:D5".
deleteShiftDirection enum ExREnum_ExDeleteShiftDirection Specify the direction to shift other cell contents to fill the cell range of the deleted cells. It must be one of the following values:

ExRConst_ShiftToLeft = –4159
ExRConst_ShiftUp = –4162

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