Posts

Showing posts from November, 2018

Create Excel file using Java: Apache POI - PART - 2: Line Chart

Image
This post is second part of the a series of post for creating excel files using Apache's POI library in Java. If you don't know about basic creation of excel file using JAVA code, please refer the first part for that. Link for first part:   http://youthhworld.blogspot.com/2018/09/Java-Excel-Apache-POI-part1.html In this post we will discuss about how to make Line charts for some sample data in excel file using Java code and Apache's POI library. Interesting fact: Did you know? that excel file is nothing but it is a zipped package of XML files. The data of these XML files is represented in tabular form using these Excel or other similar software. Try it yourself: change an excel file's extension from .xlsx or .xls to ZIP and the open that file using WinZip WinRar or other available Zip file opener software. You will find the sheet and chart data in the xml file format present inside this sheet. It will also be having other metadata information store in this zip p