ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: hirehop on January 09, 2024, 08:32:15 pm

Title: Display grid hidden columns in exported Excel or spreadsheet
Post by: hirehop on January 09, 2024, 08:32:15 pm

Hello
right now i have facing some issue regarding export to excel,
have some dynamic coulms which are hidden and  that is okay while export its there in export but issue is only column width is 0.

i have tried with set width in colmodel, in eachcell function set manually width but its not working
please give some solution for set hidden column width in export excel

thank you

Title: Re: Export excel hidden column width
Post by: paramvir on January 10, 2024, 04:19:46 pm

From your message, it seems you have hidden columns in grid which you want to display in exported Excel.

To unhide the columns in exported Excel, please use eachCol callback parameter of exportData method.

Code: [Select]

eachCol: function(col){
col.hidden = false;
}

You can set width of visible columns in exported Excel.

Title: Re: Export excel hidden column width
Post by: hirehop on January 10, 2024, 07:55:00 pm

Thanks its wrk