Forum Discussion
Advocate IImport Excel template to Synapse, populate and push to Teams/Sharepoint
Hi AbiNyk,
I suggest you use a Python Notebook in Synapse and use the sharepoint API to upload files to the sharepoint site.
Here is an example of a Python script to upload an Excel file:
https://stackoverflow.com/questions/70574450/upload-file-to-sharepoint-using-api-postman#answer-78380860
First, you should get the right access token, preferrably with an app registration and access to the sharepoint site. This is how you receive the access token in sharepoint:
https://stackoverflow.com/questions/75795486/how-can-i-get-an-access-token-using-msal-in-python#answer-75800949
Community ChampionDo you mean Azure Synapse Analytics or Microsoft Fabric?
Does the Excel template just contain columns of data (i.e. table format, similar to a .csv) or is it more customized, i.e. similar to a form consisting of cells spread around the worksheet?
AbiNykI mean Azure Synapse Analytics .
The excel template contains pictures, sheets and text and the data area is predetermined, e.g. C4- H4 and down. Probably already containing headers. I thought of interacting with the files with Python through notebooks.