extract the data from excel using ASP.net

My excel file in Sheet 1 has two columns, B1 (Name) & C1 (Description).
And it will consists of many records under B1 & C1.

eg
Name     Description
John       - good
Amy       - excellent
tom        - bad

How do i retrieve data from xls file and I want the data to be displayed in the .aspx file format.

I would be grateful if you could show me how to code as i have just started using .Net.

Thanks in advance
salohAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mmarinovCommented:
Here is the answer
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934
There are a lot of samples

B..G
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
YZlatCommented:
you can display your data using datagrid. first place a datagrid control on your page:

<asp:datagrid id="grid1" runat="server" />


then in Page_Load procedure declare data set and read xml file data into a data set :

Dim ds as New DataSet()
ds.ReadXml(Server.MapPath("myfile.xml"))

then display your code in your datagrid:

grid1.DataSource = myDataSet
grid1.DataBind()
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.