HotXLS-dokumentation Innehåll Startsida Översikt TGridToXLS IXLSWorkbook Startsida Innehåll Översikt

Insert metod

Inserts a cell or a range of cells into the Worksheet and shifts other cells away to make space

Syntax

function Insert(Shift: OleVariant): OleVariant; Shift OleVariant. Anger which way to shift the cells. Can be one of the following XlInsertShiftDirection constants: xlShiftToRight or xlShiftDown

Exempel

This example inserts a new row before row 3
Workbook.Sheets[1].Range['A3', 'A3'].EntireRow.Insert(xlShiftDown); Copyright © 2010-2026 losLab Software