Question
2
Replies
61
Views
Posted: July 20, 2018
Last activity: July 30, 2018
Closed
Solved
How do you get all items in a column from a web table and paste them in excel
I am quite new to RDA and currently doing some self-study. I have a web table and I would like to get all items in a specific column and paste them in excel.
I am having a bit of difficulty and confusion on how to handle the objects in a web table.
Would really appreciate it if someone can guide me on how to do this...thanks.
Adrian
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
So sorry for the late reply. Thanks a lot for the assistance. This solution worked perfectly fine.
I have attached a sample solution. I prepared a more lengthy tutorial but the upload erased my original comment. You'll need to understand how to access the Explore Component properties window to locate the RemoveAt method for the DataTableProxy's Columns property. You'll also need to understand how to extract a proxy.
You could also just iterate through your HTML Table using the InstanceCount property as the limit for a ForLoop and call the SetCellValue method of the Excel connector. This way would be a lot slower though.