poi-ooxml

library5.5.1javamavenunverified

Provides APIs for reading and writing Office Open XML formats (e.g., .xlsx, .docx, .pptx).

<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi-ooxml</artifactId>
  <version>5.5.1</version>
</dependency>

homepage ↗docs ↗

INSTALL

IMPORT

SIG · POI-OOXML

poi-ooxml

utilityjavav5.5.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

XSSFWorkbook

✓ org.apache.poi.xssf.usermodel.XSSFWorkbook

Creates an Excel workbook and writes data to a cell.

import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Row; public class Example { public static void main(String[] args) throws Exception { XSSFWorkbook workbook = new XSSFWorkbook(); Sheet sheet = workbook.createSheet("Sheet1"); Row row = sheet.createRow(0); row.createCell(0).setCellValue("Hello"); // Write workbook to file } }

Debug

Known issues

gotchaPOI 5.x requires Java 8+; OOXML support may have large memory footprint.

fix

Use streaming (SXSSFWorkbook) for large files to reduce memory usage.

affects: >=5.0.0

Upgrade

Version history

5.5.1latest on Maven

Audit

Dependencies

No dependency data recorded yet.

Agent activity

7 hits · last 30 days

node

Amazon

Resources

homepagehttps://poi.apache.org/ ↗

docshttps://appdoc.app/artifact/org.apache.poi/poi-ooxml/ ↗