这两天项目需求要检索excel的内容,于是就研究了一下,话不多说,我就直接贴代码1.首先是连接excel。
public DataTable SearchSheetToDT(string strSearch, stringsheetName)
{//文件路径
string path = Server.MapPath("~/Content/custom/Excel1.xlsx");//连接表字符串
string ExcelConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + @path + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=2;ImportMixedTypes=Text'";using (OleDbConnection ole_conn = newOleDbConnection(ExcelConnection))
{
ole_conn.Open();using (OleDbCommand ole_cmd =ole_conn.CreateCommand())
{
ole_cmd.CommandText=strSearch;
OleDbDataAdapter adapter= newOleDbDataAdapter(ole_cmd);
DataSet ds= newDataSet();
adapter.Fill(ds, sheetName);//sheetName就是excel里的sheet表名
DataTable dt = newDataTable();<