This is a migrated thread and some comments may be shown as answers.

Export to excel problem

3 Answers 61 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dharmesh
Top achievements
Rank 1
Dharmesh asked on 29 Jul 2010, 12:51 PM
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

3 Answers, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 29 Jul 2010, 05:03 PM
Hello Dharmesh,

Which format do you use - HTML Excel or ExcelML?

ExcelML export
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Dharmesh
Top achievements
Rank 1
answered on 30 Jul 2010, 05:40 AM
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
0
Daniel
Telerik team
answered on 05 Aug 2010, 09:57 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Dharmesh
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Dharmesh
Top achievements
Rank 1
Share this question
or