Apache POI tutorial

The Microsoft Excel is one of the most widely spread ways to organize report or structured data in a friendly and readable format. According to this, Java Developers from time to time have a need for some libraries that could work with the Microsoft Excel.

The Apache POI is a product of the Apache Software Foundation and it provides a possibility to read and write files in the Microsoft Excel format.

With the Apache POI you can:
* create .xls file;
* create .xlsx file;
* add data to Excel file;
* read Excel file;
* add styles and formatting to an Excel sheet (font size and style, borders, background, format as a table, etc);
* manage sheet (hide sheet, unhide sheet, set sheet as active, protect sheet with a password);
* manage data on a sheet (hide/unhide columns, hide/unhide rows, merge cells);
* add formulas to cells;
* create charts