读取Excel表格内容

读取Excel表格内容

/// <summary>
/// 读取excel文件内容
/// </summary>
/// <param name="filePath">文件路径</param>
/// <param name="columnNum">行数</param>
/// <param name="rowNum">列数</param>
/// <returns></returns>
public DataRowCollection ReadExcel(string filePath, ref int columnNum, ref int rowNum)
{
    FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
    IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

    DataSet result = excelReader.AsDataSet();
    //Tables[0] 下标0表示excel文件中第一张表的数据
    columnNum = result.Tables[0].Columns.Count;
    rowNum = result.Tables[0].Rows.Count;
    return result.Tables[0].Rows;
}

/// <summary>
/// 读取excel表数据，生成对应数组
/// </summary>
/// <param name="excelPath">名称+ID表路径</param>
/// <returns></returns>
public Diction