When I export datatable size of MS excel file to shoot up into MBs (24 MB) .
An excel file is where my test data is stored. When prepared for the first time it was in few KBs(200 KB) with 10 work sheets. Each of these work sheets are then imported to QTP during run time and some values are added to it. In last after executing all testcases , I exported datatable , the exported file size go up to 20-30 MB. the data added to the sheet is only into few cells and file is stored with the extension ".xls"
Any idea why this happens?
If not at least any solution to avoid/ overcome this?
I have googled a lot but not getting any satisfactory solution.