Excel - Examples                                    How to use?

Example 1:  Copy the values in a particular column in an excel sheet to another sheet.

  1. Open the Task Editor from Tools -> Task Editor
  2. Double click on the 'Open Spreadsheet' command.
  3. Specify the session name lets say copy cells.
  4. Click on (...) button and select the excel spreadsheet from where you want to copy.
  5. Click 'Save' button.
  6. Double click on the 'Open Spreadsheet' command.
  7. Specify the session name lets say paste cells
  8. Click on (...) button and select the excel spreadsheet where you want to paste.
  9. Click 'Save' button.
  10. Double click on 'Get Cells' command.
  11. Specify the session name i.e. copy cells.
  12. Select 'Get Multiple Cells' and insert the range i.e. if your range is from cell C6 to C18, insert C6 in 'From Specific Cell' and C18 in 'To Specific Cell'.
  13. Start a Loop for 'Each row in an Excel Dataset' and set the session name as copy cells.
  14. Double click on 'Set Cells' command.
  15. Set the session name as 'paste cells'.
  16. In the cell value, Select the variable Excel Column and select the column no. as 1 as you are retriving values for one column.
  17. Click 'Save' button.
  18. Double click on 'Go to Cells' command.
  19. Set the session name as 'paste cells'.
  20. Select 'one cell below'.
  21. Click 'Save' button.

Example 2: To copy from excel into notepad.

  1. Open the Task Editor from Tools -> Task Editor
  2. Double click on the 'Open Spreadsheet' command.
  3. Click on (...) button and select the excel spreadsheet from where you want to copy.
  4. Click 'Save' button.
  5. Click on 'Get Cells'
  6. Select 'Get Multiple Cells' and insert the range i.e. if your range is from cell C6 to C18, insert C6 in 'From Specific Cell' and C18 in 'To Specific Cell'.
  7. Start a Loop for 'Each row in an Excel Dataset'.
  8. Make sure the notepad is open.
  9. Double click on 'Insert Keystrokes' command.
  10. Select the window title from the list for notepad.
  11. Select the variable Excel Column from the list on the right and insert the column no. as 1 as you are retriving values for one column.
  12. Insert a special ketstroke of [ENTER] after the $ExcelColumn(1)$ variable.
  13. Click 'Save' button.

Example 3: To run an excel macro in an excel spreadsheet.

  1. Open the Task Editor from Tools -> Task Editor
  2. Double click on the 'Open Spreadsheet' command.
  3. Click on (...) button and selct the excel spreadsheet which contains the macro.
  4. Click 'Save' button.
  5. Double click on the 'Run Excel Macro' command.
  6. Enter the macro name e.g. Macro1.
  7. Click 'Save' button.

Example 4: To delete entire row in an excel spreadsheet

  1. Open the Task Editor from Tools -> Task Editor
  2. Double click on the 'Open Spreadsheet' command.
  3. Click on (...) button and select the excel spreadsheet.
  4. Click 'Save' button.
  5. Double click on the 'Delete Cells' command.
  6. Specify a cell in the row which you want to delete.
  7. Select 'Entire Row' from Delete options.
  8. Click 'Save' button.