ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: kiwon34 on September 22, 2020, 09:21:37 am

Title: Export to excel with no frozen rows.
Post by: kiwon34 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 (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?

Title: Re: Export to excel with no frozen rows.
Post by: paramvir 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