package test;
import java.io.File;
import java.io.IOException;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class FormatExcelHeader {
public static void main(String[] args) {
try {
//打开文件
WritableWorkbook book = Workbook.createWorkbook(new File("E://test.xls"));
//创建名称为Sheet1的第一张Excel表
WritableSheet sheet = book.createSheet("sheet1", 0);
//设置字体大小类型为TIMES,大小为20,并且为粗体
jxl.write.WritableFont wfc = new jxl.write.WritableFont(jxl.write.WritableFont.TIMES,20,jxl.write.WritableFont.BOLD);
//设置单元格内的字体为斜体
wfc.setItalic(true);
//获得格式化单元格对象
WritableCellFormat format = new WritableCellFormat(wfc);
//格式化单元格背景色为红色
format.setBackground(jxl.format.Colour.RED);
Label label = new Label(0,0,"我是Dean!",format);
//合并单元格第一列第一行至第一列第三行
sheet.mergeCells(0, 0, 0,2);
//设置列宽,要根据字符大小和字串长度结合看
sheet.setColumnView(0, "我是Dean!".length()-1+20);
//sheet.setRowView(0, 5);,不知道为什么这个方法并不好使
//添加字串单元格到表中
sheet.addCell(label);
//写出数据,并关闭相关文件流
book.write();
book.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}