AWS quick high security documentation change
Summary
Expanded Excel actions documentation with detailed properties, notes, and best practices for each operation type
Security assessment
Added explicit note that macro execution is not supported in .xlsm files. This security control prevents potential malicious macro execution, addressing a common attack vector in document processing.
Diff
diff --git a/quick/latest/userguide/actions-excel.md b/quick/latest/userguide/actions-excel.md index cd243f55a..f2d736dce 100644 --- a//quick/latest/userguide/actions-excel.md +++ b//quick/latest/userguide/actions-excel.md @@ -4,0 +5,2 @@ +Create New WorkbookOpen Existing WorkbookSave WorkbookRead SheetRead CellWrite to SheetWrite to CellWrite New RowCreate New SheetCopy SheetRename SheetDelete SheetSet Cell ColorGet Cell ColorHide RowsUnhide RowsBest practices and limitations + @@ -7 +9,326 @@ - * **Create new workbook** \- Creates a blank Excel file. Outputs a workbook identifier you can use to update the spreadsheet in subsequent steps. +Excel actions enable you to read, update, and create Excel files in your automations. All Excel actions support both .xlsx and .xlsm file formats. Workbook identifiers maintain references across multiple operations. + +###### Note + +While values can be read from .xlsm files, macro execution is not supported. + +## Create New Workbook + +Creates a blank Excel file. Outputs a workbook identifier you can use to update the spreadsheet in subsequent steps. + +**Properties:** + + * **Workbook Identifier** (output): Variable name storing the workbook reference for future actions (default: `workbook_id`) + + + + +## Open Existing Workbook + +Loads an existing Excel file. Returns a workbook identifier you can use to update the spreadsheet in subsequent steps. Supports only Excel (.xlsx) files. + +**Properties:** + + * **Excel File** (required): The .xlsx file to open, typically stored in a variable (e.g., `my_file`) + + * **Workbook Identifier** (output): Variable name storing the workbook reference (default: `workbook_id`) + + + + +**File Requirements:** + + * Must be a valid Excel (.xlsx) file + + * File must be accessible as a media file object + + + + +## Save Workbook + +Saves updates to an Excel file. Allows you to update the file name and file type for the saved workbook. + +**Properties:** + + * **File Name** (required): Name for the saved file without extension (e.g., "Monthly Report") + + * **File Type** (dropdown): Output format - currently supports XLSX (default: XLSX) + + * **Saved File** (output): Variable storing the saved file object (default: `saved_file`) + + + + +## Read Sheet + +Gets data from a range of cells. The action stores the output in a data table variable. + +**Properties:** + + * **Workbook Identifier** (required): The workbook to read from (e.g., `workbook_id`) + + * **Sheet Name** (required): Worksheet or tab name (default: "Sheet1") + + * **Cell Range** (optional): Range specification - supports multiple formats: + + * Starting cell: "A2" (reads all data from anchor point) + + * Exact range: "A1:B10" + + * Column range: "A:B" + + * Row range: "1:3" + + * Empty: reads entire sheet + + * **Include Headers** (checkbox): Treats first row as column headers when enabled. When disabled, uses default naming (Column0, Column1, etc.) (default: TRUE) + + * **Data Table** (output): Variable storing the extracted data (default: `excel_table`) + + + + +**Formula Handling:** + + * The action automatically calculates formulas and stores results in the data table. + + + + +## Read Cell + +Gets the value from a cell. Used to read an individual cell value from a worksheet. + +**Properties:** + + * **Workbook Identifier** (required): The workbook to read from (e.g., `workbook_id`) + + * **Sheet Name** (required): Worksheet name (default: "Sheet1") + + * **Cell Reference** (required): Cell location (e.g., "A1") + + * **Cell Value** (output): Variable storing the cell content (default: `cell_value`) + + + + +## Write to Sheet + +Outputs a data table to a sheet. Used to write a range of rows and columns to a worksheet. + +**Properties:** + + * **Data Table** (required): The data table to write (e.g., `my_table`) + + * **Workbook Identifier** (required): Target workbook (e.g., `workbook_id`) + + * **Sheet Name** (required): Target worksheet (default: "Sheet1") + + * **Start at Cell** (optional): Starting position for data placement (default: "A1") + + * **Include Headers** (checkbox): Writes column headers when enabled (default: TRUE) + + + + +## Write to Cell + +Outputs a value to a cell. Used to update individual cells in a worksheet. + +**Properties:** + + * **Value to Write** (required): Content for the cell (e.g., "Order #12345") + + * **Workbook Identifier** (required): Target workbook (e.g., `workbook_id`) + + * **Sheet Name** (required): Target worksheet (default: "Sheet1") + + * **Cell Reference** (required): Target cell location (e.g., "A1") + + + + +## Write New Row + +Adds a row of data to the sheet. The new row is appended to the end of the existing data. + +**Properties:** + + * **Row Values** (required): Array of values for the new row, starting from first column (e.g., ["Q1", "Sales", 100]) + + * **Workbook Identifier** (required): Target workbook (e.g., `workbook_id`) + + * **Sheet Name** (required): Target worksheet (default: "Sheet1") + + + + +**Data Validation:** + + * Must provide values as an array format + + * Values are written sequentially starting from the first column + + + + +## Create New Sheet + +Adds a blank worksheet. The new sheet is added to the end of the workbook. + +**Properties:** + + * **Workbook Identifier** (required): Target workbook (e.g., `workbook_id`) + + * **Sheet Name** (required): Name for the new worksheet (e.g., "Sales Data") + + + + +## Copy Sheet + +Creates a copy of the worksheet. The new sheet is created within the same workbook. + +**Properties:** + + * **Workbook Identifier** (required): Target workbook (e.g., `workbook_id`) + + * **Sheet Name to Copy** (required): Source worksheet name (e.g., "Original Sheet") + + * **New Sheet Name** (required): Name for the duplicated sheet (e.g., "Original Sheet (Copy)")