向Excel中写入内容

package com.preader.shareinfo.util.file;

import java.io.File;
import java.net.URL;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableHyperlink;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import java.util.Iterator;
import java.util.List;
import com.preader.shareinfo.model.TextMiningJianli;

public class ExportExcelFile {

public void exportExl(String ecportpath,List list) throws Exception {

   try {

   WritableWorkbook wbook = Workbook.createWorkbook(new File(ecportpath)); //建立excel文件

   WritableSheet wsheet = wbook.createSheet("简历信息表", 0); //工作表名称

   //设置Excel字体

   WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,

   WritableFont.BOLD, false,

   jxl.format.UnderlineStyle.NO_UNDERLINE,

   jxl.format.Colour.BLACK);

   WritableCellFormat titleFormat = new WritableCellFormat(wfont);

   String[] title = { "姓名", "性别", "籍贯", "民族","出生年月","电话","EMAIL","身份证","学历","类型","路径" };

   //设置Excel表头

   for (int i = 0; i < title.length; i++) {

   Label excelTitle = new Label(i, 0, title[i], titleFormat);

   wsheet.addCell(excelTitle);

   }

   int c = 1; //用于循环时Excel的行号


   Iterator it = list.iterator();

   while (it.hasNext()) {

   TextMiningJianli crdto = (TextMiningJianli) it.next();

   Label content1 = new Label(0, c, crdto.getName());
   Label content2 = new Label(1, c, crdto.getSex());
   Label content3 = new Label(2, c, crdto.getHousehold());//籍贯
   Label content4 = new Label(3, c, crdto.getNationals());//民族
   //
   Label content5 = new Label(4, c, crdto.getDatetime());
   Label content6 = new Label(5, c, crdto.getPhone());
   Label content7 = new Label(6, c, crdto.getEmail());
   Label content8 = new Label(7, c, crdto.getCredentials());//身份证
   Label content11 = new Label(8, c, crdto.getXueli()); //学历
   //超链接路径
  
  //URL   url   =   new   URL("file:///简历档案集/Jack邓杰强-北京-天和建城装饰工程公司-工程部总监.doc");
// WritableHyperlink wrlink = new WritableHyperlink(10,c,url);
  //URL   url   =   new   URL("简历档案集/Jack邓杰强-北京-天和建城装饰工程公司-工程部总监.doc"); 
  WritableHyperlink wrlink = new WritableHyperlink(10,c,new URL("file:///"+crdto.getFilepath()));
  wrlink.setDescription(crdto.getFilepath().substring(2, crdto.getFilepath().length()));
 
// wrlink.setFile(new File("C:\\简历挖掘分析演示\\简历档案集\\简历二级目录\\1.doc"));
  // Label content9 = new Label(8, c, crdto.getFilepath());//附件路径
   Label content10 = new Label(9, c, crdto.getFiletype());//简历类型
  
  
   wsheet.addCell(content1);

   wsheet.addCell(content2);

   wsheet.addCell(content3);

   wsheet.addCell(content4);
   wsheet.addCell(content5);

   wsheet.addCell(content6);

   wsheet.addCell(content7);
 
   wsheet.addCell(content8);
   //wsheet.addCell(content9);

   wsheet.addCell(content11);
   wsheet.addHyperlink(wrlink);//路径
   wsheet.addCell(content10);//类型
  
   c++;

   }

   wbook.write(); //写入文件

   wbook.close();



   } catch (Exception e) {
   e.printStackTrace();
   e.getMessage();
   e.getCause();

   throw new Exception("导出文件出错");

   }

}

/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根

}

}