Microsoft 365 Excel

Add row to workbook

This action will add a single row to the bottom of the worksheet you specify in the workbook.

Developer info

API endpoint slug: excel_365.append_to_workbook
Filter code method: Excel365.appendToWorkbook.skip(string?: reason)
Runtime method: runAction("excel_365.append_to_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.appendToWorkbook.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.appendToWorkbook.setFilename(string: filename)

Formatted row Text input

Label: Formatted row
Helper text: Use "|||" to separate cells
Slug: formatted_row
Required: true
Can have default value: true
Filter code method: Excel365.appendToWorkbook.setFormatted Row(string: formatted_row)

Worksheet name Text input > Title

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