EPPlus读取Excel
# EPPlus读取Excel
public DataTable ExcelToDataTable(string fileUrl)
{
FileInfo file=new FileInfo (fileUrl);
DataTable dt = null;
var package = new ExcelPackage(file);
ExcelWorkbook workbook = package.Workbook;
if (workbook !=null)
{
if (workbook .Worksheets .Count >0)
{
ExcelWorksheet worksheet = workbook.Worksheets.First();
dt = WorksheetToTable(worksheet);
}
}
return dt;
}
private static DataTable WorksheetToTable(ExcelWorksheet worksheet)
{
//获取worksheet的行数
int rows = worksheet.Dimension.End.Row;
//获取worksheet的列数
int cols = worksheet.Dimension.End.Column;
DataTable dt = new DataTable(worksheet.Name);
DataRow dr = null;
DataColumn dc = null;
for (int i = 1; i <= rows ; i++)
{
dr = dt.Rows.Add();
for (int j = 1; j <= cols; j++)
{
try
{
dr[j-1] = worksheet.Cells[i, j].Value is null? null: worksheet.Cells[i, j].Value.ToString();
}
catch (Exception ex)
{
}
}
}
return dt;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
上次更新: 2023/05/09, 17:54:37