Skip to main content
The Excel — Add Worksheet step adds a new, empty worksheet to an existing Excel file in OneDrive or SharePoint. Use it before Write Row when you want a dedicated tab — for example, a fresh worksheet per agent run, per day, or per customer.

​
Prerequisites

  • The OneDrive Excel steps must be enabled on your workspace (feature flag: step-sdk-onedrive-excel).
  • A Microsoft OAuth credential with edit access to the file.
  • The Excel file already exists at the configured Path. The step does not create the file.

​
Inputs

Both Path and Worksheet Name accept {{variable}} expressions, so the name can be derived at runtime — for example Run-{{Helpers.currentDateTime}}.

​
Outputs

Reference these as {{Steps.Add_Worksheet.Worksheet.Name}}.

​
Examples

​
1) Create a dated worksheet, then write to it

  1. Add Worksheet
    • Path: /Logs/Agent Runs.xlsx
    • Worksheet Name: Run-{{Helpers.currentDateTime}}
  2. Write Row
    • Path: /Logs/Agent Runs.xlsx
    • Worksheet Name: {{Steps.Add_Worksheet.Worksheet.Name}}
    • Row Values: {{Steps.Run.Result}},{{Steps.Run.Duration}}
Using Worksheet.Name from the Add step is safer than hardcoding the same expression, because Excel may normalize names (for example, trimming or replacing invalid characters).

​
2) Conditionally add a worksheet

  1. List Worksheets.
  2. Compare step — does the list contain an entry with Name == "Today"?
    • If no → Add Worksheet with Worksheet Name = Today.
    • If yes → skip.
  3. Continue with Write Row to Today.

​
Notes and limitations

  • No file creation. The step requires an existing Excel file.
  • Name conflicts cause failure. If a worksheet with the same name already exists, Graph returns an error. Use List Worksheets to check first if you can’t guarantee uniqueness.
  • Excel name rules apply. Worksheet names cannot exceed 31 characters and cannot contain : \ / ? * [ ]. Graph rejects invalid names.
  • New worksheets are appended at the end of the workbook. Reordering is not supported by this step.