Create an excel file from JAVA using HSSF api

[Former Member]

Introduction

I see numerous questions on forum about how to read and write an excel file from Java. So, I have decided
to present java code to create an excel file and display it in EP6 portal using AbstractPortalComponent.
I am going to use HSSF's apis to create an excel file. HSSF is part of open source POI project.
These apis can also be used to read microsoft excel file from java. For more information about POI check out the site http://jakarta.apache.org

Required Jars:

You can download the following jars from http://jakarta.apache.org.

servlet.jar, poi-2.5.1-final-20040804.jar, poi-contrib-2.5.1-final-20040804.jar, poi-scratchpad-2.5.1-final-20040804.jar

Steps to create PAR component

Step 1:

Create an AbstractPortalComponent using Eclipse or Netweaver Studio. Add the above jars to PORTAL-INF->lib folder.

Step 2:

Add the following lines to doContent method.

public void doContent(  IPortalComponentRequest request,  IPortalComponentResponse response) {  //Create a workbook  HSSFWorkbook wb = new HSSFWorkbook();  //Create an sheet attached to the workbook  HSSFSheet sheet = wb.createSheet("Webinar Sheet");  // Create a row (header)  HSSFRow row = sheet.createRow((short) 0);  // Create all cells and put all value in it.  row.createCell((short) 0).setCellValue("Date");  row.createCell((short) 1).setCellValue("Topic");  row.createCell((short) 2).setCellValue("Area");  row.createCell((short) 3).setCellValue("Presenter");  row.createCell((short) 4).setCellValue("Group");  //Create another row   row = sheet.createRow((short) 1);  // Create all cells and put all value in it.  row.createCell((short) 0).setCellValue("16 March 05");  row.createCell((short) 1).setCellValue(   "Configuring a Local Adapter Engine to Work with a Central Instance");  row.createCell((short) 2).setCellValue("NW");  row.createCell((short) 3).setCellValue("Sukumar Natarajan");  row.createCell((short) 4).setCellValue("RIG Know-How series");  //Create another row  row = sheet.createRow((short) 2);  // Create all cells and put all value in it.  row.createCell((short) 0).setCellValue("17 March 05");  row.createCell((short) 1).setCellValue(   "Load Testing Knowledge Management");  row.createCell((short) 2).setCellValue("NW");  row.createCell((short) 3).setCellValue("Hartmut Goetze");  row.createCell((short) 4).setCellValue("RIG Know-How series");  //  Create another row  row = sheet.createRow((short) 3);  // Create all cells and put all value in it.  row.createCell((short) 0).setCellValue("10 March 05");  row.createCell((short) 1).setCellValue(   "Tips & Tricks for FOX Formulas in BW-BPS");  row.createCell((short) 2).setCellValue("NW");  row.createCell((short) 3).setCellValue("Marc Bernard");  row.createCell((short) 4).setCellValue("RIG Know-How series");  HttpServletResponse res = request.getServletResponse(true);  try {   res.setContentType("application/vnd.ms-excel");   wb.write(res.getOutputStream());  } catch (Exception e) {   e.printStackTrace();  } }

Step 3:

Deploy it in portal and run it. You should get the following output.