InsertRow Method (Int32, Int32, Int32)

Office Open XML

Inserts a new row into the spreadsheet. Existing rows below the position are shifted down. All formula are updated to take account of the new row.

Namespace:  OfficeOpenXml
Assembly:  EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)

Syntax

C#
public void InsertRow(
	int rowFrom,
	int rows,
	int copyStylesFromRow
)
Visual Basic (Declaration)
Public Sub InsertRow ( _
	rowFrom As Integer, _
	rows As Integer, _
	copyStylesFromRow As Integer _
)
Visual C++
public:
void InsertRow(
	int rowFrom, 
	int rows, 
	int copyStylesFromRow
)

Parameters

rowFrom
Type: System..::.Int32
The position of the new row
rows
Type: System..::.Int32
Number of rows to insert.
copyStylesFromRow
Type: System..::.Int32
Copy Styles from this row. Applied to all inserted rows

See Also