How to append the datatable to Excel?
This forum has 172 topics, 459 replies, and was last updated 2 hours ago by Poornima Malv
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.
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.
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
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?
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!
You are not authorized to reply, please click here to login and add your reply to this topic.