Export to excel problem

[Dharmesh]

I want to export the contents of a gridview to an excel document However the problems is
my telerik grid contains the time formate.
e.g:

Service                        AvgST            AvgWT
=================================================
Customer Services        00:04:35      00:43:30
Account Holder             00:02:37      00:11:36
Corporate Service        00:02:05      00:13:03
Sales Services              00:18:25     01:57:18
VIP                                00:02:54     05:02:59
Credit Card Services    00:00:00     00:00:00
Personal Loans            00:00:00     00:00:00
Services Details            00:16:58    04:34:56     
=================================================
TOTAL:                         00:47:34    12:43:22


When i tried to exporting it into excel, it will give me the wrong result(Time formate is wrong)

RESULT

Service                             AvgST            AvgWT
=================================================
Customer Services          12:04:35AM    12:43:30AM
Account Holder                12:02:37AM    12:11:36AM
Corporate Service           12:02:05AM    12:13:03AM
Sales Services                 12:18:25AM    01:57:18AM
VIP                                   12:02:54AM    05:02:59AM
Credit Card Services        12:00:00AM    12:00:00AM
Personal Loans                12:00:00AM    12:00:00AM
Services Details                12:16:58AM    04:34:56AM

and also grid footer not showing me

My Code is :

    protected void imgExcel_Click(object sender, ImageClickEventArgs e)
    {
         grdReport.ExportSettings.ExportOnlyData = true;
        grdReport.MasterTableView.ExportToExcel();
    }

can anyone help me?

My Telerik dll version is :2010.1.406.35

Dharmesh

[Daniel]

Hello Dharmesh,

Which format do you use - HTML Excel or ExcelML?

ExcelML export
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team

[Dharmesh]

hi,
i have use both the format (HTML Excel and ExcelML)
but it didn't work.

ya but i m export it into 'open office'.does it creates to any problem?


Dharmesh

[Daniel]

Hello Dharmesh,

Unfortunately OpenOffice is not supported out-of-the-box. Please mind that even though OpenOffice recognizes the Excel HTML file, it won't take the MS-specific styles like mso-number-format in consideration.

Best regards,
Daniel
the Telerik team