ironmansoftware / powershell-universal

Issue tracker for PowerShell Universal
https://powershelluniversal.com
36 stars 4 forks source link

Add Custom Export Options for UDDataGrid (Excel Export and Filtered Data Support) #3875

Closed RubenT91 closed 1 week ago

RubenT91 commented 3 weeks ago

Summary of the new feature / enhancement

As a user, I want the ability to customize the export options in the UDDataGrid component within PowerShell Universal, specifically to remove the default "Download as CSV" and "Print" options and add custom export options. For example, I want to add options such as "Export All (xlsx)" and "Export Filtered (xlsx)" to handle large datasets and custom Excel formatting.

Proposed technical implementation details (optional)

Provide the ability to hide or remove the default export options (e.g., "Download as CSV," "Print") in the UDDataGrid dropdown menu. Allow users to add custom export options, such as "Export All" and "Export Filtered" in Excel format. Ensure that the $EventData from the grid can be accessed in the export event handler, allowing users to write custom queries to fetch the correct data. Enable formatting the data before exporting, so that the export output meets specific requirements in Excel format.