apache poi重写 apachepoi重写|ApachePOI教程

本文概述

Apache POI重写示例

要将数据重写到现有的excel文档中，Apache POI提供了各种方法getRow（），getCell（），getSheet（）等。
Apache POI重写示例

package poiexample; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import org.apache.poi.EncryptedDocumentException; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class RewritingExample { public static void main(String[] args) throws FileNotFoundException, IOException, EncryptedDocumentException, InvalidFormatException { try (InputStream inp = new FileInputStream("srcmini.xls")) { Workbook wb = WorkbookFactory.create(inp); Sheet sheet = wb.getSheetAt(0); Row row = sheet.getRow(2); Cell cell = row.getCell(3); if (cell == null) cell = row.createCell(3); cell.setCellType(CellType.STRING); cell.setCellValue("101"); try (OutputStream fileOut = new FileOutputStream("srcmini.xls")) { wb.write(fileOut); } }catch(Exception e) { System.out.println(e); } } }

输出：