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

Silverlight GridView Export to Excel

19 Answers 665 Views

GridView

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

19 Answers, 1 is accepted

answered on 28 May 2010, 03:48 PM

Hi Shankar,

What is the source of the datapager?
Usually, you need to set the PageSize property of the data pager to 0 before calling the Export method.
After the export is done you need to set the PageSize back to its original value.

Note that if the pager is bound to DomainDataSource then you need to set the PageSize to 0 of the domain data source itself.

Hope this helps.

All the best,
Veskoni
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

answered on 26 Jul 2012, 11:35 AM

Hello Jose,

I used the following code, now i can able to export all records in my RadGridView to Excel sheet with no change in RadDataPager
lets try this........ch@ndu

RadDataPagerRadGrdWorkOrders.PageSize = 0;
using (Stream stream = dialog.OpenFile())
{
GridViewExportOptions exportOptions = new GridViewExportOptions();
exportOptions.Format = format;
exportOptions.ShowColumnFooters = true;
exportOptions.ShowColumnHeaders = true;
exportOptions.ShowGroupFooters = true;
RadGrdWorkOrders.Export(stream, exportOptions);
}
RadDataPagerRadGrdWorkOrders.PageSize = 20;

answered on 13 Nov 2012, 01:29 PM

Hello Telerik Staff - Hello Forum Reader,

i got the same problem, that if i got multiple pages on my Grid, not all of the Data is Exportet - just the Data on the first Page
is getting exported.

So here's my Export Function which i call:

public static void ExportData(GridView grid)
        {
            string extension = "xls";
            grid.PageSize = 0;
            ExportFormat format = ExportFormat.Html;
 
            SaveFileDialog dialog = new SaveFileDialog();
            dialog.DefaultExt = extension;
            dialog.Filter = String.Format("Excel Files (*.{0})|*.{0}|Alle Files (*.*)|*.*", extension);
            dialog.FilterIndex = 1;
 
            if (dialog.ShowDialog() == true)
            {
                using (Stream stream = dialog.OpenFile())
                {
                    GridViewExportOptions exportOptions = new GridViewExportOptions();
                    exportOptions.Format = format;
                    exportOptions.ShowColumnFooters = false;
                    exportOptions.ShowColumnHeaders = true;
                    exportOptions.ShowGroupFooters = false;
 
                    grid.Export(stream, exportOptions);
                }
            }
        }

So is set the PageSize for every time any Grid Export something.
But i still just get the first Page's Data.

What's to do to get all the Data in the Grid?

Thanks for any advice

regards
Mike

answered on 14 Nov 2012, 02:42 PM

Hello Didie,

thanks for your advice.
I setted the PageSitze Property of the Pager to 0 and ath the end of the Exporting i set it back to my original PageSize.
That works - so all Items getting Exported.

But i got a GridViewComboBoxColumn in my Grid. Which value is selected and i dont get the Value in my Export Excel Sheet.
Here is what it looks like:

                    <telerik:GridViewComboBoxColumn Width="Auto" Header="Mapping Organisation" Background="LightYellow"
                                                    ItemsSource="{Binding Organisations}" 
                                                    DataMemberBinding="{Binding OrganisationItem, Mode=TwoWay}"
                                                    DisplayMemberPath="OrganisationRegisterNoAndName"
                                                    SelectedValueMemberPath="OrganisationRegisterNoAndName">
                       <telerik:GridViewComboBoxColumn.CellTemplate>
                            <DataTemplate>
                                <TextBlock Text="{Binding OrganisationItem.OrganisationRegisterNoAndName}"/>
                            </DataTemplate>
                        </telerik:GridViewComboBoxColumn.CellTemplate>
                    </telerik:GridViewComboBoxColumn>

Which property must be filled that the export is working also for the DropDownColumn?
If already tried it with this example in this post: http://www.telerik.com/community/forums/silverlight/gridview/export-doesn-t-capture-dropdown-column-values.aspx
but it didnt work for me - the value isnt exported.

thanks and regards

Mike

answered on 25 Jun 2014, 09:09 AM

Hi,

RadGridView can export with ExportFormat.HTML and ExportFormat.ExcelML - in both cases not native for Excel 2010. In case of HTML export you will get such warning and this cannot be avoided, however if you export to ExcelML with XML extension you will not get it.

Please check this help article for a further information:
Warning message when opening the excel file.

You can also export data with RadSpreadProcessing. The model is completely independent from UI. You can check Export with RadSpreadProcessing as an example on how to do so.

Regards,
Didie
Telerik

Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Silverlight GridView Export to Excel

19 Answers, 1 is accepted