excelReplaceRow

Owned by Jonathan Muse

Last updated: 32 minutes ago

1 min read

Description

Clears the specified row without impacting the index of any rows beneath of it.

Parameters

Return Type

Boolean

Returns true if the operation was successful, false otherwise.

Example

Opens a workbook, clears a row and then saves and closes the workbook.

use "excel";
int fid = openWorkbook("snakes.xlsx");
replaceRow(fid, "Venemous Snakes", 4);
closeWorkbook(fid);

Result: The row containing the Blue Krait snake (row 5) will be replaced with empty cells.

Click here to download the workbook used in this example.

See also