学步园

package com.db;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import java.io.File;

/**
 * Created by IntelliJ IDEA.
 * User: haoshihai
 * Date: 12-9-19
 * Time: 上午9:57
 * To change this template use File | Settings | File Templates.
 */
public class JxlExcel {
    WritableWorkbook wwb = null;

    //对写入content.split(,)
    public void writeExcel(WritableSheet ws, String content, int rowNum) {
        try {
            if (wwb != null && ws != null) {
                putRow(ws, rowNum, content.split(","));
            }
        } catch (Exception e) {
            System.out.println(e.toString());
        }
    }

    //一次向sheet写入一行数据
    private void putRow(WritableSheet ws, int rowNum, Object[] cells) throws RowsExceededException, WriteException {
        for (int j = 0; j < cells.length; j++) {//写一行
            Label cell = new Label(j, rowNum, "" + cells[j]);
            ws.addCell(cell);
        }
    }

    public void startWrite() throws Exception {
        wwb = Workbook.createWorkbook(new File("E:\\test.xls"));
        String title = "ID,userName,pwssword,sex";
        WritableSheet ws = wwb.createSheet("tb_user", 0);
        writeExcel(ws, title, 0);
        wwb.write();
        wwb.close();
    }

    public static void main(String args[]) throws Exception {
        new JxlExcel().startWrite();
    }
}

这里提醒一下

在excel 中 cell 中的类容默认是文本格式（不能够进行计算）,如果需要转换位数字可以这样写。

    jxl.write.Number number = new Number(j, rowNum, Double.valueOf(cells[j].toString()));    
    ws.addCell(number);