static DataTable GetSheetData(string excelFile, int sheetindex){ string sheetname = GetExcelSheetNames(excelFile)[sheetindex]; string srcConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFile + @";Extended Properties=""Excel 8.0;HDR=YES;"""; string srcQuery = "Select * from [" + sheetname + "]"; OleDbConnection srcConn = new OleDbConnection(srcConnString); srcConn.Open(); OleDbCommand objCmdSelect = new OleDbCommand(srcQuery, srcConn); DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(objCmdSelect); da.Fill(ds, sheetname); srcConn.Close(); return ds.Tables[0]; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)