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
