CalendarDemo - Apache POI Excel File Example

Q

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

✍: FYIcenter.com

A

CalendarDemo example in the Apache POI package is created by Yegor Kozlov. It can be used to generate a monthly calendar with each month on a separate sheet.

CalendarDemo example uses the Common Spreadsheet Format (SS) API, which supports Excel files in both *.xls and *.xlsx formats.

Here is the command to run CalendarDemo to generate 2016 calendar in *.xls file format compatible with Microsoft Excel 97 version.

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 
   org.apache.poi.ss.examples.CalendarDemo -xls 2016

If you open the output file, calendar.xls, in Excel, you will see a nice looking calendar as shown below:

Apache POI Excel File Example - CalendarDemo
Apache POI Excel File Example - CalendarDemo

 

TimesheetDemo - Apache POI Excel File Example

Apache POI Components for Excel Files

Apache POI Examples for Excel Files

⇑⇑ FAQ for Apache POI (Poor Obfuscation Implementation)

2017-03-17, 1457🔥, 0💬