Skip to content

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

NameLabelTypeControl TypeDescriptionRequired
clientIdClient IdSTRINGTEXTtrue
clientSecretClient SecretSTRINGTEXTtrue
tenantIdTenant IdSTRINGTEXTtrue

Actions

Append Row

Name: appendRow

Append a row of values to an existing worksheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
workbookIdWorkbook IDSTRINGSELECTtrue
worksheetNameWorksheetSTRINGSELECTtrue
isTheFirstRowHeaderIs the First Row Header?BOOLEANSELECTIf the first row is header.true
rowDYNAMIC_PROPERTIESnull

Clear Worksheet

Name: clearWorksheet

Clear a worksheet of all values.

Properties

NameLabelTypeControl TypeDescriptionRequired
workbookIdWorkbook IDSTRINGSELECTtrue
worksheetNameWorksheetSTRINGSELECTtrue
isTheFirstRowHeaderIs the First Row Header?BOOLEANSELECTIf the first row is header.true

Delete Row

Name: deleteRow

Delete row on an existing sheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
workbookIdWorkbook IDSTRINGSELECTtrue
worksheetNameWorksheetSTRINGSELECTtrue
rowNumberRow NumberINTEGERINTEGERThe row number to delete.true

Find Row by Number

Name: findRowByNum

Get row values from the worksheet by the row number.

Properties

NameLabelTypeControl TypeDescriptionRequired
workbookIdWorkbook IDSTRINGSELECTtrue
worksheetNameWorksheetSTRINGSELECTtrue
isTheFirstRowHeaderIs the First Row Header?BOOLEANSELECTIf the first row is header.true
rowNumberRow NumberINTEGERINTEGERThe row number to get the values from.true

Update Row

Name: updateRow

Update a row in a worksheet.

Properties

NameLabelTypeControl TypeDescriptionRequired
workbookIdWorkbook IDSTRINGSELECTtrue
worksheetNameWorksheetSTRINGSELECTtrue
rowNumberRow NumberINTEGERINTEGERThe row number to update.true
isTheFirstRowHeaderIs the First Row Header?BOOLEANSELECTIf the first row is header.true
rowDYNAMIC_PROPERTIESnull