Display grid hidden columns in exported Excel or spreadsheet

[hirehop]

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

[paramvir]

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.

[hirehop]

Thanks its wrk