用java制作excel格式报表

try{

getDBConnection();

pstmt = conn.prepareStatement(strSql);

ret = pstmt.executeQuery();

File tempFile=new File(filename);

try{

WritableWorkbook workbook = Workbook.createWorkbook(tempFile);

WritableSheet sheet = workbook.createSheet("sheet1", 0);

Label l=null;

jxl.write.Number n=null;

jxl.write.DateTime d=null;

WritableFont headerFont = new WritableFont(WritableFont.ARIAL,12,WritableFont.BOLD,false, UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLUE);

WritableCellFormat headerFormat = new WritableCellFormat (headerFont);

WritableFont titleFont = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false, UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);

WritableCellFormat titleFormat = new WritableCellFormat (titleFont);

WritableFont detFont = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false, UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);

WritableCellFormat detFormat = new WritableCellFormat (detFont);

NumberFormat nf=new NumberFormat("0.00000");

WritableCellFormat priceFormat = new WritableCellFormat (detFont, nf);

DateFormat df=new DateFormat("yyyy-MM-dd");

WritableCellFormat dateFormat = new WritableCellFormat (detFont, df);

l=new Label(2,0,"",headerFormat);

sheet.addCell(l);

int intTitle = title.length;

for (int i=0;i<intTitle;i++)

{

l=new Label(i,2,title[i], titleFormat);

sheet.addCell(l);

}

int k = 0;

while(ret.next())

{

k++;

for (int j=1;j<intTitle;j++)

{

l=new Label(j-1,k+3,ret.getString(j),detFormat);

sheet.addCell(l);

//sheet.setColumnView(j,30);

}

}

workbook.write();

workbook.close();

} catch(Exception e){}

}

catch(SQLException ae) {

throw new ApplicationException("创建Excel时查询数据库操作失败! " +

"错误信息:" +strSql + ",异常信息为 :\n" + ae.getMessage());

} finally {

closeResultSet(ret);

closeStatement(pstmt);

closeConnection();

}

}