创建可写入的Excel工作薄

 

package com.pdsu.edu.utils;

import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.Iterator;
import java.util.List;

import com.pdsu.edu.domain.User;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

/**
 *
 * @author zhanglong
 *
 */
public class ExcelUtil {
      public  static void createEXCEL(String[] title,List<User> u,String path) throws Exception{
          
          
          //：创建可写入的Excel工作薄
             WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream(path));
             WritableSheet ws = wwb.createSheet("sheet1", 0);
             int i=0;
             int j=0;

             for(i=0;i<title.length;i++){
                   WritableFont wf = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD, false);
                   WritableCellFormat wcfF = new WritableCellFormat(wf);
                   Label labelCF = new Label(i, 0, title[i],wcfF);
                   ws.addCell(labelCF);
                  }
             i=1;
             for (User user : u) {
                  for(j=1;j<=title.length;j++)
                  {
                   Label labelC = new Label(j-1,i, user.getUsername());
                   ws.addCell(labelC);
               }
                  i++;   
            }
             
                wwb.write();
                wwb.close();
            
             
      }
      
      
      public static void createUserEXCEL(String path,List<User> uList)  {

          try {
          WritableWorkbook wbook = Workbook.createWorkbook(new FileOutputStream(path)); //建立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 = { "编号", "用户名", "密码"};
          //设置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 = uList.iterator();
          while (it.hasNext()) {
          User crdto = (User) it.next();
          Label content1 = new Label(0, c, crdto.getId().toString());
          Label content2 = new Label(1, c, crdto.getUsername() .toString());
          Label content3 = new Label(2, c, crdto.getPassword()
          .toString());
    
          wsheet.addCell(content1);
          wsheet.addCell(content2);
          wsheet.addCell(content3);
    
          c++;
          }

          wbook.write(); //写入文件
          wbook.close();
         // os.close();
          } catch (Exception e) {

              System.out.println(e);

          }

          }  

}