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

export to Excel - including IValueConverter and all the pages of GridView

17 Answers 166 Views

GridView

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

This question is locked. New answers and comments are not allowed.

lina fetisova asked on 02 Aug 2010, 07:32 AM

Good day!
We make export to Exxel from our GridViews using ExportExtensions.ToCsv(grid, true);

we use it in our function:

public static void ExportToXls(RadGridView grid)
        {
            SaveFileDialog textDialog = new SaveFileDialog();
            textDialog.Filter = "XLS Files | *.csv";
            textDialog.DefaultExt = "csv";
            bool? result = textDialog.ShowDialog();
            if (result == true)
            {
                  System.Text.Encoding ascii = System.Text.Encoding.UTF8;
                  Encoding enc=Encoding.GetEncoding("cp1251");
                  string data = ExportExtensions.ToCsv(grid, true);
                  data = data.Replace(",", ";");
                  System.IO.Stream fileStream = textDialog.OpenFile();
                  byte[] contents = enc.GetBytes(data);
                  fileStream.Write(contents, 0, contents.Length);
                  fileStream.Flush();
                  fileStream.Close();
            }
        }

But when we use different IValueConverters in our grid to convert the data in cells to user friendly data, in csv we see not user friendy data, without impact of IValueConverters.
That's the first problem.
Enother problem is when we use paging in our grid, there is only the current page in our csv file - but there are no other pages!
=(
how can I solve this problems?

17 Answers, 1 is accepted

answered on 02 Aug 2010, 10:08 AM

oh, that's great if it really works, Vlad, but I have a strange bug:
I try to export like in the example - http://demos.telerik.com/silverlight/#GridView/ExportingPagedData

i write such usings:

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Windows.Navigation;
using System.Text;
using System.IO;
using System.IO.IsolatedStorage;
using System.Globalization;
using System.Windows.Controls.Primitives;
using System.Windows.Data;
using Telerik.Windows.Controls.GridView;
using Telerik.Windows.Data;
using Telerik.Windows.Controls;
using System.ServiceModel;

it includes all the includes from the example.
but I have a bug:
on line
GridViewExportOptions exportOptions = new GridViewExportOptions();
such a bug:
The type or namespace name 'GridViewExportOptions' could not be found (are you missing a using directive or an assembly reference?)
and on line:
grStatistics.Export(stream, exportOptions); (grStatistics is a RadGridView)
suuch a bug:
'Telerik.Windows.Controls.RadGridView' does not contain a definition for 'Export' and no extension method 'Export' accepting a first argument of type 'Telerik.Windows.Controls.RadGridView' could be found (are you missing a using directive or an assembly reference?)

what I do wrong?