Posts

Showing posts from December, 2018

Create Excel file using Java: Apache POI - PART - 3: Bar Chart

Image
Pre-requisite: If you haven't read the first two par or at least the first part of this series of posts and you don't have any prior knowledge to make simple excel files using java's Apache POI  library. Then please go ahead and have a look at them first. Below are the link for the same: Create Excel file using Java: Apache POI - PART - 1: Writing data  Create Excel file using Java: Apache POI - PART - 2: Line Chart In this post we are going to see the code snippets on how to make Bar charts using Apache POI library in excel files. To better understand which classes and methods of those classes should be used in what hierarchy, please make a sample bar chart yourself on a sample data set in excel file using Microsoft word, and then change the file name extension to zip and open the file using WinZip or similar software and open the chart1.xml file as mentioned in the Part-2 article. This xml file is having the hierarchical structure of Bar chart and the nodes of th