Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser090
Contributor
Contributor

How to write excel file to share point?

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.

Labels (1)
1 Reply
J_Lindberg
Support
Support

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...