Posts

Showing posts from 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 ...

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...

Create Excel file using Java: Apache POI - PART - 1: Writing data

Image
This series of posts are intended towards creating excel files in xlsx format using Java's Apache POI Library. In this post we will create a basic Java project which will put some random data in the Excel file. This post will cover basic features of Apache POI like: Creating a workbook Creating multiple sheets in a workbook Creating rows and cells in those rows and feeding data in them. Creating cell border styles and background colour styles, aligning text in the cell. Please note that, we are also using a Jackson library to read the data from a JSON file. This JSON file data will be then saved in to a JAVA entity class. We will use this java entity class objects to write the data into excel file. Hence this tutorial also covers a basic understanding of using Jackson library as well.

ThE JOkE

Image
THE JOKE It was like a scene from a courtroom drama: crowded and shrouded in commotion & anxiety. Few minutes later, heads turned and silence ensued as THE VICTIM entered the room. She looked pathetic; her eyes blackened, her face wounded, her hair a terrible mess, her clothes tattered and bloodstained, yet, the one thing that stood out was she, herself. She looked lost, like in a trance or under a lot of sedatives. She took her seat in the centre, surrounded by different people forming a circular arrangement around her. She eventually spoke.