package qs.com;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Java2ExcelAction2 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String path = "c:\\JAVA2EXCELDEMO.xls";
try {
WritableWorkbook wbook = Workbook.createWorkbook(new File(path));// 创建一个名字为JAVA2EXCELDEMO.xls的EXCEl文件，同样是全部修改
WritableSheet wSheet = wbook.createSheet("第一页", 0);// 单页的名字
WritableSheet wSheet2 = wbook.createSheet("第二页", 1);
//
wSheet.mergeCells(0, 0, 8, 0);// 单元格合并 （0,0）合并（8,0）
WritableFont wFont = new WritableFont(WritableFont.ARIAL, 10);//table样式
WritableCellFormat wCellFormat = new WritableCellFormat(wFont);//tableCell样式
wCellFormat.setAlignment(jxl.format.Alignment.CENTRE);//水平方向居中
wCellFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//竖直方向居中
wCellFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);//边框设置
wCellFormat.setWrap(true);//自动换行
//
wSheet.addCell(new Label(1, 1, "B2", wCellFormat));//往某个单元格加字符串
wSheet.addCell(new Label(9, 2, "j3", wCellFormat));
wbook.write();//写入 www.2cto.com
wbook.close();//关闭，必须的
} catch (Exception e) {//createWorkbook时会出异常，抛出
// TODO: handle exception
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}