Fit exported excel file to one page horizontally

[Kavita]

Hello telerik,
I have used Radgrid Export To Excel with format='ExcelML'.
I want exported excel sheet to fit all columns of grid into single page horizontally so that I can print it directly.
How can I achieve this?

[Kostadin]

Hi Kavita,

Thank you for contacting us.

In order to fit all columns into a single page when printing you have to set WorksheetOptionsElement's FitToPage to true. Check out the following code snippet:

protected void RadGrid1_ExcelMLWorkBookCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e)
{
    e.WorkBook.Worksheets[0].WorksheetOptions.FitToPage = true;
}

I hope this information helps.

Regards,
Kostadin
Telerik