Export

[Hrvoje Voda]

IS there a way to use custom button to export data to excel?

I'm using this code but it doesn't work.

 Dim exp As New ExcelExport()

 exp.Export(grd.Model, grd.DataSource, "Materijali.xls", ExcelVersion.Excel2013)

When I decode grd.DataSource it's empty.

The same thing is for PDF export.

[Jayaprakash Kamaraj]

Hi Hrvoje, 

Thank you for contacting Syncfusion support. 

We have already discussed the same in following knowledge base document. 

https://www.syncfusion.com/kb/4335/how-to-export-grid-data-to-excel-word-and-pdf-formats-on-external-action 

Regards, 

Jayaprakash K. 

[Hrvoje Voda]

I tried that code, but I'm getting an error:

Object cannot be cast from DBNull to other types

[Jayaprakash Kamaraj]

Hi Hrvoje, 

We have created a sample with custom button to export grid data. Please refer to the below link.    

Sample: http://www.syncfusion.com/downloads/support/forum/124887/ze/SyncfusionASPNETApplication24-916142599 

The Null exception issue may occur in any of the below scenarios.   

  

1.       If the DataSource of the Grid is DataTable   

2.       If the columns defined in grid is not present in the DataSource.   

 

Please refer to the following knowledge base document.

https://www.syncfusion.com/kb/3018/Null-Exception-while-exporting  

Also, we have provided “DataTable Support for exporting” from v14.1.0.41. So if you are using older version, please upgrade to the new version.   

  

If the issue has still not resolved, please provide the following details,  

 

1.       Is there any script error or exception thrown in your project? If so, attach a screenshot of your stack trace.      

2.       Share the video to show the issue. 

3.       Essential studio version details.  

4.       Browser details.   

5.       Issue replication procedure. 

6.       Did you export DataTable?   

Regards, 

Jayaprakash K.