[Solved] Export Hierarchical Grid

[Saurabh Srivastava]

Hi,

I have a 2 level hierarchical grid which I am trying to export to excel. I have used the following code:

 protected void btnExport_Click(object sender, EventArgs e)
    {
        try
        {
            rgScenario.ExportSettings.ExportOnlyData = true;
            rgScenario.ExportSettings.IgnorePaging = true;
            rgScenario.ExportSettings.OpenInNewWindow = true;

            rgScenario.MasterTableView.HierarchyDefaultExpanded = true;
            rgScenario.MasterTableView.Rebind();

            rgScenario.MasterTableView.ExportToExcel();
        }
        catch(Exception ex)
        {

        }

 

But I recieve the following runtime exception:

[NullReferenceException: Object reference not set to an instance of an object.]
   Telerik.Web.UI.GridTableView.PrepareExport() +47
   Telerik.Web.UI.Grid.Export.TableViewExporter.PrepareForExport() +340
   Telerik.Web.UI.Grid.Export.TableViewExporter.page_PreRender(Object sender, EventArgs e) +34
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnPreRender(EventArgs e) +8679510
   System.Web.UI.Control.PreRenderRecursiveInternal() +80
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

Is there anything I have missed?

Regards,
Saurabh

[Mira]

Hi Saurabh,

Have you seen this forum topic and the attached project there?

Please tell me whether it helps.

Kind regards,
Mira
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Saurabh Srivastava]

Hi Mira,

I was able to resolve the issue. I did however already went through the sample of exporting. My issue was that I was not persisting my dataset/datatable in the viewstate.

Thanks,
Saurabh