TimesheetDemo - Apache POI Excel File Example
What is TimesheetDemo example in the Apache POI package? How to run TimesheetDemo example?
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:
2017-03-17, 1252👍, 0💬
How to download and install JDK (Java Development Kit) 8? If you want to write Java applications, yo...
What Is javaws.jar in JRE (Java Runtime Environment) 8? javaws.jar in JRE (Java Runtime Environment)...
JAX-WS is an API for building web services and clients. It is the next generation Web Services API r...
Jakarta Regexp is a 100% Pure Java Regular Expression package that was graciously donated to the Apa...
Apache Avalon began in 1999 as the Java Apache Server Framework and in late 2002 separated from the ...