Aayubowan
Except for some instantiation problems, your code worked for me.
You need to set values for;
totalValue
and
columnHeaderRow
you have used them without initializing them.
Also, make sure you set the classpath to all the jars that come with POI.
Hope this helps
Any sufficiently advanced technology is indistinguishable from magic - Author C
Clark
________________________________
From: udeshika <perera....@gmail.com>
To: java-ee-j2ee-programming-with-passion@googlegroups.com
Sent: Mon, January 11, 2010 8:36:44 PM
Subject: [java ee programming] How can i create Excel file using java
Hi,
Anyone knows how to create a MS Excel file using java,i was tring to create a
file but it gives a exception when i run the programe.I'm using Apache PIO API
in eclips, for the my program.please help me to over come this problem.
Thanxx
Code
************************************************************************************************************************
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;
//import org.apache.poi.hssf.uti.*;
public class xxxxxx {
private static HSSFRow columnHeaderRow;
private static HSSFCell totalValue;
@SuppressWarnings("deprecation")
public static void main(String []args){
HSSFWorkbook workBook=new HSSFWorkbook();
HSSFSheet sheet = workBook.createSheet();
HSSFRow headerRow = sheet.createRow((short) 0);
sheet.addMergedRegion(new Region(0, (short) 0, 2,(short) 10));
HSSFCell headerCell = headerRow.createCell((short) 0);
headerCell.setCellValue("The Bowling Score");
HSSFCellStyle headerStyle =workBook.createCellStyle();
headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
headerCell.setCellStyle(headerStyle);
HSSFCellStyle columnHeaderStyle =workBook.createCellStyle();
columnHeaderStyle.setFillBackgroundColor(HSSFColor.BLUE_GREY.index);
columnHeaderStyle.setFillForegroundColor(HSSFColor.BLUE_GREY.index);
HSSFFont font = workBook.createFont();
font.setColor(HSSFFont.COLOR_RED);
columnHeaderStyle.setFont(font);
HSSFCell colHeading1 = columnHeaderRow.createCell((short) 0);
HSSFCell colHeading2 =columnHeaderRow.createCell((short) 4);
colHeading1.setCellStyle(columnHeaderStyle);
colHeading2.setCellStyle(columnHeaderStyle);
HSSFRow row1 = sheet.createRow((short) 5);
HSSFRow row2 = sheet.createRow((short) 6);
HSSFRow row3 = sheet.createRow((short) 7);
HSSFRow row4 = sheet.createRow((short) 8);
HSSFRow row5 = sheet.createRow((short) 9);
// create the 2 cells for each row
HSSFCell c11 = row1.createCell((short) 0);
HSSFCell c12 = row1.createCell((short) 4);
HSSFCell c21 = row2.createCell((short) 0);
HSSFCell c22 = row2.createCell((short) 4);
HSSFCell c31 = row3.createCell((short) 0);
HSSFCell c32 = row3.createCell((short) 4);
HSSFCell c41 = row4.createCell((short) 0);
HSSFCell c42 = row4.createCell((short) 4);
// writing data to the cells
c11.setCellValue("Sam");
c12.setCellValue(100);
c21.setCellValue("John");
c22.setCellValue(50);
c31.setCellValue("Paul");
c32.setCellValue(25);
c41.setCellValue("Richard");
c42.setCellValue(20);
totalValue.setCellType(HSSFCell.CELL_TYPE_FORMULA);
totalValue.setCellFormula("SUM(E6:E9)");
FileOutputStream stream;
try {
stream = new FileOutputStream("Book1.xls");
workBook.write(stream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
*******************************************************************************************
This is the Excception
************************************
org.apache.poi.hssf.dev.BiffViewer$CommandParseException: Biff viewer needs a
filename
at org.apache.poi.hssf.dev.BiffViewer$CommandArgs.parse(BiffViewer.java:321)
at org.apache.poi.hssf.dev.BiffViewer.main(BiffViewer.java:370)
Regards ,
Udeshika Perera.
--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en
