Reading data from an Excel spreadsheet

  • Thread starter Thread starter S_K
  • Start date Start date
S

S_K

Hi,

I have a need to read data from an Excel spreadsheet using ASP.NET
(C# ). The data is then displayed in various locations on the web
site. This should be very simple and I have been following David
Hayden's excellent article on this (http://davidhayden.com/blog/dave/
archive/2006/05/26/2973.aspx) but I get type or namespace could not be
found errors when I build. I've tried to include a reference for the
following:

System.Data.Odbc.OdbcFactory
System.Data.OleDb.OleDbFactory
System.Data.SqlClient.SqlClientFactory

However I can't find any references for the above namespaces in the
"Add Reference" .Net or COM sections.

Is there anyway to easly read the cells from an Excel speadsheet?

Thanks in advance so much for your help!

Steve
 
David is using the Enterprise Library. You can download it from:
http://tinyurl.com/2blmwa

You can also use the standard OLEDB bits, but you will have to have the Jet
libraries installed. They are not part of the standard MDAC install as of
MDAC 2.8, so you have to install them separately.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
 
Don't automate Office from a web app, it isn't supported.

Beyond that you need to ensure Office is actually installed on your web
server and the machine you are compiling on.










- Show quoted text -
Click to expand...

So how do I collect data from Excel if I shouldn't automate Office
from a web application? Should I be creating an .exe app?
 
re:
!> So how do I collect data from Excel if I shouldn't automate
!> Office from a web application? Should I be creating an .exe app?

No. Don't create an .exe app.

Use a component like GemBox.Spreadsheet Free :

http://www.gemboxsoftware.com/GBSpreadsheetFree.htm

It's free, although it has some limitations:

1. Maximum number of rows per sheet is 150.
2. Maximum number of sheets per workbook is 5.

If you can live with the limitations, use the free version.
Otherwise, purchase the Professional version.





Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
Don't automate Office from a web app, it isn't supported.

Beyond that you need to ensure Office is actually installed on your web
server and the machine you are compiling on.










- Show quoted text -
Click to expand...

So how do I collect data from Excel if I shouldn't automate Office
from a web application? Should I be creating an .exe app?
 
Back
Top