{"id":54207,"library":"poi-ooxml","title":"Apache POI OOXML","description":"Provides APIs for reading and writing Office Open XML formats (e.g., .xlsx, .docx, .pptx).","status":"active","version":"5.5.1","language":"java","source_language":null,"source_url":null,"tags":["excel","ooxml","microsoft","office","poi"],"install":[{"cmd":"<dependency>\n  <groupId>org.apache.poi</groupId>\n  <artifactId>poi-ooxml</artifactId>\n  <version>5.5.1</version>\n</dependency>","lang":"xml","label":"Maven"},{"cmd":"implementation 'org.apache.poi:poi-ooxml:5.5.1'","lang":"groovy","label":"Gradle"}],"dependencies":[],"imports":[{"symbol":"XSSFWorkbook","correct":"org.apache.poi.xssf.usermodel.XSSFWorkbook"}],"quickstart":{"code":"import org.apache.poi.xssf.usermodel.XSSFWorkbook;\nimport org.apache.poi.ss.usermodel.Sheet;\nimport org.apache.poi.ss.usermodel.Row;\n\npublic class Example {\n    public static void main(String[] args) throws Exception {\n        XSSFWorkbook workbook = new XSSFWorkbook();\n        Sheet sheet = workbook.createSheet(\"Sheet1\");\n        Row row = sheet.createRow(0);\n        row.createCell(0).setCellValue(\"Hello\");\n        // Write workbook to file\n    }\n}","lang":"java","description":"Creates an Excel workbook and writes data to a cell."},"warnings":[{"fix":"Use streaming (SXSSFWorkbook) for large files to reduce memory usage.","message":"POI 5.x requires Java 8+; OOXML support may have large memory footprint.","severity":"gotcha","affected_versions":">=5.0.0"}],"env_vars":null,"search_vec":"'apach':1 'api':5 'docx':16 'e.g':14 'excel':18 'format':13 'microsoft':20 'offic':10,21 'ooxml':3,19 'open':11 'poi':2,22 'pptx':17 'provid':4 'read':7 'write':9 'xlsx':15 'xml':12","created_at":"2026-06-15T08:51:50.834144+00:00","updated_at":"2026-06-15T08:51:50.834144+00:00","problems":[],"ecosystem":"maven","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://poi.apache.org/","github":null,"docs":"https://appdoc.app/artifact/org.apache.poi/poi-ooxml/","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["utility","other"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-15","next_check":"2026-12-12","install_tag":null}}