RadGridView import from excel

[erhan]

Hello,

I am looking a generic solution to import excel to radgridview.

I want to do this at my control(not viewmodel or codebehind,I custimized radgridview)

Is there a way to do that

[Lance | Senior Manager Technical Support]

Hello Erhan,

There is no single "Import Excel" functionality of the GridView. However, you can use the Telerik Document Processing libraries' RadSpreadProcessing for this.

You can load an xslx file and get the values of each cell and use that data to populate your RadGridView accordingly.

If you have any trouble implementing this, you can open a support ticket for direct guidance from the GridView team. I see that you do not have a license for UI for WPF, are you a developer and your employer purchased the product? Telerik licensing is per-developer. So if you're the developer, you need to be assigned the license.

Have them add you as the Licensed User. It only takes a few seconds and it's free (see steps below). The purchaser will retain ownership and can change the user at any time. This will let you submit support tickets instead of forum posts.

Here are the steps to make you the Licensed User:

1-  Go to the Manage Licensed Users portal (see attached screenshot)
2 - Add you as a user
3-  Assign you to the license using your email address

That's it! You'll get an email stating that you've been assigned the license and will then be able to download and install the products and submit support tickets. If the license is a DevCraft Ultimate, you'll also get access to Phone Assistance.

Regards,
Lance | Tech Support Engineer, Sr.
Telerik by Progress