解决excelworkSheet.Dimension.End.Row报错

    xiaoxiao2022-07-04  262

    处理表格导入导出任务,获取表格行数的代码一开始是这样写的:

    public int GetRowCount()

    {

    if(currentSheet == null)   return 0;

    else return excelworkSheet.Dimension.End.Row;

    }

    excelworkSheet.Dimension.End.Row这行报错:未将对象引用到实例

    原因分析:当表格为空时,excelworkSheet.Dimension为空,excelworkSheet不为空,所以就会抛出NullReferenceException

    改进:

    public int GetRowCount()

    {

    if(currentSheet.Dimension == null)   return 0;

    else return excelworkSheet.Dimension.End.Row;

    }

    最新回复(0)