在项目中添加对 Aspose.Cells.dll的引用
/// <summary>
/// 获取Excel中的数据,根据Sheet名字获取数据/// </summary>
/// <param name="excelPath">文件路径</param>
/// <param name="sheetName">需要打开的sheet名称</param>
/// <returns></returns>
public static DataSet OpenExcelFile(string excelPath, string sheetName)
{
DataSet ds = new DataSet();
Workbook workBook = new Workbook(excelPath);
Worksheet workSheet = workBook.Worksheets[sheetName];
Cells cell = workSheet.Cells;
DataTable dt = new DataTable();
int count = cell.Columns.Count;
for (int i = 0; i < count; i++)
{
string str = cell.GetRow(0)[i].StringValue;
dt.Columns.Add(new DataColumn(str));
}
for (int i = 1; i < cell.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
for (int j = 0; j < count; j++)
{
dr[j] = cell[i, j].StringValue;
}
dt.Rows.Add(dr);
}
dt.AcceptChanges();
ds.Tables.Add(dt);
return ds;
}