FLY的狐狸

import java.io.FileOutputStream;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.CellFormat;
import jxl.write.Label;
import jxl.write.WritableCellFeatures;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class JXLExample {

 
 public static void main(String[] args) {
  // 准备设置excel工作表的标题
  String[] title = { "编号", "产品名称", "产品价格", "产品数量", "生产日期", "产地", "是否出口" };
  try {
   // 获得开始时间
   long start = System.currentTimeMillis();
   // 输出的excel的路径
   String filePath = "c:\\test.xls";
   // 创建Excel工作薄
   WritableWorkbook wwb;
   // 新建立一个jxl文件,即在C盘下生成test.xls
   OutputStream os = new FileOutputStream(filePath);
   wwb = Workbook.createWorkbook(os);
   // 添加第一个工作表并设置第一个Sheet的名字
   WritableSheet sheet = wwb.createSheet("产品清单", 0);
   Label label;
   for (int i = 0; i < title.length; i++) {
    label = new Label(i, 0, title[i]);
    // 将定义好的单元格添加到工作表中
    sheet.addCell(label);
   }
   // WritableSheet.setRowView(int i,int height); 指定第i+1行的高度
   // WritableSheet.setColumnView(int i,int width); 指定第i+1列的宽度
   
   // 填充产品编号
   jxl.write.Number number = new jxl.write.Number(0, 1, 20071001);
   sheet.addCell(number);
   // 填充产品名称
   label = new Label(1, 1, "金鸽瓜子");
   sheet.addCell(label);
   
   jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
   jxl.write.WritableCellFormat wcf = new jxl.write.WritableCellFormat(
     nf);
   // 填充产品价格
   jxl.write.Number nb = new jxl.write.Number(2, 1, 2.45, wcf);
   sheet.addCell(nb);
   // 填充产品数量
   jxl.write.Number numb = new jxl.write.Number(3, 1, 200);
   sheet.addCell(numb);
   
   SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
   String newdate = sdf.format(new Date());
   // 填充出产日期
   label = new Label(4, 1, newdate);
   sheet.addCell(label);
   // 填充产地
   label = new Label(5, 1, "陕西西安");
   sheet.addCell(label);
   
   jxl.write.Boolean bool = new jxl.write.Boolean(6, 1, true);
   sheet.addCell(bool);
   
   sheet.mergeCells(0, 3, 2, 3);
   label = new Label(0, 3, "合并了三个单元格");
   sheet.addCell(label);
   
   CellFormat cf = wwb.getSheet(0).getCell(1, 0).getCellFormat();
   WritableCellFormat wc = new WritableCellFormat();
   // 设置居中
   wc.setAlignment(Alignment.CENTRE);
   // 设置边框线
   wc.setBorder(Border.ALL, BorderLineStyle.THIN);
   // 设置单元格的背景颜色
   wc.setBackground(jxl.format.Colour.RED);
   label = new Label(1, 5, "字体", wc);
   sheet.addCell(label);
   // 设置字体
   WritableFont wfont = new WritableFont(
   WritableFont.createFont("隶书"), 20);
   WritableCellFormat font = new WritableCellFormat(wfont);
   label = new Label(2, 6, "隶书", font);
   sheet.addCell(label);
   
   label = new Label(0, 4, "");
   WritableCellFeatures wcf1 = new WritableCellFeatures();
   List<String> angerlist = new ArrayList<String>();
   angerlist.add("电话");
   angerlist.add("手机");
   angerlist.add("呼机");
   wcf1.setDataValidationList(angerlist);
   label.setCellFeatures(wcf1);
   sheet.addCell(label); 
   
   for (int i = 8; i < 500; i++) {
    WritableCellFeatures wcf2 = new WritableCellFeatures();
    wcf2.setDataValidationList(angerlist);
    label = new Label(0, i, "");
    label.setCellFeatures(wcf2);
    sheet.addCell(label);
   }

   // 写入数据
   wwb.write();
   // 关闭文件
   wwb.close();
   long end = System.currentTimeMillis();
   System.out.println("----完成该操作共用的时间是:" + (end - start)+"ms");
  } catch (Exception e) {
   System.out.println("---出现异常---");
   e.printStackTrace();
  }
 }

}