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
We've encountered an issue exporting this macro. Please try exporting this page again later.