C_读取Excel_sheet方法.docVIP

C#读取Excel sheet方法 最近忙着思考项目优化的工作，发现以前 导入excel的时候，再执行“如何获取excel要导入的sheet名称”的时候特别慢，今天在网上找了比较好，并且更方便的方法; 原先导入excel代码如下： private void EcxelToGridView() { labelControl1.Text = ; //根据路径打开一个Excel文件并将数据填充到ds中 string strConn = Provider=Microsoft.Jet.OLEDB.4.0;Data Source = + BtnExcPath.Text + ;Extended Properties =Excel 8.0;HDR=YES;IMEX=1; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ; OleDbDataAdapter myCommand = null; //获取Excel中的sheet的名称（当执行到这句的时候特别慢，消耗资源太多） string SheetName = GetExcelSheetNames(BtnExcPath.Text)[0]; //方法一：直接写死为第一个sheet1，这么扩展性不好 //strExcel = select * from [sheet1$]; //方法二：目前也是只取第一页但是可以给出提示 strExcel = select * from [ + SheetName + $]; myCommand = new OleDbDataAdapter(strExcel, strConn); System.Data.DataSet ds = new System.Data.DataSet(); myCommand.Fill(ds, table1); conn.Close(); Liststring strList = new Liststring(); string str = string.Empty; strList.Clear(); if (ds.Tables[table1].Rows.Count == 0) { MessageBoxShow.ShowProMessage(要导入的Excel没有数据); } } /// summary /// 获取获得当前你选择的Excel Sheet的所有名字 /// /summary /// param name=filePath/param /// returns/returns public static string[] GetExcelSheetNames(string filePath) { Microsoft.Office.Interop.Excel.ApplicationClass excelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); Microsoft.Office.Interop.Excel.Workbooks wbs = excelApp.Workbooks; Microsoft.Office.Interop.Excel.Workbook wb = wbs.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.M