透过 jxl 将数据导出为excel模板

通过 jxl 将数据导出为excel模板
import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;

import jxl.Cell;
import jxl.CellFormat;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class ExcelUtils {

    public static void writeExcel(String fileName,String[] header,List<List> rows)throws Exception{   
        WritableWorkbook wwb = null;   
        try {   
            //首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象   
            wwb = Workbook.createWorkbook(new File(fileName));   
        } catch (IOException e) {   
            e.printStackTrace();   
        }   
        if(wwb!=null){   
            //创建一个可写入的工作表   
            //Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置   
            WritableSheet ws = wwb.createSheet("sheet1", 0);   
            //写表头
            for(int j=0;j<header.length;j++){
            Label lb = new Label(j,0,header[j]);
ws.addCell(lb);
            }
           //添加行数据
            for(int k=1;k<rows.size()+1;k++){
            List row = rows.get(k-1);
            for(int m=0;m<row.size();m++){
            Label lb2 = new Label(m,k,row.get(m).toString());
            ws.addCell(lb2);
            }
            }
            try {   
                //从内存中写入文件中   
                wwb.write();   
                //关闭资源，释放内存   
                wwb.close();   
            } catch (IOException e) {   
                e.printStackTrace();   
            }
        }   
    }

    public static void daoExcel(OutputStream out,String[] header,List<List> rows)throws Exception{   
        WritableWorkbook wwb = null;   
        try {   
            //首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象   
            wwb = Workbook.createWorkbook(out);   
        } catch (IOException e) {   
            e.printStackTrace();   
        }   
        if(wwb!=null){   
            //创建一个可写入的工作表   
            //Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置   
            WritableSheet ws = wwb.createSheet("sheet1", 0);   
            ws.setColumnView(0, 31); // 设置列的宽度
            ws.setColumnView(1, 21); // 设置列的宽度
            ws.setColumnView(2, 9); // 设置列的宽度
            ws.setColumnView(3, 18);
            ws.setColumnView(4, 12);
            ws.setColumnView(5,15);
           
            //写表头
            for(int j=0;j<header.length;j++){
            Label lb = new Label(j,0,header[j]);
ws.addCell(lb);
            }
           //添加行数据
            for(int k=1;k<rows.size()+1;k++){
            List row = rows.get(k-1);
            // System.err.println(" ExcelUtils.daoExcel 90: "+row);
            for(int m=0;m<row.size();m++){
           
            Label lb2 = new Label(m,k,row.get(m)==null?"":row.get(m).toString());
            ws.addCell(lb2);
            }
            }
            try {   
                //从内存中写入文件中   
                wwb.write();   
                //关闭资源，释放内存   
                wwb.close();   
            } catch (IOException e) {   
                e.printStackTrace();   
            }
        }   
    } 
   
    /**
     * 读取EXCEL
     * @param filepath
     * @return
     * @throws Exception
     */
    @SuppressWarnings("unchecked")
    public static List<List> readExcel(String filepath)throws Exception{
    List<List> rows = new ArrayList<List>();
        Workbook workbook = Workbook.getWorkbook(new File(filepath));  
        Sheet sheet = workbook.getSheet(0);  
        Integer erows=sheet.getRows();//行  
        Integer cols=sheet.getColumns();//列  
        for(int i=1;i<erows;i++){
        List row = new ArrayList<String>();
            for(int j=0;j<cols;j++){
                Cell c1 = sheet.getCell(j,i);  
                 row.add(c1.getContents());
            }
            rows.add(row);
        }  
        workbook.close();
        return rows;
    }
   

}