Unable to generate data in single xls workbook
I am getting around 4,000 rows in a webtable. I need to export all these rows to excel . So I am using the right click button of mouse on the web table and using the functionality of Microsoft "Export to Excel" .
I have coded in vbs for the right click and selecting that menu option. <font color="red"> </font> . If I run it for 50 times it would be creating 50 excel workbooks.
If i read the data row by row using getcelldata and write to excel then it would be taking lot of time to read for 4000 rows and 10 columns...
Please suggest some alternative solution ...