Enhance Excel output for "Export to folder"
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!
Comments
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,582 NeuronIt'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.
-
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
-
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 :)
-
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
