Excel Refresh Automation

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

Setup Info
    Tags
      Help me…