Copying an Excel range of cells into a RadEditor and reading that range into an XDocument

4 posts, 1 answers
  1. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 07 Nov 2012 Link to this post

    I have a very tricky task that I must perform. What I need to be able to do is allow a user to Past a section of Excel cells into a radeditor then on the C# side read those cells into an XMLDocument. I see that the radeditor has a HTML content view and I was hoping that I could read the html, parse it after reading it into xml format. If this is possible could you give me some guidance as to the best way to do this. I know that this is non-standard but any help would be great!!!!

    Thanks,

    Steve Holdorf
  2. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 07 Nov 2012 Link to this post

    Going through the other Telerik controls it may be better to use an upload control for a spreadsheet, then load that spreadsheet into a radgrid. All I need to do is have the user upload a spreadsheet into a datatable that can be bound to a radgrid. Any better ideas?

    Thanks,


    Steve Holdorf
  3. Answer
    Daniel
    Admin
    Daniel avatar
    4949 posts

    Posted 12 Nov 2012 Link to this post

    Hello Steve,

    You could use OleDB provider to load the data into our RadGrid:
    Read Data From an Excel File (.xls) in ASP.NET

    I hope this helps.

    Regards,
    Daniel
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  4. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 12 Nov 2012 Link to this post

    Thank you very much for your time and the correct answer. As always Telerik has the best products and services!

    Thanks,


    Steve Holdorf
Back to Top