The below code shows how to write a simple Excel file using Apache POI libraries. The code uses a 2 dimensional data array to hold the data. Although it is not an opened file format, Java applications can still read and write Excel files using the Apache POI - the Java API for Microsoft. Apache POI is one of them and is well trusted over time. In short, you can read and write MS Excel files using Java. In addition, you can read. I need your help please. March 25, at 3: Can Any one help me to read the contents from multiple excel sheets and store the contents in bean Here is my sample code. Finally found the solution by adding the Below dependencies in the pom. October 27, at 9: April 27, at Can you please tell me how to open the newly created excel file and write results to that excel file. HSSF and XSSF common examples. March 23, at 6: In such cases, can u suggest me something that split the dat into multiple excel files, zip it and give the user a downloadable zip file option? In switch condition am getting error saying that cannot resolved. How to solve the problem. Your email address will not be published. HSSF stands for Horrible SpreadSheet Format! This is for quick reference. Hi, Viral does it works for. I got the sollution. March 17, at 9: Can you please tell me how to do that?