Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
AligningCells - Apache POI Excel File Example
What is AligningCells example in the Apache POI package? How to run AligningCells example?
✍: FYIcenter.com
AligningCells example in the Apache POI package is created by Cristian Petrula.
It shows how various alignment options work when generating *.xlsx files.
AligningCells example uses the XSSF (OpenXML SpreadSheet Format) API, which supports Excel files in *.xlsx format only.
Here is the command to run AligningCells to generate a sample *.xlsx file.
C:\fyicenter>c:\local\jdk-1.8.0\bin\java -cp .;C:\local\poi-3.15\poi-examples-3.15.jar; C:\local\poi-3.15\poi-3.15.jar; C:\local\poi-3.15\poi-ooxml-3.15.jar; C:\local\poi-3.15\ooxml-lib\xmlbeans-2.6.0.jar; C:\local\poi-3.15\lib\commons-collections4-4.1.jar; C:\local\poi-3.15\poi-ooxml-schemas-3.15.jar org.apache.poi.xssf.usermodel.examples.AligningCells
If you open the output file, xssf-align.xlsx, in Excel, you will see text in different cells are aligned differently:
⇒ XLSX2CSV - Apache POI Excel File Example
⇐ ScatterChart - Apache POI Excel File Example
2017-03-11, 1496🔥, 0💬
Popular Posts:
JDK 11 jdk.internal.le.jmod is the JMOD file for JDK 11 Internal Line Editing module. JDK 11 Interna...
commons-net-1.4.1.jar is the JAR file for Apache Commons Net 1.4.1, which implements the client side...
commons-collections4-4.4 -sources.jaris the source JAR file for Apache Commons Collections 4.2, whic...
What Is HttpComponents httpcore-4.2.2.jar? HttpComponents httpcore-4.2.2.jar is the JAR file for Apa...
JDK 11 jdk.internal.vm.ci.jmod is the JMOD file for JDK 11 Internal VM CI module. JDK 11 Internal VM...