using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.OleDb;
using?System.Data;
using?System.IO;

namespace?TestExcel
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????string?mExcelName?=?“D:\\hehehe.xlsx“;
????????????string?mExcelSheet?=?““;
????????????DataTable?mDataTable?=?ExcelToDataTable（mExcelName?mExcelSheet）;
????????????for?（int?i?=?0;?i?????????????{
????????????????for?（int?j?=?0;?j?????????????????{
????????????????????Console.Write（mDataTable.Rows[i][j].ToString（）?+?“?“）;
????????????????}
????????????????Console.WriteLine（““）;
????????????}
????????????Console.ReadLine（）;
????????}
????????//用OLEDB通過設置連接字符串可以像讀取sqlserver一樣將excel中的數據讀取出來，但是excel2003和excel2007/2010的連接字符串是不同的
????????///?

????????///?把數據從Excel裝載到DataTable
????????///?

????????///?帶路徑的Excel文件名
????????///?工作表名
????????///?將數據存入的DataTable
????????///?
????????public?static?DataTable?ExcelToDataTable（string?pathName?string?sheetName）
?????????{
?????????????DataTable?tbContainer?=?new?DataTable（）;
?????????????string?strConn?=?string.Empty;
?????????????if?（string.IsNullOrEmpty（sheetName））?{?sheetName?=?“Sheet1“;?}
?????????????FileInfo?file?=?new?FileInfo（pathName）;
?????????????if?（!file.Exists）?{?throw?new?Exception（“文件不存在“）;?}
?????????????string?extension?=?file.Extension;
?????????????switch?（extension）
?????????????{
?????????????case?“.xls“:
?????????????strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?pathName?+?“;Extended?Properties=‘Excel?8.0;HDR=Yes;IMEX=1;‘“;
?????????????break;
?????????????case?“.xlsx“:
?????????????strConn?=?“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=“?+?pathName?+?“;Extended?Properties=‘Excel?12.0;HDR=Yes;IMEX=1;‘“;
?????????????break;
?????????????default:
?????????????strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?pathName?+?“;Extended?Properties=‘Excel?8.0;HDR=Yes;IMEX=1;‘“;
?????????????break;
?????????????}
?????????????//鏈接Excel
?????????????OleDbConnection?cnnxls?=?new?OleDbConnection（strConn）;
?????????????//讀取Excel里面有?表Sheet1
?????????????OleDbDataAdapter?oda?=?new?OleDbDataAdapter（string.Format（“select?*?from?[{0}$]“?sheetName）?cnnxls）;
?????????????DataSet?ds?=?new?DataSet（）;
?????????????//將Excel里面有表內容裝載到內存表中！
?????????????oda.Fill（tbContainer）;
?????????????return?tbContainer;
?????????????}
????????????//這里需要注意的地方是，當文件的后綴名為.xlsx（excel2007/2010）時的連接字符串是“Provider=Microsoft.ACE.OLEDB.12.0;....“，注意中間紅色部分不是“Jet“。
????????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????6144??2014-10-09?16:56??TestExcel\TestExcel\bin\Debug\TestExcel.exe

?????文件??????13824??2014-10-09?16:56??TestExcel\TestExcel\bin\Debug\TestExcel.pdb

?????文件??????11608??2014-10-10?11:28??TestExcel\TestExcel\bin\Debug\TestExcel.vshost.exe

?????文件????????490??2010-03-17?22:39??TestExcel\TestExcel\bin\Debug\TestExcel.vshost.exe.manifest

?????文件???????5798??2014-10-09?16:56??TestExcel\TestExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????374??2014-10-10?11:28??TestExcel\TestExcel\obj\x86\Debug\TestExcel.csproj.FileListAbsolute.txt

?????文件???????6144??2014-10-09?16:56??TestExcel\TestExcel\obj\x86\Debug\TestExcel.exe

?????文件??????13824??2014-10-09?16:56??TestExcel\TestExcel\obj\x86\Debug\TestExcel.pdb

?????文件???????3007??2014-10-09?16:56??TestExcel\TestExcel\Program.cs

?????文件???????1350??2014-10-09?16:18??TestExcel\TestExcel\Properties\AssemblyInfo.cs

?????文件???????2332??2014-10-09?16:18??TestExcel\TestExcel\TestExcel.csproj

?????文件????????869??2014-10-09?16:18??TestExcel\TestExcel.sln

????..A..H.?????58880??2014-10-10?11:41??TestExcel\TestExcel.suo

?????目錄??????????0??2014-10-09?16:18??TestExcel\TestExcel\obj\x86\Debug\TempPE

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\obj\x86\Debug

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\bin\Debug

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\obj\x86

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\bin

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\obj

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel\Properties

?????目錄??????????0??2015-01-27?12:32??TestExcel\TestExcel

?????目錄??????????0??2015-01-27?12:32??TestExcel

-----------?---------??----------?-----??----

???????????????124644????????????????????22