处理表格导入导出任务,获取表格行数的代码一开始是这样写的:
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;
}