- using System;
- using System.Data.OleDb;
- namespace ConsoleApplication1
- {
- class Program
- {
- static void Main()
- {
- string connString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c:\\\\sample.xls; Extended Properties=Excel 8.0;";
- // Select using a Worksheet name
- string selectqry = "SELECT * FROM [Sheet1$]";
- OleDbConnection conn = new OleDbConnection(connString);
- OleDbCommand cmd = new OleDbCommand(selectqry,con);
- try
- {
- con.Open();
- OleDbDataReader theDatardr = cmd.ExecuteReader();
- while (theDatardr.Read())
- {
- Console.WriteLine("{0}: {1} ({2})
- //该片段来自于http://www.codesnippet.cn/detail/210820135265.html
来源: http://www.codesnippet.cn/detail/210820135265.html