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, 1372🔥, 0💬
Popular Posts:
commons-collections4-4.2 -sources.jaris the source JAR file for Apache Commons Collections 4.2, whic...
iText is an ideal library for developers looking to enhance web- and other applications with dynamic...
JDK 11 jdk.jdi.jmod is the JMOD file for JDK 11 JDI (Java Debug Interface) tool. JDK 11 JDI tool com...
The Web Services Description Language for Java Toolkit (WSDL4J), Release 1.6.2, allows the creation,...
JDK 11 java.security.jgss.jmod is the JMOD file for JDK 11 Security JGSS (Java Generic Security Serv...