Excel Refresh Automation
AliTaghiyev
Registered Posts: 3 ✭
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?
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,993 Neuron
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.