Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello there,
would someone has a tip for me?
Please also let me know in case I post the qeustion in wrong board. Thank you.
Best regards,
Lan