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

Error Export to ExcelML

1 Answer 174 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Faustino
Top achievements
Rank 1
Faustino asked on 19 Mar 2014, 06:05 PM
hope you can help me, I have the following problem:

I need to export a GRID but sends me the following error

Error de servidor en la aplicación '/SCNUARP'.
--------------------------------------------------------------------------------
 
 
 Referencia a objeto no establecida como instancia de un objeto.
Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.
 
Detalles de la excepción: System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.
 
Error de código fuente:
 
 
 
 
Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.
 
 
Seguimiento de la pila:
 
 
 
 
 
[NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.]
   Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderForm(HtmlTextWriter nullWriter, Control form) +2186
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +268
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +102
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +32
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +53
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +40
   Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderPage(HtmlTextWriter nullWriter, Control page) +179
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +268
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +8
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +57
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1386
  
 
 
--------------------------------------------------------------------------------
Información de versión: Versión de Microsoft .NET Framework:4.0.30319; Versión ASP.NET:4.0.30319.18055

when exporting ExcelML

this is the code I use:

Protected Sub BTExportar_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTExportar.Click
       If Hoja.Items.Count > 0 Then
           Hoja.ExportSettings.ExportOnlyData = True
           Hoja.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML
           Hoja.MasterTableView.ExportToExcel()
       End If
   End Sub

Dim Tabla As New DataTable
        Tabla.Columns.Add("CVE")
        Tabla.Columns.Add("seccion")
        Tabla.Columns.Add("indicador")
        Tabla.Columns.Add("criterio")
        Tabla.Columns.Add("si")
        Tabla.Columns.Add("no")
        Tabla.Columns.Add("na")
        Tabla.Columns.Add("avance")
        Tabla.Columns.Add("accion")
        Tabla.Columns.Add("responsable")
 
 Fila(0) = "Clave"
 Fila(1) = Seccion
 Fila(2) = ""
 Fila(3) = ""
 Fila(4) = ""
.
.etc.
 
 Tabla.Rows.Add(Fila)
  Hoja.DataSource = Tabla
  Hoja.DataBind()

this is how I link and exported

I can not export to ExcelML only excel

appreciate your help



1 Answer, 1 is accepted

Sort by
0
Faustino
Top achievements
Rank 1
answered on 19 Mar 2014, 09:42 PM
resolved!!

the problem was in the postback

thank you!!!
Tags
Grid
Asked by
Faustino
Top achievements
Rank 1
Answers by
Faustino
Top achievements
Rank 1
Share this question
or