java制作excel报表,用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);

http://www.gaodaima.com/40576.html用java制作excel格式报表

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

欢迎大家阅读《用java制作excel格式报表》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~