Export to Excel in Landscape for printing

[Mike]

Is it possible to export a RadGrid to Excel so that it's page orientation is Landscape and that it's print setting is also Landscape?

[Kostadin]

Hi Mike,

If you are using Html based on export you could hook on HtmlExporting and add the following XML Options and style.

protected void RadGrid1_HTMLExporting(object sender, GridHTMLExportingEventArgs e)
    {
        e.XmlOptions = @"<xml>
                        <x:ExcelWorkbook>
                        <x:ExcelWorksheets>
                        <x:ExcelWorksheet>
                        <x:WorksheetOptions>
                        <x:Print>
                        <x:ValidPrinterInfo/>
                        </x:Print>
                        </x:WorksheetOptions>
                        </x:ExcelWorksheet>
                        </x:ExcelWorksheets>
                        </x:ExcelWorkbook>
                        </xml>";
        e.Styles.AppendFormat("@page{{mso-page-orientation:landscape;}}");
    }

If you are using ExcelML you could check out the following forum post.

Regards,
Kostadin
Telerik

[Mike]

The problems is that I have grouping on the bottom of the page and the XML only renders the data not the grid.  So, I would have to create all new footers on the fly.

[Kostadin]

Hello Michael,

I am afraid I was not able completely understand your scenario. Are you using a GroupFooterTemplate and this template is not exported? I test this scenarion on my end and it is working as expected. I attached the sample which I used to this forum thread so you could try it on your side.

Regards,
Kostadin
Telerik