GridControl.ActiveGridView is null

I encounter the next error: Object reference not set to an instance of an object. 

The stack trace: 

...    

   at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridCellToExcel(GridModel grid, Int32 iRow, Int32 iColumn, IRange range)

   at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridToExcel(GridModel grid, IWorksheet sheet, ConverterOptions options)

After investigations, I've saw that ActiveGridView property is null.

We construct the model for exporting in the next way:

... 

            GridControl gridValues;

            var s = new MemoryStream();      

... => some transformations/aggregations and return gridTemp 

As a mention, the ActiveGridView have the next attribute: [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)] .

I have changed the version of libraries some time ago, and right now i have all syncfusion dll's at version 16.2451.0.41 .

Can you please tell me how to proceed and set properly this property ?

Have a good day,

Mihai

Hi Mihaivladut, 

Thanks for using Syncfusion product. 

We can reproduce your reported scenario. By default, GridControl.ActiveGridView initialized when you add the GridControl inside any control to display. So, If you want to export the custom grid without displaying, you could add that control inside of any control to initialize the ActiveGridView. Please refer the following code example, 

C# 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/cs-998303070  

Let us know whether this helps also if you need any further assistance on this. 

Regards, 

Arulraj A 

Thank you for your promptitude.

Your indication and sample are very helpful, however i need to add headers to the excel export.

My application has a syncfusion grid with nested headers. I would like to know how to export the headers to excel. Please  see the attachment.

In the first sheet, is how i would like to be my export. With your code is almost good(without headers).

In the second sheet, i adapted your sample with desired headers.

Have a good day,

Mihai

Hi Mihai, 

Thanks for your update. 

To export the grid with headers, you could use the ConverterOptions.ColumnHeaders option. Please refer the below code example and the UG link, 

C# 

UG link: https://help.syncfusion.com/windowsforms/grid/exporting#exporting-with-row-and-column-headers 

Let us know whether this helps also if you need any further assistance on this. 

Regards, 

Arulraj A 

Thank you for your help.

I wish you all the best,

Mihai