Enhance Excel export

[Turribeach]

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. 

[me2]

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.

[me2]

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]

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

[Turribeach]

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]

@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

[tgb417]

@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