Unified Functional Testing (formerly QTP) News and Support Forum
Showing results for 
Search instead for 
Do you mean 

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

Highlighted

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 REPLIES
HPE Expert

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.