How to hide column while export.

[developer]

Hi,

I'm trying hide the column while export to PDF or Excel. I've given hideColumn(index) in pdfExport. It is removing the column in PDF that's fine. But also removed from the Grid. 

find the code here => DOJO

Is there is any other way to hide specific column only in export?

Thanks!

[developer]

DOJO Example

[Rosen]

Hi,

You could use the promise accessible via the pdfExport event to show back the column after the document is exported. Similar to the following:

                            pdfExport: function(e) {
                                   e.promise.then(function() {
                  grid.showColumn(3);
                });
                grid.hideColumn(3);
            }

 

Regards,
Rosen
Telerik

 

 

[developer]

Hi Rosen,

The solution is working fine for PDF. But it is not working for excel.

Can you provide the solution to hide the columns while export to excel as well.

Thank you!

 

[Rosen]

Hi,

A possible way to hide columns during Excel export is discussed in this forum. Please give it a try and see if this helps.

Regards,
Rosen
Telerik