Re: Problem with LArge Excel Sheet Generation

[Rajeshwar Mothe]

hi dear vinamra.singhai

 i got this error but i am able to generate large excel file using this
Export.java file

y cant u try it in ur code u r trying to generate new spread sheet i
suppose plzz go thre this code

good luck



package com.vl.hr.reports.action;

import java.util.ArrayList;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.log4j.Logger;
import com.vl.hr.reports.values.Lists;

 class Export
{
 private static Logger log = Logger.getLogger(Export.class);
 //creating a workbook;
 HSSFWorkbook wb = new HSSFWorkbook();
  public HSSFWorkbook exportExcel(Lists lists, ArrayList list2, String
title)
 {
  String[] outputs=lists.getOutputs();
  String[] outputTypes=lists.getOutputTypes();


  ArrayList al=list2;
  try{
    //creating a worksheet
    HSSFSheet sheet=wb.createSheet("First sheet");

    HSSFCellStyle cs = wb.createCellStyle();
    HSSFCellStyle cs2 = wb.createCellStyle();
    HSSFCellStyle cs3 = wb.createCellStyle();
    // create 2 fonts objects
    HSSFFont f = wb.createFont();
    HSSFFont f2 = wb.createFont();

    //set font 1 to 12 point type
    f.setFontHeightInPoints((short) 12);
    //make it red
    f.setColor((short) HSSFColor.RED.index);
    // make it bold
    //arial is the default font
    f.setBoldweight(f.BOLDWEIGHT_BOLD);
    //creation of the row for Titles
    HSSFRow row=sheet.createRow(0);

    //for loop, creating cell headings
    for(int i=0;i<outputs.length;i++)
    {
     HSSFCell cell=row.createCell((short)i);
     //set cell stlye
           cs.setFont(f);
     HSSFRichTextString str=new HSSFRichTextString(outputs[i]);
     cell.setCellValue(str);
    }
    int size = list2.size();
    for(int i=0;i<size;i++)
    {
     row=sheet.createRow(i+1);

     //creating a arraylist for internallists
     ArrayList al2=(ArrayList)list2.get(i);
     int al2size = al2.size();
     for(int j=0;j<al2size;j++)
     {
      HSSFCell cell=row.createCell((short)j);

      if(outputTypes[j].equals("String")){
       cell.setCellValue((String)al2.get(j));
      }
      else if(outputTypes[j].equals("double")){
       cell.setCellValue(((Double)al2.get(j)).doubleValue());
      }
      else if(outputTypes[j].equals("long")){
       cell.setCellValue(((Long)al2.get(j)).longValue());
      }
      else if(outputTypes[j].equals("Date")){
       cell.setCellValue((String)al2.get(j));
      }
     }
    }
  }catch(Exception e)
  {
   log.error("Error writing the Excel file");
   log.debug(e.getMessage());

  }
  return wb;
 }

}