How to import .xlsx file type to QTP

[qtped]

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.

[ankur1601]

Which version do you use in QTP?

[qtped]

QTP 11.5 version

[Ankur]

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