<![CDATA[Heck's Blog]]>

<![CDATA[Heck's Blog]]> https://www.heckjj.com/index.php zh-cn https://www.heckjj.com/poi-export-excel-file/ <![CDATA[利用poi输出Excel文件]]> Heck <@hecks.tk> Fri, 10 Sep 2010 01:59:31 +0000 https://www.heckjj.com/poi-export-excel-file/ 利用poi输出Excel文件是java应用导出excel文件最常用的方法，下面我做了一个简单的应用例子，包括单个sheet的excel文件和多个sheet的excel文件生成。
1，首先第一步需要导入下载的java包，据我实际测试，需要加入如下几个jar包到类路径下即可：jxl.jar,jxls-core-0.9.1.jar,poi-2.5.1-final-20040804.jar, poi-contrib-2.5.1-final-20040804.jar, poi-scratchpad-2.5.1-final-20040804.jar, commons-logging-1.1.jar, commons-jexl-1.1.jar,如图所示：

2，做实体对象类: OdEntity
3，做模板文件export_template.xls,如图所示

4，实现代码:

import java.io.BufferedOutputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import axisoft.entity.OdEntity;
import net.sf.jxls.exception.ParsePropertyException;
import net.sf.jxls.transformer.XLSTransformer;

public class TestExport {

/**
   * @param args
   */
  public static void main(String[] args) {    
       //TestExport.multiSheet();
     TestExport.singleSheet();
  }
  /**
   * single-Sheet
   *
   */
  public static void singleSheet(){
    XLSTransformer transformer = new XLSTransformer();
    String xlsTemplateFileName = "export_template.xls";

String xlsFileName = "output.xls";
        Map<String, ArrayList<OdEntity>> beans = new HashMap<String, ArrayList<OdEntity>>();
       
        ArrayList<OdEntity> list = new ArrayList();
  
        OdEntity ent=new OdEntity();
        ent.setPmId("aaaaa");
        ent.setPmName("AAAAA");
        list.add(ent);
        OdEntity ent1=new OdEntity();
        ent1.setPmId("bbbbb");
        ent1.setPmName("BBBBB");
        list.add(ent1);
        beans.put("od",list);       
        try {
      transformer.transformXLS(xlsTemplateFileName , beans, xlsFileName);          
    } catch (ParsePropertyException e) {
      
      e.printStackTrace();
    } catch (IOException e) {      
      e.printStackTrace();
    }
  }
  /**
   * multi-Sheets
   *
   */
  public static void multiSheet(){
    XLSTransformer transformer = new XLSTransformer();
    String xlsTemplateFileName = "export_template.xls";

String xlsFileName = "output.xls";

ArrayList<ArrayList<OdEntity>> obj = new ArrayList();
        ArrayList<OdEntity> list = new ArrayList();
        OdEntity ent=new OdEntity();
        ent.setPmId("aaaaa");
        ent.setPmName("AAAAA");
        list.add(ent);
        OdEntity ent1=new OdEntity();
        ent1.setPmId("bbbbb");
        ent1.setPmName("BBBBB");
        list.add(ent1);

obj.add(list);

OdEntity ent2=new OdEntity();
        ArrayList<OdEntity> list1 = new ArrayList();
        ent2.setPmId("ccccc");
        ent2.setPmName("CCCCC");
        list1.add(ent2);
        OdEntity ent3=new OdEntity();
        ent3.setPmId("ddddd");
        ent3.setPmName("DDDDD");
        list1.add(ent3);
        obj.add(list1);
        ArrayList<String> nameList = new ArrayList();
        nameList.add("A-B");
        nameList.add("C-D");
        try {      
          InputStream xlsTemplateIO = new FileInputStream(xlsTemplateFileName);
          HSSFWorkbook wb=transformer.transformMultipleSheetsList(xlsTemplateIO, obj, nameList, "od", new HashMap(), 0);
          OutputStream os = new BufferedOutputStream(new FileOutputStream(xlsFileName));    
            wb.write(os);    
            os.flush();    
            os.close();  
    } catch (ParsePropertyException e) {
      
      e.printStackTrace();
    } catch (IOException e) {      
      e.printStackTrace();
    }
  }
}

Tags - poi输出excel文件 , 导出excel ]]> https://www.heckjj.com/poi-export-excel-file/#blogcomment <![CDATA[[评论] 利用poi输出Excel文件]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://www.heckjj.com/poi-export-excel-file/#blogcomment