Micro Focus QTP (UFT) Forums
How to import .xlsx file type to QTP - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to import .xlsx file type to QTP (/Thread-How-to-import-xlsx-file-type-to-QTP)



How to import .xlsx file type to QTP - qtped - 03-05-2014

Hello

I know QTP only support .xls file type, however does anyone knows a way to import .xlsx file type into QTP. I am using the following syntax and it does not work.

Code:
DataTable.AddSheet ("Sheet_Name")
DataTable.ImportSheet "Excel_File_Name.xls", " Sheet_Name ", " Sheet_Name "

Your help is greatly appreciated.


RE: How to import .xlsx file type to QTP - ankur1601 - 03-09-2014

Which version do you use in QTP?


RE: How to import .xlsx file type to QTP - qtped - 03-12-2014

QTP 11.5 version


RE: How to import .xlsx file type to QTP - Ankur - 03-27-2014

The latest version UFT 12 provides full support for .xlsx extension.