Support > Forums > OpenBots Studio > Data Table and Excel

Data Table and Excel

Karthik Kasaraneni

  • Reporter
  • Calender Icon December 06,2021 at 10:13 AM

How to append the datatable to Excel?

This forum has 172 topics, 459 replies, and was last updated 2 hours ago by Poornima Malv

Lakshmi Sukumar

  • Participant
  • Calender Icon December 13,2021 at 12:07 AM

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.

Karthik Kasaraneni

  • Participant
  • Calender Icon December 09,2021 at 4:11 PM

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.

Lakshmi Sukumar

  • Participant
  • Calender Icon December 09,2021 at 2:26 PM

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.

Karthik Kasaraneni

  • Participant
  • Calender Icon December 07,2021 at 11:14 AM

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

Karthik Kasaraneni

  • Participant
  • Calender Icon December 07,2021 at 8:01 AM

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?

Nataly Alvarado

  • Participant
  • Calender Icon December 06,2021 at 6:01 PM

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!

You are not authorized to reply, please click here to login and add your reply to this topic.