JXLS模板设置-分组求和折叠合并.pdf

JXLS 模板设置-分组求和折叠合并 燕飞出品 效果图： 效果图： JXLS 模板设置-分组求和折叠合并 燕飞出品 效果图： 效果图： JXLS 模板设置-分组求和折叠合并 燕飞出品 效果图： JXLS 模板设置-分组求和折叠合并 燕飞出品 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); JXLS 模板设置-分组求和折叠合并 燕飞出品 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, 同于); d