Gradle Declarative Build System

How to write and read excell files in java

Enterprise systems developers very frequently find themselves in a situation whereby they need to generate PDF, excel, word, CSV and other file formats to present the data from their products or systems. Going down to the primitive JDK I/O facility becomes somewhat of a nightmare and this creates the need for a third party library that has the required implementation that facilitates this growing need.

For pdf documents the most advisable and frequently use open source Library is iText. iText is an open source pdf generation library developed by Apache Software Foundation.

In this tutorial, we are going to explore writing and reading a pdf file with Apache POI.

Step 1. Download Apache POI 

You can find and download Apache POI from the official  download site .

Step 2. Add the jar file to your Project libs folder.

This step depends on the IDE you are using for your development. This tutorial explains how to achieve this view inteliji IDEA community edition 2017 and Netbeans IDE 8.0.2.
 1. With Inteliji IDEA

 To download inteliji just follow this link.

 The set up in inteliji is simple just click the file menu -> project settings -> Module ->then click the plus icon the right -> select the folder with the jar file and click ok then apply.

Once you are done with the set up you, we  can move to write our hello.xmls file.

Open the editor section and type the following code. First create file chooser that eanbles user to select where our hello file will go.

 Next create a FileOutputStream instance to handle file I/O actions.

Next create a WorkBook instance which represents a single spreadsheet.

The next thing is to create a spreadsheet instance with XSSFSpreadSheet, on line 21.

After this you need to create a cells row and cells in them with  content in the cell.