Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, How can we copy a table chart to a excel and place it in a share point using app automation in Qlik cloud? any help would be appreciated.
Thanks, in advance.
Hello,
This is the starting point for learning how to work with the Microsoft Excel connector:
https://community.qlik.com/t5/Official-Support-Articles/How-to-Getting-started-with-Microsoft-Excel-...
You will find information on how to get table data from an application into excel in this article.
This example use OneDrive, but if you have a Drive Id for Sharepoint you can use that instead.
https://community.qlik.com/t5/Official-Support-Articles/Copy-and-update-data-to-Microsoft-Excel-shee...
If you don't have a Sharepoint Drive Id, then you can follow this guide to get the Drive Id from either a site or a group. To get Drive Id for groups admin permissions is required. It can take a long time to fetch all drives, so once you have it, I suggest you save it in the automation as a variable and use it for the blocks belonging to the Excel connector.
https://community.qlik.com/t5/Official-Support-Articles/How-to-Work-with-Excel-files-stored-on-Share...