Hello,

The selenium get table function only supports one table per command call. So, you would need to get each table by indicating a unique identifier in the command.

If the xpath is not possible, then we would need to take a look at the table's html information to build a selector that will properly point to each table.

Hi,

Basically the question is I have a web page which contains 5 to 10 tables, when I'm using selenoum get table function, it's fetching one table only.

Is there any way I can get all tables at once or I can get table by index, one by one.

I can't use the XPath here because I have multiple web pages.

Hello,

would it be possible to fetch the tables one at a time? or is it a requirement to get all tables at once?

Regarding the Excel exception, is this error occurring every time you use the Excel Save As command? If so, please make sure that the Excel file is being properly referenced by the bot. A good way to check this is by making the Excel automation visible temporarily, this will help you see if there is something interfering with the bot while it tries to save the spreadsheet. You can change visibility settings in the "Create Excel Application" command.

Also getting the COMException Like Exception from HRESULT? While save the workbook

Hi,

I have Multiple table in the website, When I'm using the Selenium Get table function Its only fetching the One Table, May I know is there any way to get multiple tables?

Hello Karthik,

You can use the Write Range command, located under the Excel command group in Studio. You can find a good example on how to interact with Excel by watching this video (you'll need to enroll to the OpenBots Academy course to be able to access it): Attended Automation - OpenBots Academy

Similarly, you can unlock very useful material, examples and guides by enrolling to Academy.

Let me know if you have any questions!