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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Exporting from Grid

Thread ID:

Created:

Updated:

Platform:

Replies:

145267 Jun 14,2019 09:20 AM UTC Jun 20,2019 10:31 AM UTC ASP.NET Web Forms 3
loading
Tags: Grid
Alex Jermy
Asked On June 14, 2019 09:20 AM UTC

Hi,

I have a grid and have populated it with the correct data, but I am also trying to add a button for exporting to an excel file.

The exporting is currently not working and I would like to know why. I have tried the methods below (See attachment for details).

ExcelExport exp = new ExcelExport();

exp.Export(PlanningUnitsGrid.Model, (IEnumerable)PlanningUnitsGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime");


BindGrid();

new ExcelExport().Export(PlanningUnitsGrid.Model, PlanningUnitsGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, false, false, ExportTheme.BootstrapTheme);



Attachment: Bands_f6989229.zip

Farveen Sulthana Thameeztheen Basha [Syncfusion]
Replied On June 18, 2019 03:18 AM UTC

Hi Alex, 

Thanks for contacting Syncfusion Support. 

Query#:- The exporting is currently not working and I would like to know why. I have tried the methods below. 
 
We have prepared sample as per your code example but we are unable to reproduce your reported problem at our end. Refer to the sample Link:- 
http://www.syncfusion.com/downloads/support/forum/145267/ze/Sample-1864053561 

We need some more additional information to find the cause of the issue. Share us the following details. 

  1. StackTrace of the issue or Exception.
  2.  Stringified model of the Grid on server side while on Exporting as like below screenshot and copy it into clipboard.
  3. If possible replicate the issue in the above sample and revert us back.
  4. Exact scenario you have faced the issue(while using Template column or else using without Template column).

Regards, 
Farveen sulthana T 
 


Alex Jermy
Replied On June 19, 2019 09:28 AM UTC

Hi,

1. Unfortunately there is no stack trace, because no error is thrown, and also no stack-trace. The button is just unresponsive. Nothing happens when it is clicked. (Although it is highlighted on mouse-over).
2. I don't understand how to do what you describe here:
 'Stringified model of the Grid on server side while on Exporting as like below screenshot and copy it into clipboard.'
3. Could you explain how to do this?
4. The sample you have provided works absolutely fine on my machine, and the grid is exported.
5. I am currently using a template in the first column and experiencing this problem. But when I comment out the 'template' column, I still cannot export the grid.

Thanks very much!

Alex

Manivannan Padmanaban [Syncfusion]
Replied On June 20, 2019 10:31 AM UTC

Hi Alex, 

Thanks for the update. 

Refer the below steps to share the exporting grid model. 

Step 1: 

Open the Grid Model in Text Visualizer. 

 



Step 2:  

Copy the Grid model, paste it in text file and share to us. 

 



Also, kindly get back to us with below details. 
  1. Share the Video demonstration of the issue.
  2. If possible, reproduce the reported issue in the previously provided sample and revert back to us.
 
Regards, 
Manivannan Padmanaban. 
 


CONFIRMATION

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

Live Chat Icon For mobile
Live Chat Icon