Importing Data from HTML table to excel file
Hi guys,
How can I import the data present in an HTML table to an excel file.?
I tried using the import data method, but "data table cannot be void" message is coming.
Regards
***Updated by moderator: Lochan to update Categories***
Dear Mitchell,
Thanks for the response, I am a newbie here and trying to learn software myself.
Please if you can help me how to create a data table, it will be very helpful.
Regards
Hi,
One other way is : Interrogate and Match the table with HTML table designer, Then by using a for loop you can actually read the data from the table and write back to excel
Regards,
Manas
can you give a sample automation? thanks
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.
You will need to create a DataTable and transform the data from the HTML Table to the DataTable, then pass that to the Excel Connector in order to successfully import the data.
The reason you are getting the message "DataTable Cannot be Null" is because you are not passing a parameter to the method call (no connection to the blue data point).