郎朗坤
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace ExcelReader
{
public class ExcelHelper
{
private OleDbConnection conn = new OleDbConnection();
public ExcelHelper(string excelPath)
{
string connectionStr = string.Format(ConfigurationManager.AppSettings["ConnectionString"], excelPath);
conn.ConnectionString = connectionStr;
}
public DataTable GetExcelTable()
{
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from [Sheet1$]";
DataTable table = new DataTable();
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
oda.Fill(table);
foreach (DataRow row in table.Rows)
{
if (!(row[0].ToString()).Equals("交易日期"))
{
row.Delete();
}
else
{
break;
}
}
for (int i = 0; i < table.Columns.Count; i++)
{
table.Columns[i].ColumnName = table.Rows[0][i].ToString();
}
table.Rows[0].Delete();
table = table.GetChanges(DataRowState.Unchanged);
return table;
}
}
}
经过实验，可以获取数据表~
下面是连接字符串：