Problem Scenario
Suppose you want to extract the table available on Wikipedia portal.
Pre requisite
Depending upon the browser you are going to use to complete this task, you have to download respective Automation Anywhere plugin. You can download the required plugin from plugin setting option available under Tools > Options.
For this demo, we are going to use IE Browser.
Solutions
Step 1 - Open Automation Anywhere Enterprise and choose Web Recorder as shown in the below screen.
Step 2 - Enter the url and click on the start button.
Step 3 - As you will click on Start button, You can also see a small window popup giving you tips of recording that wait for Browser to load page completely. Click on OK. (Note - If you will select the checkbox before the clicking on the OK button then Automation anywhere will not give you this popup next time when you will be using Web recorder again.)
Step 4 - Now you will be able to see Web Recorder window popup. Click on the Extract Table Button. As you will click on the button. You will be able to see a yellow tool tip stating that click on the table.
Step 5 - Click on the table that you are wiling to extract.(Note - Once you will hover the mouse over table, you will be able to see dark border around the table.)
Step 6 - If your table is spans across the multiple pages than, click on the checkbox and click on the capture button to capture Next button of the page. Otherwise click on the next button.
Step 7 - If there are multiple table on the page then enter the table no, Enter path of the csv output , If you want to append the current csv file then click on the Append to already existing csv file checkbox, Select encoding type you want, Enter the session name and then click on the finish button.
Step 8 - Click on the Stop Recording button. As you will click on Stop Recording button, Automation Anywhere will ask you for the name your bot. Enter the Name of the bot as per your desire and click on the save button.
Once you save your Bot, you can edit your bot using workbench . When you will edit this file in workbench, you will be able to see the Web Recording commands which has been captured to extract the table from the portal.