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

[Steve Holdorf]

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

[Steve Holdorf]

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

[Daniel]

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

[Steve Holdorf]

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

Thanks,


Steve Holdorf