Skip to content

Commands for Microsoft Excel Creation, Manipulation & Validation

← Command Reference
This category of commands allows the automation to create, interact with (or manipulate or change values) and validate Microsoft Excel files within your application under test.

Representative examples of such interactions include (but not limited to):

  • Validating contents of Excel files created by your AUT from within your automated tests
  • Appending, Updating or Clearing data into/within Excel files
  • Creating an Excel file that can be used for browser upload into your AUT
  • Setting formulae in cell(s) of an Excel file

The table below lists the commands in the ascending alphabetic order within this category along with a brief description of the purpose of the command. By clicking on the hyperlinked command name in the table below, you can review more detailed information about a specific command that includes the syntax for you to follow while using the commands
Command Purpose
excelClearContentsWithinFile This command is used to clear the contents from the workbook/worksheet/worksheet range
excelCloneFiIe This command is used to create a duplicate copy of the original Excel file using the variable provided in the 'Target' field with a name as specified in the 'Value' field
excelSetFormulaeWithinFile This command is used to create/set the formula in the cells identified using the variable provided in the 'Target' field
excelSetRangeContextWithinWorksheet This command is used to create a new worksheet range in memory with a name as provided in the 'Value' field
excelSetRangeOffsetContextWithinWorksheet This command is used to create new range offset values in memory with a name as specified in 'value' field
excelSetWorkbookContext This command is used to create a new workbook context in memory with a name specified in the 'Value' field
excelSetWorksheetContextWithinWorkbook This command is used to create a new worksheet in memory with a name as specified in the 'Value' field

Feedback and Knowledge Base

(thinking…)