Hello there,
we were using SQLTables function to get sheetnames in Excelfiles. But the files are migrated to SharePoint now. The SQLTables function will not work with SharePoint connection.
The Qlik Web Connector is installed. But I could not find a function to read the sheetnames.
Since there are a lot of dynamic sheetnames in each excel files, we hope it can be done without manually typing the sheetnames list.
Please help!
Thank you.
Lan
