Microsoft 365 Excel

Update cell in workbook

This action will update a single cell in the workbook you specify.

Developer info

API endpoint slug: excel_365.update_cell_in_workbook
Filter code method: Excel365.updateCellInWorkbook.skip(string?: reason)
Runtime method: runAction("excel_365.update_cell_in_workbook", {})

Action fields

Path Text input > Path to a folder

Label: Enter the folder path...
Helper text: Format: folders separated by "/" like "Documents/Expense reports"
Slug: path
Required: false
Can have default value: true
Filter code method: Excel365.updateCellInWorkbook.setPath(string: path)

Filename Text input > File name

Label: and enter the filename
Helper text: E.g. "report.xlsx"
Slug: filename
Required: true
Can have default value: true
Filter code method: Excel365.updateCellInWorkbook.setFilename(string: filename)

Worksheet name Text input > Other

Label: The name of the worksheet
Helper text: E.g. Sheet1 or Project Budget
Slug: worksheet_name
Required: true
Can have default value: true

Cell Text input > Other

Label: Which cell?
Helper text: Use A1 notation for a single cell e.g. A2 or B10
Slug: cell
Required: true
Can have default value: true
Filter code method: Excel365.updateCellInWorkbook.setCell(string: cell)

Value Text input > Other

Label: Value
Helper text: Value to be filled in the cell
Slug: value
Required: true
Can have default value: true
Filter code method: Excel365.updateCellInWorkbook.setValue(string: value)