We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Datagrid Export to Excel Issue

Thread ID:





97589 Dec 14,2010 09:56 PM UTC Dec 21,2010 03:00 PM UTC Silverlight 1
Tags: GridControl
Hema Gunda
Asked On December 14, 2010 09:56 PM UTC

Hi Syncfusion Team,

I have a GridDataControl to display netsted rows of Data.
I want to export the grid data to Excel. I am using the function,
DataGrid.ExportToExcel( ExcelVersion.Excel97to2003)

When clicking the export button, i am getting the following exception "Dialogs must be user-initiated".

If I drag some columns to the Grouping area, and then tried to export, "In this case it is exporting alternate main rows ( not nested rows) not all the rows".

In some cases, when I click export button, the scree freezes.

In some cases, I am getting the exception "Specified argument was out of the range of valid values".

Any setting needs to be changed. Please advice.
Appreciate your support.


Mohamed Suhaib Fahad A. [Syncfusion]
Replied On December 21, 2010 03:00 PM UTC

Hi Hema,

Thanks for the details.

1) The exception window shows up when you have the Silverlight project in "Debug" mode, this is because of security the Silverlight FW itself throws an exception. Can you try that in "Release" mode and see if that works?

2) Export issues with grouping - Can you please create a DirectTrac incident with the forum post details? We will be filing a bug report and follow-up with you on the details.

Please let me know if you need any more assistance.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon