Whether xlsx extension works while importing data sheet?

[Saket]

hey Fakruddin,
you missed the original query, its not about opening an xlsx file, its about importing the sheet to datatable
which is not supported in QTP yet.

try this in QTP

Code:

Datatable.importsheet("E:\Baba_QTP\QTP\Data\a.xlsx","Sheet1","Action1")

you can also try setting the same file as datatable in Setting>Resources

let us know if any of this works.