Java Excel 文件导入优化：处理无效文件扩展名和改进错误处理

{/'title/': /'Java Excel 文件导入优化：处理无效文件扩展名和改进错误处理/', /'description/': /'本文档演示了如何优化 Java 代码以处理 Excel 文件导入，包括添加对无效文件扩展名的检查、改进错误处理机制以及提供清晰的代码注释。/', /'keywords/': /'Java, Excel, 文件导入, 优化, 错误处理, 文件扩展名, 代码注释/', /'content/': /'public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception {//n Workbook workbook = null;//n InputStream inputStream = file.getInputStream();//n String fileExtension = getFileExtension(Objects.requireNonNull(file.getOriginalFilename()));//n // 根据文件类型进行区分//n if (fileExtension.equals(/'xlsx/')) {//n workbook = new XSSFWorkbook(inputStream);//n } else if (fileExtension.equals(/'xls/')) {//n workbook = new HSSFWorkbook(inputStream);//n } else {//n return AjaxResult.error(/'Invalid file extension/');//n }//n//n String sheetName = /'a-HKG BW WHSE-in bound/'; // 导入信息的工作表名称//n Sheet sheet = workbook.getSheet(sheetName);//n if (sheet == null) {//n throw new IllegalArgumentException(/'Sheet with name /' + sheetName + /' does not exist/');//n }//n InputStream sheetInputStream = workbookToInputStream(workbook); // 更具描述性的变量名//n ExcelUtil util = new ExcelUtil<>(AHkgBwWhseInBound.class);//n List dataManagementList = util.importExcel(sheetInputStream, 1);//n String operName = ShiroUtils.getSysUser().getLoginName();//n String message = aHkgBwWhseInBoundService.importData(dataManagementList, updateSupport, operName);//n return AjaxResult.success(message);//n}//n//nprivate static String getFileExtension(String fileName) {//n int dotIndex = fileName.lastIndexOf(/'./');//n if (dotIndex != -1 && dotIndex != 0) {//n return fileName.substring(dotIndex + 1);//n } else {//n return /'/';//n }//n}//n//nprivate static InputStream workbookToInputStream(Workbook workbook) throws IOException {//n ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();//n workbook.write(byteArrayOutputStream);//n return new ByteArrayInputStream(byteArrayOutputStream.toByteArray());//n}/