Grid export excel includRowHeaders does not work

Grid export excel includRowHeaders does not work

Posted by: lost7l on 16 July 2023, 6:26 pm EST

• 

  lost7l

  • Post Options:
  • Link
    Copy

  Posted 16 July 2023, 6:26 pm EST

  hello thank you for your help.

  i find a solution for my devlopment from

  https://www.grapecity.com/forums/wijmo/wijmo-grid-row-headers-instead-of-column-headers
  
  .

  but next step was exporting excel by using

  https://www.grapecity.com/wijmo/demos/Grid/ImportExportPrint/Excel/Async/purejs
  
  .

  the thing is, ‘includeRowHeaders’ does not work.

  ‘includeColumnHeaders’ do work. i can see the column headers in excel file downloaded.

  but the cells in excel where row headers have to be there are representing just blanks. if i set the option ‘includeRowHeaders’ to false, the blank is disappeared. so i think the ‘includRowHeaders’ option is working but row headers were not having properties mapping to the option. in grid, it represents texts but maybe have no properties for exporting excel, i think.

  i want to represent row headers in the excel file exported. plz help me

• 

  anirudh.verma

  

  • Post Options:
  • Link
    Copy

  Posted 17 July 2023, 6:14 pm EST

  As per our understanding, the requirement is to export the grid along with the text present in rowHeaders. If this is correct, then to export the text present in rowHeaders, you have to use setCellData() method to set the data for that particular cell. This is required because the text set using the template will not be exported.
  
  Please refer to this sample for reference (Angular): https://stackblitz.com/edit/angular-vye1cn
  
  Please refer to this sample for reference: (PureJS): https://stackblitz.com/edit/js-tzcnma

  Regards
  
  Anirudh