Showing posts with label POI. Show all posts
Showing posts with label POI. Show all posts
2019/11/12

[Apache POI] How to read large excel file

›
Problem I am trying to read a large excel file , around 700000 records, via Apache POI. It takes  lots of time and resources to read this ...
2019/10/14

[Apache POI] How to set formula from another sheet?

›
Problem I had two sheets in my excel file. If some of cells in first sheet's formula is from second sheet, how to fulfill this require...
2019/10/12

[Apache POI] 常用 CellStyle 設定

›
Sample code: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 // 為 cell 上色 CellStyle headerCellSt...
2019/10/11

[Apache POI] How to draw border in Apache POI?

›
Problem I would like to draw border as bellows: How-To You can make good use of   PropertyTemplate  to draw border with ease. If ...
2019/09/14

[Apache POI] How to set formula in Excel via Apache POI?

›
Problem How to set formula in Excel via Apache POI? How-To Sample code: // 1. create sheet from workbook Sheet sheet= workbook...
2019/09/13

[Apache POI] How to set merge cell in Apache POI ?

›
Problem I would like to merge A4 and B4  How-To According to Apache POI quick guide, we can use addMergedRegion to fulfill this requi...
2019/01/12

[Java] [POI] org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML.

›
Problem Here has a code snippet to read excel file (.xls file) try ( InputStream inputStream = new FileInputStream ( new File ( ...
2016/12/07

[Apache POI] java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters

›
Problem I am using Apache POI to write data into Microsoft Excel, but it throw this exception during the process: java . lang . IllegalA...
1 comment:
2016/09/08

[Apache POI] How to freeze the first row

›
Problem I am using Apache POI to write data into Microsoft Excel.  If I would like to keep the first row on the top of this document when ...
2016/09/07

[Apache POI] How to add new line in cell data

›
Problem I am using Apache POI to write data into Microsoft Excel. I would like to break data into new line in some cell, how to do it? ...
2016/09/04

[POI] Write /Read Excel Files in Java using Apache POI

›
Here has a simple example to demonstrate how to write / read excel file via Apache POI. Add Apache POI dependency: <dependency> ...