Telerik Forums / UI for Silverlight Forum / GridView /

Importing A RadDocument in a RadGridview

Telerik UI for Silverlight
Resources Buy Try

1 posts, 0 answers

fred

28 posts

Member since:
Jun 2010

Posted 15 Nov 2012 Link to this post

Hello Telerikians.

After an Excel Export using the Telerik Export Format tools, I want to import back the Exce(.xls) document in a Gridview.

To do this I use the RadDocument class and the HTMLFormatProvider, as the Exported .xls files are in fact html formatted.

But how can I import my RadDocument in a RadGridview ?

here is my code

using Telerik.Windows.Documents.FormatProviders;

using Telerik.Windows.Documents.FormatProviders.Txt;

using Telerik.Windows.Documents.FormatProviders.Xaml;

using Telerik.Windows.Documents;

using Telerik.Windows.Documents.Model;

using Telerik.Windows.Documents.FormatProviders.Html;





public RadDocument ImportExcelDataClick(object sender, RoutedEventArgs e)

        {

            RadDocument document = null;

            IDocumentFormatProvider provider = new HtmlFormatProvider();

            OpenFileDialog openDialog = new OpenFileDialog();

            openDialog.Filter = "Excel Files|*.xls";

            openDialog.Multiselect = false;

            bool? dialogResult = openDialog.ShowDialog();

            if (dialogResult == true)

            {

                using (Stream stream = openDialog.File.OpenRead())

                {

                    document = provider.Import(stream);

                }

            }

            return document;



        }

by advance Regards.
:)

Importing A RadDocument in a RadGridview

fred