excelReplaceRow

Owned by Radu Dumitriu (Deactivated)

Last updated: Oct 29, 2024 by Jonathan Muse

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