[Solved] Problem with ExcelML

[Fabian Raul Jofre]

I have a problem with. Excel.format="ExcleML"

 

 

 

I don´t know why.
I was looking in the forum to find a solution, but nothing.

Do you have any ideas?

My escenerio:
.aspx

<

 

asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Export" />

 

<

 

telerik:RadGrid AutoGenerateColumns="false" ID="RadGrid1" FooterStyle-HorizontalAlign="Right" AllowFilteringByColumn="False" AllowSorting="true" ShowFooter="True" runat="server" Skin="MyCustomSkin" EnableEmbeddedSkins="false" OnSortCommand="RadGrid1_SortCommand" OnItemDataBound="RadGrid1_ItemDataBound" OnCustomAggregate="RadGrid1_CustomAggregate">

 

 

<ClientSettings>

 

 

<Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true">

 

 

</Scrolling>

 

 

<Resizing EnableRealTimeResize="True" AllowColumnResize="True"></Resizing>

 

 

<ClientEvents OnGridCreated="GridCreated" />

 

 

</ClientSettings>

 

 

<MasterTableView Width="100%" CommandItemDisplay="Top" ShowGroupFooter="true" DataKeyNames="Estado">

 

 

<CommandItemSettings AddNewRecordText="" ShowExportToExcelButton="true" ShowExportToCsvButton="true" ShowExportToWordButton="true" />

 

 

<SortExpressions>

 

 

<telerik:GridSortExpression FieldName="Descripcion" SortOrder="Ascending" />

 

 

</SortExpressions>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="Descripcion" SortExpression="Descripcion" HeaderText="Descripcin" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left" ItemStyle-Wrap="false"></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="FechaHora" SortExpression="FechaHora" HeaderText="FechaHora" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" ItemStyle-Wrap="false" DataFormatString="{0:dd/MM/yyyy hh:mm:ss}"></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="IdOrdenador" SortExpression="IdOrdenador" HeaderText="NCaja" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-Wrap="false" ></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Nombre" SortExpression="Nombre" HeaderText="Cajero" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-Wrap="false" ></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="PrecioUnitario" SortExpression="PrecioUnitario" HeaderText="Precio U." HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-Wrap="false" DataFormatString="{0:###,###,##0.00}" UniqueName="PrecioUnitario" Aggregate="Custom"></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Cantidad" SortExpression="Cantidad" HeaderText="Cantidad" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-Wrap="false" DataFormatString="{0:####0}" UniqueName="Cantidad" Aggregate="Custom"></telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Total" SortExpression="Total" HeaderText="Total" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-Wrap="false" DataFormatString="{0:###,###,##0.00}" UniqueName="Total" Aggregate="Custom"></telerik:GridBoundColumn>

 

 

</Columns>

 

 

<GroupByExpressions>

 

 

<telerik:GridGroupByExpression>

 

 

<GroupByFields>

 

 

<telerik:GridGroupByField FieldAlias="Descripcin" FieldName="Descripcion" />

 

 

</GroupByFields>

 

 

<SelectFields>

 

 

<telerik:GridGroupByField FieldName="Descripcion"/>

 

 

</SelectFields>

 

 

</telerik:GridGroupByExpression>

 

 

</GroupByExpressions>

 

 

</MasterTableView>

 

 

</telerik:RadGrid>

 

.cs

protected void Button1_Click(object sender, EventArgs e)

 

{

RadGrid1.ExportSettings.ExportOnlyData =

true;

 

RadGrid1.ExportSettings.OpenInNewWindow =

false;

 

RadGrid1.ExportSettings.Excel.Format = Telerik.Web.UI.

GridExcelExportFormat.ExcelML;

 

RadGrid1.MasterTableView.ExportToExcel();

 

}

My result is this error:

Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderForm(HtmlTextWriter nullWriter, Control form) +864
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +8673113
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +32
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +51
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +40
   Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderPage(HtmlTextWriter nullWriter, Control page) +93
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   Telerik.Web.UI.RadAjaxControl.RenderPageInAjaxMode(HtmlTextWriter writer, Control page) +594
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   Telerik.Web.UI.RadAjaxControl.RenderPageInAjaxMode(HtmlTextWriter writer, Control page) +594
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266

[Daniel]

Hello Fabian,

Judging by the posted stack trace, RadGrid's ExcelML data engine can't fetch the necessary data from your data source. Usually this happens when using simple data binding. I recommend you move your databinding logic to the NeedDataSource event or try using a datasource control.

Simple Data-binding
Advanced Data-binding

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.