This is a migrated thread and some comments may be shown as answers.

Exporting to Excel

2 Answers 73 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Prasad
Top achievements
Rank 1
Prasad asked on 09 Jul 2011, 01:15 PM
I'm using pagination for my gridview but when I export gridddata to excel, only grid first page records are being exported.

I'm using below code to export which was suggested by you.
 

 

gviewTracker.ExportSettings.ExportOnlyData = true;
gviewTracker.HeaderStyle.Wrap = false; 
gviewTracker.MasterTableView.Width = 1800;
  
gviewTracker.ExportSettings.IgnorePaging = true;
  
gviewTracker.ExportSettings.OpenInNewWindow = true;
 gviewTracker.MasterTableView.ExporttoExcel();

I'm using Q32009sp1 version for above functionality.

 


Could you please help me out for above.

Advance Thanks,
Prasad.

 

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 11 Jul 2011, 05:57 AM
Hello Prasad,

I tried the same scenario and its working fine in my end. Please make a double check with the following demo which implements the same functionality.
Grid / Export to ExcelML.

Thanks,
Princy
0
Daniel
Telerik team
answered on 15 Jul 2011, 10:35 AM
Hello Prasad,

Please make sure that you use advanced data-binding or datasource control when exporting to ExcelML format.
Advanced Data-binding (using NeedDataSource event)

Best regards,
Daniel
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Tags
Grid
Asked by
Prasad
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Daniel
Telerik team
Share this question
or