Microsoft Excel

Microsoft Excel is a spreadsheet program used for organizing, analyzing, and visualizing data in tabular form.

Categories: productivity-and-collaboration

Type: microsoftExcel/v1

---

Connections

Version: 1

OAuth2 Authorization Code

Properties

Name	Label	Type	Control Type	Description	Required
clientId	Client Id	STRING	TEXT		true
clientSecret	Client Secret	STRING	TEXT		true
tenantId	Tenant Id	STRING	TEXT		true

---

Actions

Append Row

Name: appendRow

Append a row of values to an existing worksheet.

Properties

Name	Label	Type	Control Type	Description	Required
workbookId	Workbook ID	STRING	SELECT		true
worksheetName	Worksheet	STRING	SELECT		true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN	SELECT	If the first row is header.	true
row	DYNAMIC_PROPERTIES	null

Clear Worksheet

Name: clearWorksheet

Clear a worksheet of all values.

Properties

Name	Label	Type	Control Type	Description	Required
workbookId	Workbook ID	STRING	SELECT		true
worksheetName	Worksheet	STRING	SELECT		true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN	SELECT	If the first row is header.	true

Delete Row

Name: deleteRow

Delete row on an existing sheet.

Properties

Name	Label	Type	Control Type	Description	Required
workbookId	Workbook ID	STRING	SELECT		true
worksheetName	Worksheet	STRING	SELECT		true
rowNumber	Row Number	INTEGER	INTEGER	The row number to delete.	true

Find Row by Number

Name: findRowByNum

Get row values from the worksheet by the row number.

Properties

Name	Label	Type	Control Type	Description	Required
workbookId	Workbook ID	STRING	SELECT		true
worksheetName	Worksheet	STRING	SELECT		true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN	SELECT	If the first row is header.	true
rowNumber	Row Number	INTEGER	INTEGER	The row number to get the values from.	true

Update Row

Name: updateRow

Update a row in a worksheet.

Properties

Name	Label	Type	Control Type	Description	Required
workbookId	Workbook ID	STRING	SELECT		true
worksheetName	Worksheet	STRING	SELECT		true
rowNumber	Row Number	INTEGER	INTEGER	The row number to update.	true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN	SELECT	If the first row is header.	true
row	DYNAMIC_PROPERTIES	null