Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Enhance Excel export
Added on September 27, 2023 4:32PM
Likes: 0
Replies: 3
Turribeach
Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,370 Neuron
The Dataiku Excel export from datasets is pretty basic. Just the data, coloured column headings and that's about it. I would to see more advanced features added like enabling the column filters, adding a freeze pane in A2 so all column headers are frozen and renaming the Sheet1 name with the name of the Dataset.
Comments
-
Can that be done with a Python script? I've had similar ideas and I'm thinking of solving using MS365 apps such as Power Automate.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,370 Neuron
Yes of course it can be done with Excel but Dataiku aims to please two sets of users "coders" and "clickers". This is for the "clickers".
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,618 Neuron@Turribeach
As a person who is primarily a clicker. I appreciate this idea.
@me2
If you are willing to do a bit of coding. This thread has a bit of a discussion about how one might approach creating Ms excel file with more style.https://community.dataiku.com/t5/Using-Dataiku/Excel-Export-with-custom-style/m-p/32962