JXLS根据模板导出Excel实例教程

package myjxls;

/**

  * 2014-3-17

  * 8dou

  * 实体

  */

public class staff {

   /**

   * 名称

   */

   private string name;

   /**

   * 薪资

   */

   private double payment;

   /**

   * 年终奖

   */

   private double bonus;

   public string getname() {

    return name;

   }

   public void setname(string name) {

    this .name = name;

   }

   public double getpayment() {

    return payment;

   }

   public void setpayment( double payment) {

    this .payment = payment;

   }

   public double getbonus() {

    return bonus;

   }

   public void setbonus( double bonus) {

    this .bonus = bonus;

   }

   public staff(string name, double payment, double bonus) {

   super ();

   this .name = name;

   this .payment = payment;

   this .bonus = bonus;

   }

}

package myjxls;

/**

  * 2014-3-17

  * 8dou

  * 测试jxls根据模板样式导出excel

  */

import java.util.arraylist;

import java.util.hashmap;

import java.util.list;

import java.util.map;

import net.sf.jxls.transformer.xlstransformer;

public class charttest {

  /**

   * @param args

   */

  public static void main(string[] args) throws exception {

   list<staff> staffs = new arraylist<staff>();

   staff s1 = new staff( "张三" , 6000d, 3000d);

   staffs.add(s1);

   staff s2 = new staff( "李四" , 5000d, 2000d);

   staffs.add(s2);

   staff s3 = new staff( "王五" , 4000d, 1000d);

   staffs.add(s3);

   string srcfilepath = "e:/simple.xlsx" ;

   string destfilepath = "e:/template-simple.xlsx" ;

   map<string, list<staff>> beanparams = new hashmap<string, list<staff>>();

   beanparams.put( "staffs" , staffs);

   xlstransformer former = new xlstransformer();

   former.transformxls(srcfilepath, beanparams, destfilepath);

   system.out.println( "the end !!!" );

  }

}

// 下载

public static void dodownload(string path, string name,

   httpservletresponse response) {

  try {

   response.reset();

   response.setheader( "content-disposition" ,

     "attachment;success=true;filename ="

       + urlencoder.encode(name, "utf-8" ));

   bufferedinputstream bis = null ;

   bufferedoutputstream bos = null ;

   outputstream fos = null ;

   inputstream fis = null ;

   file uploadfile = new file(path);

   fis = new fileinputstream(uploadfile);

   bis = new bufferedinputstream(fis);

   fos = response.getoutputstream();

   bos = new bufferedoutputstream(fos);

   // 弹出下载对话框

   int bytesread = 0 ;

   byte [] buffer = new byte [ 8192 ];

   while ((bytesread = bis.read(buffer, 0 , 8192 )) != - 1 ) {

    bos.write(buffer, 0 , bytesread);

   }

   bos.flush();

   fis.close();

   bis.close();

   fos.close();

   bos.close();

  } catch (exception e) {

   e.printstacktrace();

  }

}