Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Absent Member.. vzamoraz Absent Member..
Absent Member..

QTP support tip: DataTable.ImportSheet corrupts exported XLS files

If individual sheets of a XLS file are imported using the DataTable.ImportSheet method, exporting the datatable with .Export creates corrupted files, that can neither be opened in Excel nor be used by any other application like QuickTest Professional. The size of this file is exactly 16 kbyte.



How avoid this:

The user should use the Import method of the DataTable Object rather than the ImportSheet method.


For reference you can check this Kb Article: DataTable.ImportSheet corrupts exported XLS files

Labels (1)
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.