Page Comparison

Button handy

blank	true
color	#0052CC
name	Send Feedback
link	https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=excelReplaceRow+-+15485013
width	auto

Table plus

applyColStyleToCell	true
heading	0
columnTypes	s,s,s,s
multiple	false
columnAttributes	style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSorting	false

Syntax	excelReplaceRow(workbookFID, [worksheet_name,] rowIndex)	Package	excel
Alias		Pkg Usage	replaceRow(workbookFID, [worksheet_name,] rowIndex)

Description

Excerpt

hidden	true

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

...

Table plus

Parameter name	Type	Required	Description
workbookFID	Integer	Yes	The file id of the open workbook. The file id is returned from running the excelOpenWorkbook() routine.
worksheet_name	String	No	The name of the worksheet the row is on.
rowIndex	Integer	Yes	The row index of the row to be cleared (index starts at 0).

Boolean

Returns true if the operation was successful, false otherwise.

...

Code Block

language	js

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

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

Note
Click here to download the workbook used in this example.