用jexcel读写excel的.xls文件的例子

来源：互联网发布：mac更新软件发生错误编辑：程序博客网时间：2024/05/16 02:43

有时候我们会需要做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.
*
* WuHan Inpoint Information Technology Development,Inc.
*
* Author zhu
*
* @version 1.0 2007-2-6
*
* Base on : JDK1.5
*
*/

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("写入成功！/n");
}

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 {
 font.setColour(Colour.BLUE);//蓝色字体
 } catch (WriteException e1) {
 // TODO 自动生成 catch 块
 e1.printStackTrace();
 }
 WritableCellFormat format = new WritableCellFormat(font);
 try {
 format.setAlignment(jxl.format.Alignment.CENTRE);//左右居中
 format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//上下居中
 format.setBorder(Border.ALL,BorderLineStyle.THIN,Colour.BLACK);//黑色边框
 format.setBackground(Colour.YELLOW);//黄色背景
 } catch (WriteException e) {
 // TODO 自动生成 catch 块
 e.printStackTrace();
 }
 return format;
}

/**
* 设置标题样式
* @return
*/
public static WritableCellFormat getTitle(){
 WritableFont font = new WritableFont(WritableFont.TIMES, 14);
 try {
 font.setColour(Colour.BLUE);//蓝色字体
 } catch (WriteException e1) {
 // TODO 自动生成 catch 块
 e1.printStackTrace();
 }
 WritableCellFormat format = new WritableCellFormat(font);

 try {
 format.setAlignment(jxl.format.Alignment.CENTRE);
 format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
 format.setBorder(Border.ALL,BorderLineStyle.THIN,Colour.BLACK);
 } catch (WriteException e) {
 // TODO 自动生成 catch 块
 e.printStackTrace();
 }
 return format;
}

/**
* 设置其他单元格样式
* @return
*/
public static WritableCellFormat getNormolCell(){//12号字体,上下左右居中,带黑色边框
 WritableFont font = new WritableFont(WritableFont.TIMES, 12);
 WritableCellFormat format = new WritableCellFormat(font);
 try {
 format.setAlignment(jxl.format.Alignment.CENTRE);
 format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
 format.setBorder(Border.ALL,BorderLineStyle.THIN,Colour.BLACK);
 } catch (WriteException e) {
 // TODO 自动生成 catch 块
 e.printStackTrace();
 }
 return format;
}

public static void main(String[] args) throws IOException, BiffException{
 JexcelSample js = new JexcelSample();
 File f = new File("D://address.xls");
 f.createNewFile();
 js.writeExc(f);
 js.readExc(f);
}

}

生成的excel表格如下：

作者：小祝

出处：http://www.blogjava.net/ilovezmh/archive/2007/02/06/98270.html