Multi-worksheet xlsx Exporter [SOLUTION]

asoliev
asoliev Registered Posts: 3 ✭✭✭

Hey,

At the current moment, there is no way of me to export multi-worksheet Excel file to a folder without installing a plugin, so decided to create one. Very simple script and can be found here: https://github.com/akmalsoliev/dataiku_multi_sheet

Coming across some message boards noticed that the only purposed option was BytesIO, but that creates a corrupt Excel file. This script creates a tempfolder that is later discarded.

Hope this helps.

Answers

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭

    Thank you for sharing this with us @asoliev
    and welcome to the Dataiku Community!

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭

    Shameless plug but I'd love for you, after reviewing of course, to consider submitting this as a piece of Dataiku Inspiration! Let me know if you have any questions.

  • asoliev
    asoliev Registered Posts: 3 ✭✭✭

    sure, don't know how it works though

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭

    Thanks @asoliev
    I reached out to you directly to provide more info.

Setup Info
    Tags
      Help me…