Solved

extract the data from excel using ASP.net

Posted on 2003-11-27
4
148 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Article by: Matthew
I am a very big proponent of technology compliance standards and strive to meet such criteria in all of my work. That includes my site, which is 100% XHTML 1.0 compliant as determined by the World Wide Web Consortium. https://www.matthewstevenkel…
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
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…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

759 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

17 Experts available now in Live!

Get 1:1 Help Now