背景:POI解析EXCEL表格报此异常
原因:当单元格有引用其他表格中单元格的值时,而且引用不正确或找不到引用表格时,则会出现此异常
引用错误或找不到引用表格时,单元格会显示错误且POI解析时会报异常,如图所示:
Could not resolve external workbook name ‘xxx‘. Workbook environment has not been set up.
背景:POI解析EXCEL表格报此异常
原因:当单元格有引用其他表格中单元格的值时,而且引用不正确或找不到引用表格时,则会出现此异常
引用错误或找不到引用表格时,单元格会显示错误且POI解析时会报异常,如图所示:
Could not resolve external workbook name ‘xxx‘. Workbook environment has not been set up.