General - CalendarDemo - Apache POI Excel File Example

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 Examples for Excel Files

⇒⇒FAQ for Apache POI (Poor Obfuscation Implementation)

2017-03-17, 493👍, 0💬

Apache POI Components for Excel Files
What are Apache POI components that can be used to read and write Microsoft Excel files? There are 3 components in the Apache POI Java library that can be used to read and write Microsoft Excel spreadsheet files: HSSF (Horrible Spreadsheet Format) component provides API to read and write older versi... 2017-03-17, 594👍, 0💬

CalendarDemo - Apache POI Excel File Example
What is CalendarDemo example in the Apache POI package? How to run CalendarDemo example? 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 Form... 2017-03-17, 494👍, 0💬

WorkingWithFonts - Apache POI Excel File Example
What is WorkingWithFonts example in the Apache POI package? How to run WorkingWithFonts example? WorkingWithFonts example in the Apache POI package is created by Glen Stampoultzis. It demonstrates how to create and use fonts in *.xls file format. WorkingWithFonts example uses the HSSF (Horrible Spre... 2017-03-17, 472👍, 0💬

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 formul... 2017-03-17, 452👍, 0💬

All rights in the contents of this web site are reserved by the individual author. FYIcenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.