Skip to end of banner
Go to start of banner

excelReplaceRow

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

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

  • No labels