• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

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
0
saloh
Asked:
saloh
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now