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

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

3 Answers 78 Views
Editor
This is a migrated thread and some comments may be shown as answers.
Steve Holdorf
Top achievements
Rank 1
Steve Holdorf asked on 07 Nov 2012, 01:12 PM
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

3 Answers, 1 is accepted

Sort by
0
Steve Holdorf
Top achievements
Rank 1
answered on 07 Nov 2012, 02:59 PM
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
0
Accepted
Daniel
Telerik team
answered on 12 Nov 2012, 12:06 PM
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.
0
Steve Holdorf
Top achievements
Rank 1
answered on 12 Nov 2012, 07:35 PM
Thank you very much for your time and the correct answer. As always Telerik has the best products and services!

Thanks,


Steve Holdorf
Tags
Editor
Asked by
Steve Holdorf
Top achievements
Rank 1
Answers by
Steve Holdorf
Top achievements
Rank 1
Daniel
Telerik team
Share this question
or