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, 1458🔥, 0💬
Popular Posts:
JDK 11 jdk.internal.le.jmod is the JMOD file for JDK 11 Internal Line Editing module. JDK 11 Interna...
iText is an ideal library for developers looking to enhance web- and other applications with dynamic...
JDK 11 java.compiler.jmod is the JMOD file for JDK 11 Compiler module. JDK 11 Compiler module compil...
commons-io-1.4.jar is the JAR file for Commons IO 1.4, which is a library of utilities to assist wit...
How to run "jar" command from JDK tools.jar file? "jar" is the JAR (Java Archive) file management co...