java jxl 创建excel_jxl创建Excel文件java代码示例

package Test;

import java.io.*;

import jxl.*;

import jxl.format.Colour;

import jxl.write.*;

public class JXLTest {

private static WritableWorkbook book;

private static WritableSheet sheet ;

private static WritableFont normalFont;

private static WritableFont diffFont;

private static WritableCellFormat normalFormat;

private static WritableCellFormat diffFormat;

/**

* java创建excel简单示例

*/

public static void main(String args[]) {

createExcel();

}

public static void createExcel(){

try {

String fileNameAndPath = "E:\\DifferentData\\java创建excel文件示例.xls";

book = Workbook.createWorkbook(new File(fileNameAndPath));

// 生成名为"第一页"的工作表，参数0表示这是第一页

sheet = book.createSheet("第一页", 0);

// 设置字体为宋体,11号字,不加粗,颜色为红色

normalFont = new WritableFont(WritableFont.createFont("宋体"), 11, WritableFont.NO_BOLD);

// 设置字体为宋体,11号字,不加粗,颜色为红色

diffFont = new WritableFont(WritableFont.createFont("宋体"), 11, WritableFont.NO_BOLD);

diffFont.setColour(Colour.RED);

normalFormat = new WritableCellFormat(normalFont);

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

normalFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);

diffFormat = new WritableCellFormat(diffFont);

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

diffFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);

Label labelA = new Label(0, 0, "第一列标题", normalFormat);

Label labelB = new Label(1, 0, "第二列标题", normalFormat);

Label labelC = new Label(2, 0, "第三列标题", normalFormat);

Label labelD = new Label(3, 0, "第四列标题", normalFormat);

for(int i=1; i<=10; i++){

Label lab1 = new Label(0,i,"第"+i+"行第1列");

Label lab2 = new Label(2,i,"第"+i+"行第2列");

Label lab3 = new Label(3,i,"第"+i+"行第3列",diffFormat);

Label lab4 = new Label(4,i,"第"+i+"行第4列");

sheet.addCell(lab1);

sheet.addCell(lab2);

sheet.addCell(lab3);

sheet.addCell(lab4);

}

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

sheet.addCell(labelA);

sheet.addCell(labelB);

sheet.addCell(labelC);

sheet.addCell(labelD);

book.write();

book.close();

System.out.println("创建文件成功!");

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

}

}

}

原文：http://blog.csdn.net/dwj901125/article/details/36177335