Skip to content

Latest commit

 

History

History
41 lines (33 loc) · 2.83 KB

A2019.md

File metadata and controls

41 lines (33 loc) · 2.83 KB
Raw

A2019

A 2019 Excel Commands

  1. Basic ~> The Excel basic package allows you to automate normal excel processes without installing Microsoft Excel on the device, it includes 11 commands

  2. Advanced ~> The Excel advanced package allows you to automate tasks related to the workbook,worksheets,rows,columns and cell operations, it includes approximately 50 actions and requires MS Excel installed on device

The Excel Advanced Commands are classified into:

  1. Workbook Operations

    • Append Workbook: Adds all the worksheets from the specified workbook to the end of the currently open workbook
    • Convert Excel to PDF: Converts the entire eworkbook, specific worksheets in a workbook , or a CSV file to a PDF file
    • Create Workbook: Creates a Microsoft Excel workbook or a CSV file
    • Protect Workbook: Protects the workbook and its structure using a password and can also unprotect a workbook and its structure
    • Save Workbook: Saves the current workbook

  2. Worksheet Operations

    • Access password protected worksheet: Accesses a password protected worksheet in the current workbook
    • Create worksheet: Creates a worksheet in the current workbook
    • Get current worksheet name: Gets the name of the current worksheet and assigns it to a string variable
    • Hide worksheet: Hides a worksheet from the current workbook
    • Retrieve sheets count: Gets the number of sheets available in the current workbook and stores it in a number variable

  3. Row/Column Operations

    • Hide rows/columns in selection: Hides rows or columns in the current worksheet
    • Insert/Delete Rows or Columns: Creates or removes rows or columns from the current worksheet or CSV file
    • Read column : Extract data from a column and stores it in a list variable of string data type
    • Remove blank rows: Removes blank rows from the current worksheet.You can specify the range from which you want to delete the blank rows
    • Select cells/rows/columns: Select cells,rows,or columns from the current worksheet

  4. Cell Operations

    • Get Single cell: Retrieves the values from a single cell in a Microsoft Excel Spreadsheet or a CSV file and stores them in a string variable
    • Go to cell: Moves the cursor to a specific cell in a Microsoft Excel spreadsheet or a CSV file
    • Go to next empty cell: Finds the next empty cell in the current worksheet.You can specify whether to find the empty cell toward the left,right,up,or down
    • Set cell: Sets a value in the Active cell or Specific cell in a Microsoft Excel spreadsheet or a CSV file.You can also use this action to set a formula
    • Set cell formula: Sets a formula in the active cell or a specific cell in a Microsoft Excel spreadsheet or a CSV file.

  5. Excel Table Operations

    • Insert table column: Inserts a column in table
    • Delete Table column: Deletes a column in a table

  6. Export to PDF