<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.2</version> </dependency> import org.apache.poi.ss.usermodel.*; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; public class ExcelReadWriteExample { public static void main(String[] args) { try { Workbook workbook = new XSSFWorkbook(); Sheet sheet = workbook.createSheet("Sheet1"); Row row = sheet.createRow(0); Cell cell = row.createCell(0); cell.setCellValue("Hello, World!"); FileOutputStream fos = new FileOutputStream(new File("example.xlsx")); workbook.write(fos); fos.close(); FileInputStream fis = new FileInputStream(new File("example.xlsx")); workbook = WorkbookFactory.create(fis); fis.close(); sheet = workbook.getSheet("Sheet1"); row = sheet.getRow(0); cell = row.getCell(0); System.out.println(cell.getStringCellValue()); } catch (Exception e) { e.printStackTrace(); } } }


上一篇:
下一篇:
切换中文