Enhance Excel output for "Export to folder"

jrmathieu63

I would like to request an enhancement to the "Export to Folder" recipe when exporting datasets to Excel format. Specifically, it would be extremely helpful if the export could support:

• Freezing the header row
• Adding auto filters to the header

These features are commonly used in Excel for better data readability and usability, especially when sharing reports with business users. Currently, this requires a workaround using a Python recipe, which adds complexity and may require additional permissions.

Thank you for considering this feature to improve the Excel export experience in Dataiku!

Turribeach

It's worth noting that the Python complexity could be easily removed by developing a Dataiku plugin after which users will be able to export to Excel using a simple recipe like the "Export to Folder". While I agree that having this feature built-in will be better you can solve this yourself in an equivalent way if you really want.

Han_Han

https://community.dataiku.com/discussion/45087/enhance-excel-output-for-export-to-folder

Hi @jrmathieu63,

Thanks for the feedback!

As you said, "These features are commonly used in Excel". I find it is quite easy to add the two things directly in Excel when I open the file in Excel.

Han