Unified Functional Testing Practitioners Forum
cancel

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

Highlighted
pradeepsingh999
Trusted Contributor.

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

1 REPLY
vzamoraz
Outstanding Contributor.

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.