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

Excel to GridView

6 Answers 65 Views
GridView
This is a migrated thread and some comments may be shown as answers.
bob
Top achievements
Rank 1
bob asked on 20 Jul 2010, 12:44 PM
Hi,

How can i transform an excel table or spreadsheet into a RadGridView, easily and without headaches ?

Thanks for any direction

6 Answers, 1 is accepted

Sort by
0
Yavor Georgiev
Telerik team
answered on 20 Jul 2010, 12:51 PM
Hello bob,

 Please follow the steps outlined in this article to create a DataSet from an Excel Workbook. When you have the DataSet, you need just assign one of the contained DataTables to the ItemsSource property of RadGridView.

Sincerely yours,
Yavor Georgiev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
bob
Top achievements
Rank 1
answered on 20 Jul 2010, 01:54 PM
I don't quite follow all this. I have an excel spreadsheet, Telerik controls and Expression Blend.
0
bob
Top achievements
Rank 1
answered on 20 Jul 2010, 02:06 PM
Sir, i'm no developper, i'm designer
0
bob
Top achievements
Rank 1
answered on 20 Jul 2010, 03:52 PM
ok, i'm done for XML mapping

great team support by the way ! (nothing personal)
0
Accepted
Yavor Georgiev
Telerik team
answered on 21 Jul 2010, 10:02 AM
Hello bob,

 I'm attaching a sample solution that opens an Excel file an loads it into a RadGridView. Be sure to change the Platform Target of the project to x86 or x64 depending on if you have 32bit or 64bit MS Office installed. Also, you will most probably need to download this.

All the best,
Yavor Georgiev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
bob
Top achievements
Rank 1
answered on 21 Jul 2010, 12:49 PM
I'm speechless
Tags
GridView
Asked by
bob
Top achievements
Rank 1
Answers by
Yavor Georgiev
Telerik team
bob
Top achievements
Rank 1
Share this question
or