有时候我们会需要做excel的报表,下面这个例子详细的给出了读写及定义样式的方法。(jexcel下载) package com.test; import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.format.Border; import jxl.format.BorderLineStyle; import jxl.format.Colour; import jxl.read.biff.BiffException; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; /** */ /** * * CopyRight (C) www.blogjava.net/ilovezmh All rights reserved.<p> * * WuHan Inpoint Information Technology Development,Inc.<p> * * Author zhu<p> * * @version 1.0 2007-2-6 * * <p>Base on : JDK1.5<p> * */ public class JexcelSample ... { /** *//** * 写excel文件 * */ public void writeExc(File filename)...{ WritableWorkbook wwb = null; try ...{ wwb = Workbook.createWorkbook(filename); } catch (Exception e)...{ e.printStackTrace(); } //创建Excel工作表 WritableSheet ws = wwb.createSheet("通讯录", 0);//创建sheet try ...{ ws.mergeCells(0, 0, 2, 1);//合并单元格(左列,左行,右列,右行)从第1行第1列到第2行第3列 Label header = new Label(0, 0, "通讯录(191026班)", getHeader()); ws.addCell(header);//写入头 Label l = new Label(0, 2, "姓名", getTitle());//第3行 ws.addCell(l); l = new Label(1, 2, "电话", getTitle()); ws.addCell(l); l = new Label(2, 2, "地址", getTitle()); ws.addCell(l); l = new Label(0, 3, "小祝", getNormolCell());//第4行 ws.addCell(l); l = new Label(1, 3, "1314***0974", getNormolCell()); ws.addCell(l); l = new Label(2, 3, "武汉武昌", getNormolCell()); ws.addCell(l); l = new Label(0, 4, "小施", getNormolCell());//第5行 ws.addCell(l); l = new Label(1, 4, "1347***5057", getNormolCell()); ws.addCell(l); l = new Label(2, 4, "武汉武昌", getNormolCell()); ws.addCell(l); ws.setColumnView(0,20);//设置列宽 ws.setColumnView(1,20); ws.setColumnView(2,40); ws.setRowView(0,400);//设置行高 ws.setRowView(1,400); ws.setRowView(2,500); ws.setRowView(3,500); ws.setRowView(4,500); } catch (RowsExceededException e1) ...{ e1.printStackTrace(); } catch (WriteException e1) ...{ e1.printStackTrace(); } //输出流 try ...{ wwb.write(); } catch (IOException ex) ...{ // TODO 自动生成 catch 块 ex.printStackTrace(); } //关闭流 try ...{ wwb.close(); } catch (WriteException ex) ...{ // TODO 自动生成 catch 块 ex.printStackTrace(); } catch (IOException ex) ...{ // TODO 自动生成 catch 块 ex.printStackTrace(); } //outStream.close(); System.out.println("写入成功! "); } public void readExc(File filename) throws BiffException, IOException...{ Workbook wb = Workbook.getWorkbook(filename); Sheet s = wb.getSheet(0);//第1个sheet Cell c = null; int row = s.getRows();//总行数 int col = s.getColumns();//总列数 for(int i=0;i<row;i++)...{ for(int j=0;j<col;j++)...{ c = s.getCell(j,i); System.out.print(c.getContents()+" "); } System.out.println(); } } /** *//** * 设置头的样式 * @return */ public static WritableCellFormat getHeader()...{ WritableFont font = new WritableFont(WritableFont.TIMES, 24 ,WritableFont.BOLD);//定义字体 try ...{