poi依赖
| <dependency> |
| <groupId>org.apache.poi</groupId> |
| <artifactId>poi</artifactId> |
| <version>4.1.2</version> |
| </dependency> |
| public static void main(String[] args) { |
| File file = new File("文件路径"); |
| Workbook workbook = readExcel(file); |
| handleData(workbook); |
| try { |
| FileOutputStream stream = FileUtils.openOutputStream(file); |
| workbook.write(stream); |
| stream.close(); |
| } catch (IOException e) { |
| e.printStackTrace(); |
| } |
| } |
示例1
| public static void handleData(Workbook workbook){ |
| Sheet sheet = workbook.getSheetAt(0); |
| Row titleRow = sheet.getRow(0); |
| short lastCellNum = titleRow.getLastCellNum(); |
| int titleNum = -1; |
| for (int i = 0; i < lastCellNum; i++) { |
| if (titleRow.getCell(i).getStringCellValue().equals("征用")) { |
| titleNum = i; |
| break; |
| } |
| } |
| |
| for (int rowNum = 0; rowNum <= sheet.getLastRowNum(); rowNum++) { |
| Row row = sheet.getRow(rowNum); |
| if (row != null) { |
| if (row.getLastCellNum() < 1 || "".equals(row.getCell(0))) { |
| continue; |
| } |
| } |
| Cell cell = row.getCell(titleNum); |
| if (cell == null) { |
| row.createCell(titleNum).setCellValue("呀呀呀"); |
| } else if ("".equals(cell.getStringCellValue())) { |
| cell.setCellValue("呀呀呀呀呀"); |
| } |
| } |
| } |
获取工作簿
| public static Workbook readExcel(File file) { |
| Workbook xssfWorkbook = null; |
| try { |
| |
| String fileName = file.getName(); |
| |
| String fileType = fileName.substring(fileName.lastIndexOf(".") + 1); |
| |
| InputStream stream = new FileInputStream(file); |
| |
| xssfWorkbook = null; |
| if (fileType.equals("xls")) { |
| xssfWorkbook = new HSSFWorkbook(stream); |
| } else if (fileType.equals("xlsx")) { |
| xssfWorkbook = new XSSFWorkbook(stream); |
| } else { |
| System.out.println("excel格式不正确"); |
| } |
| } catch (IOException e) { |
| e.printStackTrace(); |
| } |
| return xssfWorkbook; |
| } |
| ```java |
| </details> |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· NetPad:一个.NET开源、跨平台的C#编辑器