{"id":398,"date":"2015-05-16T10:27:08","date_gmt":"2015-05-16T09:27:08","guid":{"rendered":"http:\/\/www.pixnbgames.com\/blog\/?p=398"},"modified":"2015-08-21T23:51:55","modified_gmt":"2015-08-21T22:51:55","slug":"how-to-ms-excel-files-from-java-with-apache-poi","status":"publish","type":"post","link":"https:\/\/www.pixnbgames.com\/blog\/java\/how-to-ms-excel-files-from-java-with-apache-poi\/","title":{"rendered":"How to generate MS Excel files from Java with Apache POI"},"content":{"rendered":"

Commonly it’s necessary to manage Microsoft Excel files from Java applications. It can be usefull, for example, to export \/ import data, report generation, etc. Apache POI<\/a> is a library from Apache fundation, which has become a de facto standard for this type of tasks. In this article we will see an example of how to generate a simple excel file with Apache POI.<\/p>\n

Add project dependency<\/h2>\n

Using a Maven project, we can add the POI dependency like this:<\/p>\n

<dependencies>\r\n    <dependency>\r\n        <groupId>org.apache.poi<\/groupId>\r\n        <artifactId>poi<\/artifactId>\r\n        <version>3.12-beta1<\/version>\r\n    <\/dependency>\r\n<\/dependencies><\/pre>\n
If we are not using Maven, we have to download the library from here<\/a> and add it manually to our project.<\/p>\n
Excel Format<\/h2>\n
As we can see on its website<\/a>, apache POI give us two APIs:<\/p>\n