Issue with Export Excel

Issue with Export Excel

Posted by: ypz23730 on 12 February 2023, 8:16 pm EST

• 

  ypz23730

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 February 2023, 8:16 pm EST - Updated 12 February 2023, 8:21 pm EST

  Hello Wijmo Team,
  
  I’m currently trying to disable gridlines when exporting excel. But I not found keyword for this. Does wijmo support this ??
  
  Thanks !
  
  

  

  930×699 29.6 KB

  

  926×647 30.8 KB

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 13 February 2023, 9:11 pm EST

  Hello,

  Unfortunately, there isn’t any method or property available to directly remove all lines in exported excel by setting Gridlines to false as of now. However, you can set the border styles of each cell in the exported excel as per your requirement i.e. remove cell borders from the grid in exported excel. Please refer to the sample link below demonstrating the same:

  https://stackblitz.com/edit/js-xgndid?file=index.js

  Regards

• 

  ypz23730

  • Post Options:
  • Link
    Copy

  Posted 21 February 2023, 6:20 pm EST - Updated 21 February 2023, 6:26 pm EST

  Thanks sonu ~

  But this solution did not solve my problem, my target is to keep the border of the table and turn off the gridlines of the rest on the sheet.

  Regards
  
  

  

  1478×960 65.6 KB

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2023, 6:15 pm EST

  Hello,

  Sorry but currently it wouldn’t be possible. As we already discussed that there isn’t any method or property available to directly remove all lines in exported excel by setting Gridlines to false as of now.

  I have raised an enhancement request to add support for Gridlines in grid export with an internal tracking ID WJM-26332. We will keep you informed of any updates on this matter as soon as we receive feedback from our development team.

  Regards