Excel Refresh Automation

AliTaghiyev

I want to create a scenario to refresh workbook once a day but as I understand Dataiku is typically used in cloud or server environments where direct interactions with local applications like Microsoft Excel through COM (Component Object Model) objects are not supported.

How can I run this python script in Dataiku?

Turribeach

Is the data you want to put in the Excel file in Dataiku? If is it’s much easier to use the Export to Folder recipe and set the export to be Excel. Otherwise please explain properly what goes in this Excel file and why Dataiku needs to be involved.