package com.ppcxy.jxls;


import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.jxls.area.Area;
import org.jxls.builder.AreaBuilder;
import org.jxls.builder.xls.XlsCommentAreaBuilder;
import org.jxls.common.CellRef;
import org.jxls.common.Context;
import org.jxls.transform.Transformer;
import org.jxls.util.TransformerFactory;

import java.io.*;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Created by weep on 2017-6-13.
 */
public class Test {

    public static void execute(FileOutputStream outputStream) throws IOException, InvalidFormatException, ParseException, SQLException {
        String template = "/xlstemplate/object_collection_template.xls";
        InputStream is = Test.class.getResourceAsStream(template);
        OutputStream os = outputStream;
        Transformer transformer = TransformerFactory.createTransformer(is, os);
        AreaBuilder areaBuilder = new XlsCommentAreaBuilder(transformer);
        List<Area> xlsAreaList = areaBuilder.build();

        Area xlsArea = xlsAreaList.get(0);
        Context context = new Context();

        Map<String, Object> map = new HashMap();
        map.put("dwmc", "测试");
        map.put("zgbm", "测试11");
        map.put("yyzzh", "测试22");
        map.put("lxdh", "测试33");
        map.put("slsj1", "测试44");
        context.putVar("basicform", map);
        xlsArea.applyAt(new CellRef("封面!A1"), context);

        Area xlsArea1 = xlsAreaList.get(1);
        xlsArea1.applyAt(new CellRef("基本情况1!A1"), context);

        Area xlsArea2 = xlsAreaList.get(1);
        xlsArea2.applyAt(new CellRef("基本情况2!A1"), context);

        transformer.write();
        is.close();
    }

    public static void main(String[] args) throws IOException, SQLException, InvalidFormatException, ParseException {
        execute(new FileOutputStream(new File("d:/xxx.xls")));
    }
}