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, 1364🔥, 0💬
Popular Posts:
What Is commons-fileupload-1.3.3 .jar?commons-fileupload-1.3.3 .jaris the JAR file for Apache Common...
JDK 11 jdk.scripting.nashorn.jm odis the JMOD file for JDK 11 Scripting Nashorn module. JDK 11 Scrip...
JDK 11 java.naming.jmod is the JMOD file for JDK 11 Naming module. JDK 11 Naming module compiled cla...
What Is HttpComponents httpcore-4.4.6.jar? HttpComponents httpcore-4.4.6.jar is the JAR file for Apa...
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...