Excel ML Export Styling

[Mihai Dinculescu]

Hello

I've been able to set some properties like header, footer, margins, orientation, etc but I got stuck on others:
- header/footer right alignment
- PaperSize property
- PrintHeadings property
- Zoom property
- set scaling to "fit all columns on one page".

Any help will be greatly appreciated.

[Daniel]

Hello Mihai,

Straight onto your questions:

- header/footer right alignment

var wopt = a.WorkBook.Worksheets[0].WorksheetOptions;
wopt.PageSetup.PageHeaderElement.Data = "&R TEST";

- PaperSize property
The is no paper size property at this point. It may be added in a future release of RadControls for ASP.NET AJAX.

- PrintHeadings property
I'm not sure what this property is supposed to do. Please be more descriptive of your requirements.

- Zoom property
Not available in the current implementation. Will be added in a future version.

- set scaling to "fit all columns on one page".
Not available out of the box. You can set it manually this way:

RadGrid1.GridExporting += (s, a) =>
{
    a.ExportOutput = a.ExportOutput.Replace("</WorksheetOptions>", "<FitToPage/></WorksheetOptions>");
};

Regards,
Daniel
the Telerik team

[Mihai Dinculescu]

Thank you Daniel for the answers.

<FitToPage/> makes Excel fit the whole sheet on 1 page, while I only need It only to fit the columns. It looks like the "fit all columns on one page" requires the zoom to be calculated when the file is generated. It would be nice if you guys implement something that does this in the future. I imagine that fitting columns on 1 page is quite a used setting in Excel.

I'm not sure what PrintHeadings does either. I've taken it from a Macro which I had to replicate. Doesn't seem important so forget about it :)

It would be nice to have the PageSize property implemented in the future versions.

[Daniel]

Hello Mihai,

I have some good news for you. Most of these features will be available for the upcoming release of RadControls for ASP.NET AJAX which is expected in the next week.
I've also updated your Telerik points as a sign of gratitude for the suggestion.

Regards,
Daniel
the Telerik team