记得要下载 并 导入 jxl.jar 包，免积分下载地址：http://download.csdn.net/detail/u010011052/7561041
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{
}
}
}