private DataTable LoadExcel(string fileName)
{
FileInfo file = new FileInfo(fileName);
string dataSource, tableName, connectionString, strCmd = String.Empty;
dataSource = file.Name;
tableName = GetExcelTableName(dataSource);
connectionString = string.Format("Provider=Microsoft.Jet.OleDb.4.0;data source={0};Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'", dataSource);
string[] tabs=tableName.Split(';');
for (int i = 0; i < tabs.Length; i++)
{
strCmd = string.Format("SELECT * FROM [{0}] ", tabs[0] + "A1:J10");//选取指定的行和列 取第一个表
// strCmd = string.Format("SELECT * FROM [{0}] ", tabs[0]);//取数组中的第一个表名
}
OleDbDataAdapter da = new OleDbDataAdapter(strCmd, connectionString);
dte = new DataTable();
try
{
da.Fill(dte);
}
catch (Exception err)
{
throw new ApplicationException( "加载数据失败: " + err.Message, err);
}
da.Dispose();
return dte;
}
把得到的datatable加入数据库中就可以了