[Solved] Export RadGrid to Excel

[Juan]

Hello

In RadGrid in function to export (to Excel) as I do for the cell adapts to the size of the text?

Greetings

Juan

[Steve]

Hi Juan,

Can you point us to a scenario where this is not respected? Each column is exported in a new excel column and they do not overlap one another. Any additional information would be highly appreciated.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Juan]

Hello

The problem is as follows:
I have a radGrid with approximately 14 columanas, they have a long title as: "Customer name"
This title to be exported to the spreadsheet is not 100% visualized, is a hidden part.
The idea is that the export radGrid Excel cells are the size of the text and not to be hidden.

Greetings and thanks

Juan.

[Steve]

Hi Juan,

Thanks for the provided screenshot. We now understand what you mean and unfortunately this is the default behavior of the native export to ExcelML and cannot be overridden. If you want the widths of the columns to be properly preserved as in the web page, please use HTML export format:

RadGrid1.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;

Sorry for the inconvenience.

Regards,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center