I think I need to copy the data from HTML table to lookup and from there to excel sheet using import(). But not getting how to implement it. Could you please help me with this issue and try to explain with a small project on how to copy data from html table to excel sheet?
***Edited by Moderator Marissa to update platform capability tags****
Avoid lookup table. If you really need it then first create lookup table structure based on your html table data and then get table data from html table and use replace table of lookup table to copy the data from html table to lookup table. Now, use lookup table get table method (as a datatable) then pass this to excel importdata method.