public static DataTable ExcelToDataTable(string fileName) { DataTable dt = new DataTable(); using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; IWorkbook workbook = application.Workbooks.Open(fileName, ExcelParseOptions.Default, true, "", ExcelVersion.Xlsx); //可以访问打开的excel IWorksheet sheet = workbook.Worksheets[0]; //第一 个sheet for (int col = 1; col <= sheet.Columns.Length; col++) { if (sheet.GetText(1, col) == null) { continue; } dt.Columns.Add(sheet.GetText(1, col), sheet.GetValueRowCol(1, col).GetType()); } for (int i = 2; i <= sheet.Rows.Length; i++) { DataRow dataRow = dt.NewRow(); for (int j = 1; j <= sheet.Columns.Length; j++) { dataRow[j - 1] = sheet.GetValueRowCol(i, j); } dt.Rows.Add(dataRow); } } return(dt); }