zk實現匯出Excel報表

標籤：

package com.bailin.framework.util.excel;

import java.util.ArrayList;

import java.util.List;

/**  * 行  *  * @author cj  *  */ public class Row {

 private List<Column> columnList = new ArrayList<Column>();  private String columnName;

 public List<Column> getColumnList() {   return columnList;  }

 public void setColumnList(List<Column> columnList) {   this.columnList = columnList;  }

 public void appendColumn(Column column) {   columnList.add(column);  }

 public String getColumnName() {   return columnName;  }

 public void setColumnName(String columnName) {   this.columnName = columnName;  }

}

 

package com.bailin.framework.util.excel;

/**  * 列  * @author cj  *  */

public class Column {

 private int columnNum;  

private String columnLabel;

 public int getColumnNum() {

  return columnNum;  }

 public void setColumnNum(int columnNum) {   this.columnNum = columnNum;  }

 public String getColumnLabel() {   return columnLabel;  }

 public void setColumnLabel(String columnLabel) {   this.columnLabel = columnLabel;  }

}

package com.bailin.framework.util.excel;

import java.util.ArrayList; import java.util.List;

/**  * 頁  * @author cj  *  */

public class Sheet {  

  public Sheet(){

　　}  

 public Sheet(List<Row> listRow,String name){

   this.rowList = listRow;    this.name = name;

  }   private List<Row> rowList = new ArrayList<Row>();      

   private String name;         

   public List<Row> getRowList() {      

     return rowList;       }        

  public void setRowList(List<Row> rowList) { 

         this.rowList = rowList;       }       

   public String getName() {          

return name;       }       

   public void setName(String name) {    

       this.name = name;       }       

       public void appendRow(Row row){          

rowList.add(row);       } 

}

package com.bailin.framework.util.excel;

import java.io.File; import java.util.ArrayList; import java.util.List;

import javax.swing.JFileChooser;

import org.zkoss.zul.Listbox; import org.zkoss.zul.Listhead; import org.zkoss.zul.Listheader;

/**  * 添加頭部  *  * @author cj  *  */ public class ExportExcel {  /**   * 設定頭部   * @param listbox 頁面listBox   * @return 一行   */  public static Row addpendtitle(Listbox listbox) {   Row row = new Row(); //行   List<Column> columnlist = new ArrayList<Column>();//儲存所有列   Listhead s = listbox.getListhead(); //擷取頭部   List<Listheader> j = s.getChildren();//擷取到頭部子節點   for (int i = 0; i < j.size(); i++) { //遍曆列    Column column = new Column(); //列    column.setColumnLabel(j.get(i).getLabel());    column.setColumnNum(i);    columnlist.add(column);// 添加到列   }   row.setColumnList(columnlist);   row.setColumnName("表頭");   return row;  }

 /**   * 彈出選擇檔案儲存位置   * @return 檔案儲存位置   */  public static String filename(){   String fileName = "d://匯出Excel"; //  JFileChooser dialog = new JFileChooser(); //  dialog.setCurrentDirectory(new File("e://"));//設定預設開啟路徑 //  dialog.setDialogTitle("將報表存放於");  //  dialog.setFileSelectionMode(JFileChooser.FILES_ONLY); //  dialog.setDialogType(JFileChooser.SAVE_DIALOG); //  int result = dialog.showSaveDialog(dialog); //  if(result == JFileChooser.APPROVE_OPTION){ //   File file = dialog.getSelectedFile(); //   fileName = file.getAbsolutePath(); //得到檔案全名  //  }   return fileName;  } }

package com.bailin.framework.util.excel;

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

import org.zkoss.zul.Filedownload;

import jxl.Workbook; import jxl.format.UnderlineStyle; import jxl.write.WritableFont; /**  * 輸出excel格式  * @author cj  *  */ public class Excel {  public static boolean write(List<Sheet>sheetList,String fileName,int width){    jxl.write.WritableWorkbook wwb;          jxl.write.WritableCellFormat wff1=new jxl.write.WritableCellFormat();         try {           FileOutputStream os = new FileOutputStream(fileName+".xls"); //檔案輸出位置          wff1.setAlignment(jxl.format.Alignment.CENTRE); //設定儲存格劇中             wwb = Workbook.createWorkbook(os);              int i = 0;              for(Iterator<Sheet>itr = sheetList.iterator();itr.hasNext();){                  Sheet sheet = itr.next();                  int rowNum =0;                  jxl.write.WritableSheet ws = wwb.createSheet(sheet.getName(),i);                 for(Iterator<Row>sheetItr = sheet.getRowList().iterator();sheetItr.hasNext();){                      Row row = sheetItr.next();                      int colunNum = 0;                      for(Iterator<Column>rowIterator=row.getColumnList().iterator();rowIterator.hasNext();){                       ws.setColumnView(colunNum, width);// 設定第列寬                         Column column = rowIterator.next();                         if(null != row.getColumnName() && row.getColumnName().equals("表頭")){                          jxl.write.WritableFont wf2=new jxl.write.WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,                                      UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK); // 設定字型樣式                           jxl.write.WritableCellFormat wf1=new jxl.write.WritableCellFormat(wf2);                          wf1.setAlignment(jxl.format.Alignment.CENTRE); //設定儲存格劇中                          ws.addCell(new jxl.write.Label(colunNum,rowNum,column.getColumnLabel(),wf1));                          }else{                          ws.addCell(new jxl.write.Label(colunNum,rowNum,column.getColumnLabel(),wff1));                          }                          colunNum++;                      }                      rowNum++;                  }                  i++;              }              try {     wwb.write();      wwb.close();     os.close();     File file = new File(fileName+".xls");      Filedownload.save(file, "application/vnd.ms-excel");     return true;    } catch (Exception e) {     e.printStackTrace();     return false;    }          } catch (Exception e) {             e.printStackTrace();              return false;         }      } 

}

package com.bailin.framework.util.excel;

import java.io.File; import java.util.ArrayList;

import javax.swing.filechooser.FileFilter; /**  * 過濾檔案  * @author cj  *  */ public class TextFileFilter extends FileFilter {  private ArrayList<String> extensions = new ArrayList<String>();  private ArrayList<String> descriptions = new ArrayList<String>();    public TextFileFilter(){   super();  }    public TextFileFilter(String extension, String description) {   super();   this.extensions.add(extension);   this.descriptions.add(description);  }    @Override  public boolean accept(File pathname) {   if (pathname != null) {    if (pathname.isDirectory()) {     return true;    }    String extension = getExtension(pathname);    for(int i=0; i<extensions.size(); i++){     if(extensions.get(i).toLowerCase().endsWith(extension.toLowerCase())){      return true;     }    }   }   return false;  }

 private String getExtension(File pathname) {   if (pathname != null) {    String filename = pathname.getName();    int i = filename.lastIndexOf(‘.‘);    if (i > 0 && i < filename.length() - 1) {     return filename.substring(i).toLowerCase();    }   }   return null;  }

 @Override  public String getDescription() {   return descriptions.get(descriptions.size()-1);  } }

zk實現匯出Excel報表