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	Description	Required
clientId	Client Id	STRING		true
clientSecret	Client Secret	STRING		true
tenantId	Tenant Id	STRING		true

---

Actions

Append Row

Name: appendRow

Append a row of values to an existing worksheet.

Properties

Name	Label	Type	Description	Required
workbookId	Workbook ID	STRING		true
worksheetName	Worksheet	STRING Depends On workbookId		true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN Options true, false	If the first row is header.	true
row		DYNAMIC_PROPERTIES Depends On isTheFirstRowHeader, worksheetName, workbookId		true

Example JSON Structure

{
  "label" : "Append Row",
  "name" : "appendRow",
  "parameters" : {
    "workbookId" : "",
    "worksheetName" : "",
    "isTheFirstRowHeader" : false,
    "row" : { }
  },
  "type" : "microsoftExcel/v1/appendRow"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Clear Worksheet

Name: clearWorksheet

Clear a worksheet of all values.

Properties

Name	Label	Type	Description	Required
workbookId	Workbook ID	STRING		true
worksheetName	Worksheet	STRING Depends On workbookId		true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN Options true, false	If the first row is header.	true

Example JSON Structure

{
  "label" : "Clear Worksheet",
  "name" : "clearWorksheet",
  "parameters" : {
    "workbookId" : "",
    "worksheetName" : "",
    "isTheFirstRowHeader" : false
  },
  "type" : "microsoftExcel/v1/clearWorksheet"
}

Output

This action does not produce any output.

Delete Row

Name: deleteRow

Delete row on an existing sheet.

Properties

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

Example JSON Structure

{
  "label" : "Delete Row",
  "name" : "deleteRow",
  "parameters" : {
    "workbookId" : "",
    "worksheetName" : "",
    "rowNumber" : 1
  },
  "type" : "microsoftExcel/v1/deleteRow"
}

Output

This action does not produce any output.

Find Row by Number

Name: findRowByNum

Get row values from the worksheet by the row number.

Properties

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

Example JSON Structure

{
  "label" : "Find Row by Number",
  "name" : "findRowByNum",
  "parameters" : {
    "workbookId" : "",
    "worksheetName" : "",
    "isTheFirstRowHeader" : false,
    "rowNumber" : 1
  },
  "type" : "microsoftExcel/v1/findRowByNum"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Update Row

Name: updateRow

Update a row in a worksheet.

Properties

Name	Label	Type	Description	Required
workbookId	Workbook ID	STRING		true
worksheetName	Worksheet	STRING Depends On workbookId		true
rowNumber	Row Number	INTEGER	The row number to update.	true
isTheFirstRowHeader	Is the First Row Header?	BOOLEAN Options true, false	If the first row is header.	true
updateWholeRow	Update Whole Row	BOOLEAN Options true, false	Whether to update the whole row or just specific columns.	true
row		DYNAMIC_PROPERTIES Depends On workbookId, worksheetName, isTheFirstRowHeader, updateWholeRow		true

Example JSON Structure

{
  "label" : "Update Row",
  "name" : "updateRow",
  "parameters" : {
    "workbookId" : "",
    "worksheetName" : "",
    "rowNumber" : 1,
    "isTheFirstRowHeader" : false,
    "updateWholeRow" : false,
    "row" : { }
  },
  "type" : "microsoftExcel/v1/updateRow"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.