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 |