Export Flexgrid with RowDetails to Excel

Export Flexgrid with RowDetails to Excel

Posted by: handerson on 11 July 2024, 11:21 pm EST

• 

  handerson

  • Post Options:
  • Link
    Copy

  Posted 11 July 2024, 11:21 pm EST

  Hi, is there somewhere an example on how to export a Flexgrid with RowDetails to Excel in Angular?

  Best regards
  
  Helge

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 15 July 2024, 3:21 am EST

  Hi Handerson,

  Sorry, but exporting detail rows with FlexGrid to an Excel file is not yet supported in Wijmo Flexgrid. We have created an enhancement request to support this feature, with internal tracking ID - WJM-34367. We will update you when this feature will be supported.

  Regards

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 23 July 2024, 3:11 am EST

  Hi Helge Anderson,

  We have an update from the dev team, i.e. Creating a one-size-fits-all solution for exporting detailRow content to Excel is pretty much impossible. The way FlexGrid is designed allows users to include any kind of HTML elements, controls, and other web content in the detailRow. This makes it really difficult to create a universal method to accurately export all that content to Excel while keeping it looking the same as it does in FlexGrid.

  However, we’ve come up with a workaround that exports just the content of the FlexGrid or the HTML present in the detailRow cell. Applied some styling as well to make it look similar to how it appears in the grid, but there are some limitations on what we can insert in Excel cell’s making it hard to get an exact match. This workaround should be a good alternative for now.

  Sample link: https://stackblitz.com/edit/js-ssdkjk?file=index.js

  We will update you when we have more updates from the dev team.

  Regards