When I export datatable size of MS excel file to shoot up into MBs (24 MB) . (188 Views)
Reply
Advisor
pradeepsingh999
Posts: 35
Registered: ‎12-10-2012
Message 1 of 2 (188 Views)

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.



Thanks & Regards

Pradeep Singh

HP Expert
vzamoraz
Posts: 502
Registered: ‎04-12-2012
Message 2 of 2 (156 Views)

Re: When I export datatable size of MS excel file to shoot up into MBs (24 MB) .

Hi,

 

 

      What version of QTP are you using?

      Any patch installed?

 

Best Regards.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.