Excel - How to use                               Examples

You can use this command to transfer data to and from your Excel spreadsheets.

Note: This feature is supported only in Microsoft Office 2000 and above.

It provides following commands:

  1. Open Spreadsheet
    This command is used to open an excel spreadsheet. You can also specify the session name and/or sheet name if your task involves working with many excel sheets and workbooks.
  2. Close Spreadsheet
    This command matches the Open Spreadsheet command. It closes the spreadsheet opened by the Open Spreadsheet command. It identifies the spreadsheet with the session name provided at the time of using the 'Open Spreadsheet' command.

  3. Get Cells
    Using this command, you can fetch the value(s) of the active/specific cell as well as for a range of cells from the spreadsheet opened by the Open Spreadsheet command. When you fetch values for an active/specific cell, you can assign its value to a variable from the list. However, when fetching values for multiple cells, the value is assign to the system variable $Excel Column (index)$ which you can use in 'Loop for each row in an Excel Dataset'.

  4. Set Cells
    Using this command, You can set the value for the active or a specific cell in the excel spreadsheet opened by the Open Spreadsheet command. You can also input the value of a variable in the sheet.
  5. Go to Cell
    Using this command, you can go to a specific cell or one cell left/right/above/below of the active cell or at the beginning/end of the row/column in the excel spreadsheet opened by the Open Spreadsheet command.
  6. Run Excel Macro
    Using this command option, you can run the excel macro which is stored in the excel spreadsheet opened by the Open Spreadsheet command.
  7. Delete Cells
    This command is used to delete values in the active/specific cell in the excel spreadsheet opened by the Open Spreadsheet command.