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