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

MollyHarras

Hi @jrmathieu63! I work for a partner with Dataiku, Aimpoint Digital, and we've developed a couple plugins that make writing to Excel files very easy. If the existing version of the destination Excel file has these features enabled, such as a frozen header row, the plugins can simply write data into the appropriate cells without interfering with the formatting.

If you'd like to learn more, I'd love to give you a demo. Our email is dataikuplugins@aimpointdigital.com :)

Han_Han

https://community.dataiku.com/discussion/comment/46319#Comment_46319

Hi Molly,

The plugins sounds like the right solution here! I am not really aware of that. Would love to see a demo too! Send you an email now.

Han