Author Topic: Export to excel with no frozen rows.  (Read 1457 times)

kiwon34

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 52
    • View Profile
Export to excel with no frozen rows.
« on: September 22, 2020, 09:21:37 am »
Hi,

  I want to export data to excel sheet with no frozen rows.
  https://stackblitz.com/edit/paramquery-demo-ndv8i4?file=index.js

  I have put an example in the above link.
  I tried to change the frozenRows to 0 when "workbookReady" event is triggered, and as I open the excel file, I get the error message of wrong format.
  I think there should an exception for 0 frozenRow.

Or is there a way to use frozenRows=0 when exporting to excel?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Export to excel with no frozen rows.
« Reply #1 on: September 22, 2020, 10:06:24 pm »
I'm not facing any error when opening the xlsx file.

However you may also set it to undefined.

https://stackblitz.com/edit/paramquery-demo-mpzsgc?file=index.js