Excel Insert Cells VI

LabVIEW 2018 Report Generation Toolkit for Microsoft Office Help

Edition Date: June 2018

Part Number: 370274M-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Excel General VIs

Requires: Report Generation Toolkit

Inserts a new cell, row, or column into the current worksheet from a position that the row and column indexes specify.

If you use the name parameter to specify a named range, the VI inserts the object from the top left cell of the range.

Note  The position of the named range from which the VI performs the insertion does not change. However, other named ranges that are below or to the right of the insertion point shift position according to the number of rows or columns inserted.

report in is a reference to the report whose appearance, data, and printing you want to control. Use the Create Report VI to generate this LabVIEW class object.
mode sets the insertion mode.

0entire row (default)—The VI inserts a new row.
1entire column—The VI inserts a new column.
2shift cells down—The VI moves current cells down to insert new cells.
3shift cells right—The VI moves current cells right to insert new cells.
start specifies the position of the cell from which the VI performs the insertion.
rows specifies the row index.
columns specifies the column index.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
name specifies a named range from which the VI performs the insertion. If the named range covers multiple cells, the insertion appears in the top left corner of the range.
report out is a reference to the report whose appearance, data, and printing you want to control. You can wire this output to other Report Generation VIs.
error out contains error information. This output provides standard error out functionality.

WAS THIS ARTICLE HELPFUL?

Not Helpful