{"repo":"T5750/poi-repositories","free":true,"listed":false,"github":"https://github.com/T5750/poi-repositories","clone":"git clone https://github.com/T5750/poi-repositories.git","description":":sunny: Read and Write Excel file using Java and Apache POI","language":"Java","stars":339,"topics":["poi","java","excel","derby","hibernate","bootstrap4","spring","spring-boot"],"license":"Apache-2.0","category":"deployment-docker-iac","readme_excerpt":"Demos using Apache POI Docs - https://poix.readthedocs.io Getting Started Step 1: Download Step 2: Start Server http://localhost:8080/poi Tests - TestReadExcel , TestReadExcelDemo - TestExportExcel , TestExportExcel2007 , TestWriteExcelDemo - TestTemplate , TestExcelReplace - CalendarDemo - TestExcelFormulaDemo , TestExcelStylingDemo , TestAll Runtime Environment - Java 8 - Spring Framework 5.x - Spring Boot 2.x - Derby 10.x - Hibernate ORM 5.x - POI 5.x - Bootstrap 4.x - Docker 19.x Classes 1. HSSF, XSSF and XSSF classes Apache POI main classes usually start with either HSSF , XSSF or SXSSF . - HSSF – is the POI Project’s pure Java implementation of the Excel ’97(-2007) file format. e.g. HSSFWorkbook, HSSFSheet. - XSSF – is the POI Project’s pure Java implementation of the Excel 2007 OOXML (.xlsx) file format. e.g. XSSFWorkbook, XSSFSheet. - SXSSF (since 3.8-beta3) – is an API-compatible streaming extension of XSSF to be used when very large spreadsheets have to be produced, and heap space is limited. e.g. SXSSFWorkbook, SXSSFSheet. SXSSF achieves its low memory footprint by limiting access to the rows that are within a sliding window , while XSSF gives access to all rows in the document. 2. Row and Cell Apart from above classes, Row and Cell are used to interact with a particular row and a particular cell in excel sheet. 3. Style Classes A wide range of classes like CellStyle, BuiltinFormats, ComparisonOperator, ConditionalFormattingRule, FontFormatting, IndexedColors, Patt","default_branch":null,"files":null,"tree":[],"storefront":"/r/T5750","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/T5750/poi-repositories/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}