:sunny: Read and Write Excel file using Java and Apache POI
Step 1: Download
git clone https://github.com/T5750/poi.git
cd poi
Step 2: Start Server
docker-compose up -d
# or
mvn clean spring-boot:run
TestReadExcel
, TestReadExcelDemo
TestExportExcel
, TestExportExcel2007
, TestWriteExcelDemo
TestTemplate
, TestExcelReplace
CalendarDemo
TestExcelFormulaDemo
, TestExcelStylingDemo
, TestAll
Apache POI main classes usually start with either HSSF, XSSF or SXSSF.
Apart from above classes, Row and Cell are used to interact with a particular row and a particular cell in excel sheet.
A wide range of classes like CellStyle, BuiltinFormats, ComparisonOperator, ConditionalFormattingRule, FontFormatting, IndexedColors, PatternFormatting, SheetConditionalFormatting etc. are used when you have to add formatting in a sheet, mostly based on some rules.
Another useful class FormulaEvaluator is used to evaluate the formula cells in excel sheet.
Having trouble with T5750's POI? We’d like to help!
This project is Open Source software released under the Apache 2.0 license.