TimesheetDemo - Apache POI Excel File Example

Q

What is TimesheetDemo example in the Apache POI package? How to run TimesheetDemo example?

✍: FYIcenter.com

A

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:
Apache POI Excel File Example - TimesheetDemo

 

Apache POI Examples for Excel Files

⇒⇒FAQ for Apache POI (Poor Obfuscation Implementation)

2017-03-17, 159👍, 0💬