Excel

Create new workbook - Creates a blank Excel file. Outputs a workbook identifier you can use to update the spreadsheet in subsequent steps.

Open existing workbook - Loads an existing Excel file. Outputs a workbook identifier you can use to update the spreadsheet in subsequent steps. Supports only Excel (.xlsx) files.

Save workbook - Saves updates to an Excel file. Allows you to update the file name and file type for the saved workbook.

Read sheet - Gets data from a range of cells. The output is stored in a data table variable containing rows and columns.

Read cell - Gets the value from a cell. Used to read an individual cell value from a worksheet.

Write to sheet - Outputs a data table to a sheet. Used to write a range of rows and columns to a worksheet.

Write to cell - Outputs a value to a cell. Used to update individual cells in a worksheet.

Write new row - Adds a row of data to the sheet. The new row will be appended to the end of the existing data.

Create new sheet - Adds a blank worksheet. The new sheet is added to the end of the workbook.

Copy sheet - Creates a copy of the worksheet. The new sheet will be created within the same workbook.

Rename sheet - Updates the name of a worksheet.

Delete sheet - Removes a sheet from a workbook. Cannot delete the last remaining sheet of a workbook.

Set cell color - Updates cell background color. Used to highlight a specific range of cells.

Get cell color - Reads the cell background color. Outputs the color in RGB hex code format (e.g., "FF0000" for red).

Hide rows - Makes rows hidden in the sheet. The data remains intact but will not be visible.

Unhide rows - Makes hidden rows visible. Used to show previously hidden rows.