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
Accepted Solution
Posted: 2 years ago
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.