JXLS模板设置-分组求和折叠合并
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
效果图：
效果图：
效果图：
效果图：
效果图：
Excel的VBA宏:
Sub MyMerge()
Dim I%
Application.DisplayAlerts = False
For I = [A65536].End(3).Row To 3 Step -1
If Cells(I, 1) = Cells(I - 1, 1) Then
Range("A" & I & ":A" & I - 1).Merge
Range("A" & I & ":A" & I - 1).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter
Range("A" & I & ":A" & I - 1).VerticalAlignment = Excel.XlVAlign.xlVAlignCenter
End If
Next
Application.DisplayAlerts = True
End Sub
数据填充：
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import net.sf.jxls.exception.ParsePropertyException;
import net.sf.jxls.transformer.XLSTransformer;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
public class JxlsGroup
{
public static void main(String args[]) throws ParsePropertyException, InvalidFormatException, IOException {
List department = new ArrayList();
HashMap employee;
employee = new HashMap();
employee.put("age", "01组");
employee.put("name", "张三");
employee.put("payment", 1111);
employee.put("bonus", "通用"); department.add(employee);
employee = new HashMap(); employee.put("age", "01组"); employee.put("name", "李四"); employee.put("payment", 222); employee.put("bonus", "同于"); department.add(employee);
employee = new HashMap(); employee.put("age", "02组"); employee.put("name", "张三"); employee.put("payment", 1111); employee.put("bonus", "通用"); department.add(employee);
employee = new HashMap(); employee.put("age", "02组"); employee.put("name", "李四"); employee.put("payment", 222); employee.put("bonus", "同于"); department.add(employee);
employee = new HashMap(); employee.put("age", "02组"); employee.put("name", "王五"); employee.put("payment", 1111); employee.put("bonus", "通用"); department.add(employee);
employee = new HashMap(); employee.put("age", "02组"); employee.put("name", "马六"); employee.put("payment", 222); employee.put("bonus", "同于"); department.add(employee);
employee = new HashMap(); employee.put("age", "03组"); employee.put("name", "张三"); employee.put("payment", 1111); employee.put("bonus", "通用"); department.add(employee);
employee = new HashMap();
employee.put("age", "04组");
employee.put("name", "张三");
employee.put("payment", 1111);
employee.put("bonus", "通用");
department.add(employee);
employee = new HashMap();
employee.put("age", "04组");
employee.put("name", "李四");
employee.put("payment", 222);
employee.put("bonus", "同于");
department.add(employee);
employee = new HashMap();
employee.put("age", "04组");
employee.put("name", "王五");
employee.put("payment", 1111);
employee.put("bonus", "通用");
department.add(employee);
employee = new HashMap();
employee.put("age", "04组");
employee.put("name", "马六");
employee.put("payment", 222);
employee.put("bonus", "同于");
department.add(employee);
employee = new HashMap();
employee.put("age", "04组");
employee.put("name", "赵启");
employee.put("payment", 222);
employee.put("bonus", "同于");
department.add(employee);
Map beans = new HashMap();
beans.put("employees", department);
String destFileName = "C:/C/待退人员花名册1.xls";
String templateFileName = ""; templateFileName = "C:/C/00分组求和折叠.xls"; templateFileName = "C:/C/01分组求和.xls";
templateFileName = "C:/C/02分组求和.xls";
templateFileName = "C:/C/11分组求和.xls";
templateFileName = "C:/C/12分组求和合并.xls";
XLSTransformer transformer = new XLSTransformer();
transformer.transformXLS(templateFileName, beans, destFileName);
}
}。