[Solved] RadGrid Format problems on HTML Export Excel 2003

[Fabian]

Hello Support,

I use the Excel Export functionallity to Export from the Radgrid into Excel.

With Excel 2007 all works fine, but in Excel 2003, after exporting a few rows, the cell format ignored.

For example 4500 Rows , the first 15 are in correct format, the following  rows are in "general" Format. Because the Export will used later with macros, it is very importend to get the correct format in all rows

<telerik:RadGrid ID="rdgSelektionResult" ShowGroupPanel="true" AllowPaging="True"
        Height="480px" Width="100%" AllowSorting="True" runat="server" PageSize="10"
        AllowFilteringByColumn="false" AllowMultiRowSelection="False" EnableLinqExpressions="false"
        GridLines="None" ShowStatusBar="true" OnPageIndexChanged="rdgSelektionResult_PageIndexChanged"
        OnSortCommand="rdgSelektionResult_SortCommand" OnNeedDataSource="rdgSelektionResult_NeedDataSource"
        OnColumnCreated="rdgSelektionResult_ColumnCreated">
        <clientsettings allowexpandcollapse="false" allowcolumnhide="true" allowcolumnsreorder="true"
            allowdragtogroup="true" allowgroupexpandcollapse="true" allowkeyboardnavigation="true">
                    <Scrolling UseStaticHeaders="true"  AllowScroll="true" SaveScrollPosition="true" />
                 </clientsettings>
        <groupingsettings showungroupbutton="true" />
        <pagerstyle mode="NextPrevNumericAndAdvanced"></pagerstyle>
        <MasterTableView DataKeyNames="RowKey" EnableHeaderContextMenu="true" AllowMultiColumnSorting="true"
            ShowGroupFooter="true" TableLayout="auto">
                 <ItemStyle Width="100" />
                 <HeaderStyle Width="100" />
                 <AlternatingItemStyle Width="100" />
        </MasterTableView>

    </telerik:RadGrid>

 public void ConfigureExport()
        {
            rdgSelektionResult.ExportSettings.ExportOnlyData = true;
            rdgSelektionResult.ExportSettings.IgnorePaging = true;
            rdgSelektionResult.ExportSettings.OpenInNewWindow = true;
            rdgSelektionResult.ExportSettings.FileName = "Selektion_" + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + base.Page.User.Identity.Name;
        }

 void HeaderControl_OnExportClick()
        {
            if (!string.IsNullOrEmpty(base.Request_CurrentRowKey))
            {

                rdgSelektionResult.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;
                ConfigureExport();

                base.Page.ApplyView(rdgSelektionResult, base.Page.CurrentListe.DefaultView, false, false, false,true);
                rdgSelektionResult.MasterTableView.ExportToExcel();

            }
        }

 protected void rdgSelektionResult_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
        {
            if (e.Column is GridBoundColumn)
            {
                GridBoundColumn column = (GridBoundColumn)e.Column;

                if (column != null)
                {
                    if (column.DataType == typeof(Guid))
                        column.Display = false;


                    if (column.UniqueName == "Land" || column.UniqueName == "ColumnLand")
                    {
                        column.HeaderText = Properties.Resources.Alle_Land;
                    }
                    else if (column.UniqueName == "Sender" || column.UniqueName == "ColumnSender")
                    {
                        column.HeaderText = Properties.Resources.Alle_Sender;
                    }
                    else if (column.UniqueName == "Sendung" || column.UniqueName == "ColumnSendung")
                    {
                        column.HeaderText = Properties.Resources.Alle_Sendung;
                    }
                    else if (column.UniqueName == "Datum" || column.UniqueName == "ColumnDatum")
                    {
                        column.HeaderText = Properties.Resources.Alle_Datum;
                        column.DataFormatString = "{0:dd.MM.yy}";
                    }
                    else if (column.UniqueName == "dtmStart" || column.UniqueName == "ColumndtmStart")
                    {
                        column.HeaderText = "Zeit";
                        column.DataFormatString = "{0:HH:mm}";
                    }
                    else if (column.UniqueName == "SendungsArt" || column.UniqueName == "ColumnSendungsart")
                    {
                        column.HeaderText = Properties.Resources.Alle_Sendungsart;
                    }
                    //else if (column.UniqueName == "RW Sendung (Zielgruppe Standard)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "MA Sendung (Zielgruppe: Standard)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "RW (Beitrag) (Zielgruppe Standard)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "MA Beitrag (Zielgruppe: Standard)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Bemerkung")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Wettbewerb")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "WettbewerbOffizname")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "WettbewerbOrt")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "Wettbewerbsbeginn" || column.UniqueName == "ColumnWettbewerbsbeginn")
                    {
                        column.DataFormatString = "{0:dd.MM.yy}";
                    }
                    else if (column.UniqueName == "Wettbewerbsende" || column.UniqueName == "ColumnWettbewerbsende")
                    {
                        column.DataFormatString = "{0:dd.MM.yy}";
                    }
                    //else if (column.UniqueName == "Anlass")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Ereignis")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Sportart")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "SportartAnhang")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Disziplin")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "Ereignisbeginn" || column.UniqueName == "ColumnEreignisbeginn")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:dd.MM.yy}";
                    }
                    else if (column.UniqueName == "Ereignisende" || column.UniqueName == "ColumnEreignisende")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:dd.MM.yy}";
                    }
                    //else if (column.UniqueName == "EreignisGeschlecht")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "EreignisOrt")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Paarung")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Team 1")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Team 2")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "S-Dauer" || column.UniqueName == "ColumnS-Dauer")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm:ss}";
                    }
                    else if (column.UniqueName == "W-Dauer" || column.UniqueName == "ColumnW-Dauer")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm:ss}";
                    }
                    //else if (column.UniqueName == "Beitragsart")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "Beitragsbeginn" || column.UniqueName == "ColumnBeitragsbeginn")
                    {
                      //  column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm}";
                    }
                    else if (column.UniqueName == "BeitragsEnde" || column.UniqueName == "ColumnBeitragsEnde")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm}";
                    }
                    //else if (column.UniqueName == "Beitragart")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Beitrag.Bemerkung")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Live")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "E-Index (SD)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Sponsor")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Werbebotschaft")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Werbemittel")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "UnterWerbemittel")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "Klar" || column.UniqueName == "ColumnKlar")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm:ss}";
                    }
                    //else if (column.UniqueName == "seq_klar")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    else if (column.UniqueName == "Assoz" || column.UniqueName == "ColumnAssoz")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm:ss}";
                    }
                    else if (column.UniqueName == "Werbedauer" || column.UniqueName == "ColumnWerbedauer")
                    {
                        //column.HeaderText = "";
                        column.DataFormatString = "{0:HH:mm:ss}";
                    }
                    //else if (column.UniqueName == "seq_assoz")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "seq")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Werbewert")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "Werbepreis")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "S-Index (SD)")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}
                    //else if (column.UniqueName == "TKP")
                    //{
                    //    column.HeaderText = "";
                    //    column.DataFormatString = "";
                    //}


                }


            }
        }

Please Help to get a working export

Kind Regards

[Daniel]

Hello Fabian,

Unfortunately I'm unable to reproduce the issue on my end. May I ask you to submit a runnable project that demonstrates the problem so I can debug it locally.
In the meantime you can try to apply the date format explicitly on ExcelExportCellCreated as explained in the following help topic:
Word/Excel export (HTML-based)

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.