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:
TimesheetDemo - Apache POI Excel File Example
What is TimesheetDemo example in the Apache POI package? How to run TimesheetDemo example?
✍: FYIcenter.com
TimesheetDemo example in the Apache POI package is created by Yegor Kozlov. It can be used to generate a weekly timesheet with automatic calculation of total hours. It demonstrates advance usage of cell formulas.
TimesheetDemo example uses the Common Spreadsheet Format (SS) API, which supports Excel files in both *.xls and *.xlsx formats.
Here is the command to run TimesheetDemo to generate a timesheet in *.xlsx file format compatible with Microsoft Excel 2007 version. Note that additional JAR files are needed to generate *.xlsx files.
C:\fyicenter>\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.ss.examples.TimesheetDemo -xlsx
If you open the output file, timesheet.xlsx, in Excel, you will see a nice looking timesheet as shown below:
⇒ WorkingWithFonts - Apache POI Excel File Example
⇐ CalendarDemo - Apache POI Excel File Example
2017-03-17, 1571🔥, 0💬
Popular Posts:
JDK 11 jdk.httpserver.jmod is the JMOD file for JDK 11 HTTP Server module. JDK 11 HTTP Server module...
How to download and install ojdbc14.jar for Oracle 10g R2? ojdbc14.jar for Oracle 10g R2 is a Java 1...
JRE 8 rt.jar is the JAR file for JRE 8 RT (Runtime) libraries. JRE (Java Runtime) 8 is the runtime e...
Xalan-Java, Version 2.7.1, is an XSLT processor for transforming XML documents into HTML, text, or o...
JDK 11 jdk.jlink.jmod is the JMOD file for JDK 11 JLink tool, which can be invoked by the "jlink" co...