Issue with exported excel workbook

Issue with exported excel workbook

Posted by: nilesh_nichal on 7 May 2025, 2:46 am EST

• 

  nilesh_nichal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 May 2025, 2:46 am EST - Updated 7 May 2025, 2:51 am EST

  Hi Team,
  
  we are facing for exported excel workbook, where we are facing in
  
  1.Headers in plain text. (check below image attached for column section, we have in bold letter but while exporting it, it came in plain text instead of bold letter)
  
  2. Sheet name should be more relevant instead of having name as ‘Sheet1’. (This is below in tab section)

  For above both points please check the attached screenshot for reference.

  

  1067×702 57.5 KB

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 8 May 2025, 3:13 am EST

  Hi Nilesh,
  
  We are assuming that you are using the flexSheet control and exporting it to the Excel file using ‘flexSheet.saveAsync’ method. To keep the styles of the header row in a bound sheet, you’ll have to modify the workbook before export by adding the required styles in the header row cells and then export the file. You can get the workbook instance from the ‘saveAsync’ method, just do not pass the ‘fileName’ in this method to avoid direct exporting of the file.
  
  Regarding the sheet name issue, we didn’t face any such issue, the same name was exported in the Excel file as it was in the FlexSheet control. However, you can also modify the sheet name by setting the ‘name’ property of the sheet in the workbook instance.
  
  Please refer to the following sample for a better understanding - https://stackblitz.com/edit/angular-ivy-byehftwa?file=src%2Fapp%2Fapp.component.ts
  
  Regards