用数据库连接，读取excel 12.0

#region set connection

string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + filePath + ";Extended Properties='Excel 12.0;hdr=yes;Imex=1'";

if (!this.Opened)

myOleDbConnection = new OleDbConnection(strConn);

#endregion

 try {

myOleDbConnection.Open();

//DataTable dataTable= myOleDbConnection.GetSchema();

OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM " + sheetName, myOleDbConnection);

dataReader = myOleDbCommand.ExecuteReader();

 isOpened = true; columns = new string[dataReader.FieldCount];

//get columns

for (int i = 0; i < columns.Length; i++)

{

columns[i] = dataReader.GetName(i);

}

}

catch (Exception ex)

{ string str = ex.Message; }