Pulling data to excel via dataiku API

Risto

Hi,

I have an excel file that needs to be updated monthly with new data.. I'd like to know if its possible to pull data directly from dataiku dataset to an excel sheet. My goal is automating the excel data update without manually exporting the data each time from dataiku to excel. I would make this data pull scheduled inside excel instead.

I have an API key made for that project in dataiku and I wonder if excel could use that to pull the data into a sheet?

---

Operating system used: Windows 11

Turribeach

Hi, the following posts should help you do what you want:

https://community.dataiku.com/t5/Plugins-Extending-Dataiku/How-to-write-an-excel-file-in-a-folder-with-python-where-folder/m-p/19848#M1225

https://community.dataiku.com/t5/Using-Dataiku/Excel-Export-with-custom-style/m-p/32962