jxl 新版电子表格_java jxl技术操作Excel表格文件

[java]代码库import java.io.File;

import jxl.Workbook;

import jxl.format.Border;

import jxl.format.BorderLineStyle;

import jxl.format.Colour;

import jxl.write.Label;

import jxl.write.WritableCellFormat;

import jxl.write.WritableFont;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

/**

*

* @author XHW

*

* @date 2012-2-29

*

*/

public class ExcelHandle {

/**

* @param args

*/

public static void main(String[] args) {

ExcelHandle excelHandle = new ExcelHandle();

excelHandle.writeExcel();

}

/**

* 写入Excel

*

*/

public void writeExcel() {

try {

// 写入到那个Excel文件 如：c:\\hello.xls,或者hello.xls(这个是在项目的根目录下)

WritableWorkbook wwb = Workbook

.createWorkbook(new File("hello.xls"));

// 创建Excel工作表 指定名称和位置

WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);

// 设置表格的列宽度

ws.setColumnView(0, 14);// 第一列宽14

ws.setColumnView(1, 12);

ws.setColumnView(2, 25);

ws.setColumnView(3, 20);

ws.setColumnView(4, 12);

ws.setColumnView(5, 9);

ws.setColumnView(6, 12);// 第7列宽12

// **************往工作表中添加数据*****************

// 定义字体格式：字体为：微软雅黑，24号子，加粗

WritableFont titleFont = new WritableFont(

WritableFont.createFont("微软雅黑"), 24, WritableFont.NO_BOLD);

WritableFont contentFont = new WritableFont(

WritableFont.createFont("楷体 _GB2312"), 12,

WritableFont.NO_BOLD);

WritableCellFormat titleFormat = new WritableCellFormat(titleFont);

WritableCellFormat contentFormat = new WritableCellFormat(

contentFont);

WritableCellFormat contentFormat2 = new WritableCellFormat(

contentFont);

contentFormat.setBorder(Border.ALL, BorderLineStyle.THIN,

Colour.BLACK);

// 设置格式居中对齐

titleFormat.setAlignment(jxl.format.Alignment.CENTRE);

contentFormat2.setAlignment(jxl.format.Alignment.CENTRE);

// ***************将定义好的单元格添加到工作表中*****************

ws.mergeCells(0, 0, 6, 0);// 合并单元格A-G共7列

ws.addCell(new Label(0, 0, "广州XXX大学2009级研究生课程考试成绩册", titleFormat));

ws.addCell(new Label(0, 1, "课程名称", contentFormat2));

ws.mergeCells(1, 1, 6, 1);// 合并单元格B-G共6列

ws.addCell(new Label(1, 1, "大学数学", contentFormat2));

ws.addCell(new Label(0, 2, "院所教研室", contentFormat2));

ws.mergeCells(1, 2, 6, 2);// 合并单元格B-G共6列

ws.addCell(new Label(0, 3, "填表人", contentFormat2));

ws.addCell(new Label(2, 3, "教研室负责人", contentFormat2));

String th[] = { "学号", "姓名", "学院", "平时成绩", "期末成绩", "总成绩", "补考成绩" };

for (int i = 0; i < 7; i++) {

ws.addCell(new Label(i, 4, th[i], contentFormat2));

}

// 这里我们可以从数据库里面查询数据，然后在这里获取数据

int xh = 200901;

String xm = "王佳佳";

String xy = "XXX信息技术学院";

String space = " ";

int cj = 50;

String bk = "补 80";

// 向Excel中插入数据

for (int j = 5; j < 10; j++) {

ws.addCell(new Label(0, j, "" + xh + j + "", contentFormat));

ws.addCell(new Label(1, j, xm + j, contentFormat));

ws.addCell(new Label(2, j, xy, contentFormat));

ws.addCell(new Label(3, j, space, contentFormat));

ws.addCell(new Label(4, j, space, contentFormat));

ws.addCell(new Label(5, j, "" + cj + j + "", contentFormat));

ws.addCell(new Label(6, j, "" + bk + "", contentFormat));

}

// 写入工作表完毕，关闭流

wwb.write();

wwb.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}