Hiding Caption in Export to Excel

[Nagendra Thumuluru]

Hello,

I have many radgrids in my solution & most of them have export to excel feature implemented. Recently, we added Summay & Caption Statements to these grids in the ASPX files. In order not to show the Captions when the grid is displayed, I added a CSS class like "rgCaption" or "MasterTable_Default caption" or "DetailTable_Default caption".

Here is the example of the class.

.rgCaption
{
    position: absolute;
    left: -10000px;
    top: auto;
    width: 1px;
    height: 1px;
    overflow: hidden;
    visibility: hidden;
    line-height: 0;
}


So when the grid is displayed in the webpage, the caption is hidden. I also want to do something similar when I do the export to excel (using CSS). Currently all my exported excels show the Caption which I don't want. I can always say Grid.MasterTable.Caption = String.Empty() in OnExcelExportCellFormatting or OnGridExporting. But this approach would make me edit all of the pages where export is involved & is too tedious & time-taking. I also tried 

Any Ideas?

Thanks
Bobby

[Kostadin]

Hello Bobby,

I am afraid that you could not use a CSS rule to hide the caption in the exported file. The only possible solution is to hide the caption by removing it before exporting to to excel.

Regards,
Kostadin
Telerik