LabWindows/CVI

ExcelRpt_RangeInsert

HRESULT ExcelRpt_RangeInsert (CAObjHandle worksheetHandle, char cellRange[], enum ExREnum_ExInsertShiftDirection insertShiftDirection);

Purpose

Inserts new cells into the worksheet.

Parameters

Input
Name Type Description
worksheetHandle CAObjHandle A handle to an Excel Worksheet object.
cellRange char [] The range where new cells should be inserted.

This value should be a string containing the cell range, such as "A1" or "A1:D5".
insertShiftDirection enum ExREnum_ExInsertShiftDirection Specify the direction to shift the existing cell range contents as the new cells are inserted. It must be one of the following values:

ExRConst_ShiftDown = –4121
ExRConst_ShiftToRight = –4161

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