2024年5月11日发(作者：)

jxls2标签中求和标签

package es;

import ;

import Out put Stream;

import put Stream;

import put Stream;

import Decimal;

import List;

import ar;

import ;

import Map;

import ;

import ;

import t;

import Helper;

import ee;

/**

*简单列表导出--带统计汇总

*循环List<Bean>与List<Map>结构的集合

*@author chendd

*/

public class Simple Each Sum Jxls public static void

main(String[]args)throws Exception{

//构造集合数据

Listemployees=new ArrayList();

Calendar time=tance();

(2015,5,20);

Date date=e();

//------设置数据源一

(new Employee("lishengle",date,new

BigDecimal(15000),new BigDecimal(800)));

(new Employee("jiajitao",date,new Big

Decimal(16000),new Big Decimal(1000)));

(new Employee("sunming",date,new Big

Decimal(17000),new Big Decimal(1500)));

//------设置数据源二

List>dataList=new Array

List>();

Mapmap1=new Hash Map();

("prop1","曹孟德");("prop2","男

");("prop3",1800);("prop4",180);

Mapmap2=new Hash Map();

("prop1","吴国太");("prop2","女

");("prop3",2800);("prop4",280);

Mapmap3=new Hash Map();

("prop1","大嘴");("prop2","男

");("prop3",3800);("prop4",380);

Data (map1);

Data (map2);

Data (map3);

//载入模板

InputStream

is=ss().getResourceAsStream("

/cn/chendd/examples/templates/");

Context context=new Context();

("employees",employees);

("title","员工信息列表");

("dataList",dataList);

OutputStream os=new FileOutputStream(new

File("d:testout_"));

//指定Sheet文件解析

tance().processTemplate(is,os,context)

;

();

();

();

}

}

public class Employee{

private String name;

private Date birthDate;

private BigDecimal payment;

private BigDecimal bonus;

public Employee(){

super();

}

public Employee(String name,Date birthDate,BigDecimal

payment,

BigDecimal bonus){

super();

=name;

ate=birthDate;

t=payment;

=bonus;

}

//省略getter/setter

}