Solved

extract the data from excel using ASP.net

Posted on 2003-11-27
4
149 Views
Last Modified: 2010-04-06
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
Comment
Question by:saloh
4 Comments
 
LVL 28

Accepted Solution

by:
mmarinov earned 175 total points
ID: 9839011
Here is the answer
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934
There are a lot of samples

B..G
0
 
LVL 35

Expert Comment

by:YZlat
ID: 9844549
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RSS feed not showing item time 3 19
Format results with PHP 3 68
xml attribute DTD attribute differences 3 65
jQuery Date picker not working 16 109
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now