Set font for exported excel file

[Clive Hoggar]

Hi

I have an export to excel (plain, not ExcelML)  that looks fine, and the cell contens is aligned correctly
(eg numbers are aligned right), but i have not been able to find a way to set the default font for
the entire excel worksheet. It comes out Times New Roman, although the visible version of the
grid is default skin.

I have looked at various code snippets in the docs but no joy so far.

I guess this is really simple and I'll kick myself when I see it...

Thanks for your help

Clive

[Princy]

Hello Clive,

You can try out the following code to set the font of the grid while exporting, according to your requirement:
c#:

 protected void btnExport_Click(object sender, EventArgs e)
    {
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.Font.Name = "Arial";
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Princy.

[Clive Hoggar]

HI

Thanks.

I can confirm this does set the font in the style of the table that is exported,
when I open the file with notepad to look at the html.

However, Open Offfice calc ignores it - so I guess it is not a problem for this
forum any more.

Guess I'll need to by real excel to see if that is OK.

Regards

Clive

[Daniel]

Hello Clive,

OpenOffice Calc will use its default font - Times New Roman, regardless of your font settings. It uses different format, that is not supported by RadGrid. Microsoft's mso-number-format won't work also.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.