How to read Excel in C#?

[davidw]

Hi,

I read some articles about handle Excel in C#, they all need import Excel
library. That means you need install Excel on that machine. I am wonderring
SQL 2000 handle Excel, you can import Excel file in SQL 2000 which doesn't
require you install Excel. How could I do the same thing with C#?

thanks!

[shiv_koirala]

First thing you will always need reference of "Excel 10 Object Library
" to do excel manipulation ( until you want to write your own excel
parser ). If you are not sure that your clients will have excel on
there machine send it to server ( if you are using aspx you always do
that) and parse it on the server. Now you will only need to install
excel in one place thats on the server.

-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

[Mehdi]

On 9 Oct 2005 01:05:20 -0700, sh**********@yahoo.com wrote:

First thing you will always need reference of "Excel 10 Object Library
" to do excel manipulation ( until you want to write your own excel
parser ). If you are not sure that your clients will have excel on
there machine send it to server ( if you are using aspx you always do
that) and parse it on the server. Now you will only need to install
excel in one place thats on the server.

Not a really good idea apparently:
http://support.microsoft.com/default...b;en-us;257757

If you need to parse Excel files (and any MS Office files) without having
Office installed, you can use a third party component such as the Aspose
ones http://www.aspose.com/default.aspx

[Paul Clement]

On Sat, 8 Oct 2005 21:43:25 -0700, "davidw" <da****@affinisys.com> wrote:

¤ Hi,
¤
¤ I read some articles about handle Excel in C#, they all need import Excel
¤ library. That means you need install Excel on that machine. I am wonderring
¤ SQL 2000 handle Excel, you can import Excel file in SQL 2000 which doesn't
¤ require you install Excel. How could I do the same thing with C#?

You don't need the Excel object library, you can use ADO.NET and SQL:

Function ExportExcelToSQLServer() As Boolean

Dim ExcelConnection As New
System.Data.OleDb.OleDbConnection("Provider=Micros oft.Jet.OLEDB.4.0;" & _
"Data Source=" & "E:\My
Documents\Book5.xls" & ";" & _
"Extended Properties=""Excel
8.0;HDR=No""")

ExcelConnection.Open()

'Existing table
Dim ExcelCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO [ODBC;Driver={SQL
Server};Server=(local);Database=Northwind;Trusted_ Connection=yes].[Orders2] SELECT * FROM
[Orders$];", ExcelConnection)
'New table
'Dim ExcelCommand As New System.Data.OleDb.OleDbCommand("SELECT INTO [ODBC;Driver={SQL
Server};Server=(local);Database=Northwind;Trusted_ Connection=yes].[Orders2] FROM [Orders$];",
ExcelConnection)

ExcelCommand.ExecuteNonQuery()
ExcelConnection.Close()

End Function
Paul
~~~~
Microsoft MVP (Visual Basic)