easypoi示例

最新推荐文章于 2023-05-16 17:24:44 发布
最新推荐文章于 2023-05-16 17:24:44 发布
阅读量401 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lhw244/article/details/115243993
版权
这段代码展示了如何使用Easypoi库来创建Excel模板并导出数据。它包含了多个方法（如one、one2等），每个方法对应一个不同的模板导出，并在`testBefore`、`testBefore2`等方法中设置了相应的数据。主要功能包括合并单元格、设置列循环等。示例中涉及的模板文件包括了各种不同类型的表格布局和数据处理。
摘要由CSDN通过智能技术生成 
package com.jeecg.demo.util;

import java.io.FileOutputStream;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
import cn.afterturn.easypoi.util.PoiMergeCellUtil;

public class Test2 {
	Map<String, Object> value = new HashMap<String, Object>();

	public void one() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//for_Coltest.xlsx");
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();

	}


	public void one2() throws Exception {
		URL url = Test2.class.getClassLoader().getResource("diagrams");
		System.out.println(url);
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//fxjg.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void two() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
				"doc/for_Col.xlsx", 1);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		FileOutputStream fos = new FileOutputStream("D:/ExcelExportTemplateColFeTest_two.xlsx");
		book.write(fos);
		fos.close();

	}

	public void testBefore() {
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("name", "小明挑战");
//		map.put("zq", "正确");
//		map.put("cw", "错误");
		map.put("tj", "统计");
//		map.put("zqmk", "t.zq_xm");
//		map.put("cwmk", "t.cw_xm");
		map.put("tjmk", "t.tj_xm");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("name", "小红挑战");
//		map.put("zq", "正确");
//		map.put("cw", "错误");
		map.put("tj", "统计");
//		map.put("zqmk", "n:t.zq_xh");
//		map.put("cwmk", "n:t.cw_xh");
		map.put("tjmk", "t.tj_xh");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("one", "运动");
		map.put("two", "跑步");
//		map.put("zq_xm", 1);
//		map.put("cw_xm", 2);
		map.put("tj_xm", 1);
//		map.put("zq_xh", 4);
//		map.put("cw_xh", 2);
		map.put("tj_xh", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("one", "运动");
		map.put("two", "跳高");
//		map.put("zq_xm", 1);
//		map.put("cw_xm", 2);
		map.put("tj_xm", 3);
//		map.put("zq_xh", 4);
//		map.put("cw_xh", 2);
		map.put("tj_xh", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("one", "文化");
		map.put("two", "数学");
//		map.put("zq_xm", 1);
//		map.put("cw_xm", 2);
		map.put("tj_xm", 5);
//		map.put("zq_xh", 4);
//		map.put("cw_xh", 2);
		map.put("tj_xh", 6);
		valList.add(map);

		value.put("valList", valList);
	}
	
	public void testBefore2() {
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("price", "t.price1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "运动");
		map.put("biddesc", "跑步");
		map.put("model", 1);
		map.put("unit", 1);
		map.put("scount", 1);
		map.put("price1", 4);
		map.put("price2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "运动");
		map.put("biddesc", "跳高");
		map.put("model", 2);
		map.put("unit", 2);
		map.put("scount", 2);
		map.put("price1", 3);
		map.put("price2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "文化");
		map.put("biddesc", "数学");
		map.put("model", 3);
		map.put("unit", 3);
		map.put("scount", 3);
		map.put("price1", 5);
		map.put("price2", 6);
		valList.add(map);

		value.put("valList", valList);
		
		value.put("projectNum", "01");
		value.put("projectName", "开标项目");
		value.put("year", "2000");
	}
	
	public void one3() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//kbylb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore3() {
		
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("price", "t.price1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "运动");
		map.put("price1", 4);
		map.put("price2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "运动");
		map.put("price1", 3);
		map.put("price2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "文化");
		map.put("price1", 5);
		map.put("price2", 6);
		valList.add(map);

		value.put("valList", valList);
		
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidName", "3");
		value.put("xm", "4");
		value.put("sbmc", "5");
		value.put("hb", "6");
		value.put("kbdd", "7");
		value.put("kbrq", "8");
		value.put("dw", "9");
		value.put("zcr", "10");
		value.put("kbr", "11");
		value.put("jdr", "12");
		value.put("cbr", "13");
		value.put("jlr", "14");
	}
	
	public void one4() throws Exception {
		//这个模板有隐藏列
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//jgbjhpf.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore4() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "标段1/包号2");
		value.put("bidDesc", "变电站");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("price", "t.price1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 4);
		map.put("price2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 3);
		map.put("price2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 5);
		map.put("price2", 6);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);

		
		value.put("valList", valList);
		
	}
	
	public void one5() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//jxb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void testBefore5() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidname", "a");
		map.put("packagename", "a");
		map.put("biddesc", "c");
		map.put("biddername", "d");
		map.put("tenderprice", "e");
		map.put("evaluebidprice", "f");
		map.put("updatereason", "g");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidname", "a");
		map.put("packagename", "a");
		map.put("biddesc", "cc");
		map.put("biddername", "dd");
		map.put("tenderprice", "ee");
		map.put("evaluebidprice", "ff");
		map.put("updatereason", "gg");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidname", "a");
		map.put("packagename", "a");
		map.put("biddesc", "cc");
		map.put("biddername", "dd");
		map.put("tenderprice", "ee");
		map.put("evaluebidprice", "ff");
		map.put("updatereason", "gg");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidname", "aa");
		map.put("packagename", "bb");
		map.put("biddesc", "cc");
		map.put("biddername", "dd");
		map.put("tenderprice", "ee");
		map.put("evaluebidprice", "ff");
		map.put("updatereason", "gg");
		valList.add(map);
		value.put("valList", valList);
		
	}
	
	public void one6() throws Exception {
		//这个模板有隐藏列
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//zhpfjpx.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore6() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "标段1/包号2");
		value.put("bidDesc", "变电站");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("price", "t.price1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 4);
		map.put("price2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 3);
		map.put("price2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 5);
		map.put("price2", 6);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		
		value.put("valList", valList);
		
	}
	
	public void one7() throws Exception {
		URL url = Test2.class.getClassLoader().getResource("diagrams");
		System.out.println(url);
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//jsxy.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 9, 0,1,2);
		book.getSheetAt(0).addMergedRegion(new CellRangeAddress(8, 8, 0, 1));
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore7() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "标段1/包号2");
		value.put("bidDesc", "变电站");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("ifhg", "t.ifhg1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("ifhg", "t.ifhg2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("xh", "1");
		map.put("pfxname", "要求1");
		map.put("ifhg1", 4);
		map.put("ifhg2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "2");
		map.put("pfxname", "要求2");
		map.put("ifhg1", 3);
		map.put("ifhg2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "3");
		map.put("pfxname", "要求3");
		map.put("ifhg1", "√");
		map.put("ifhg2", "×");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "4");
		map.put("pfxname", "要求3");
		map.put("ifhg1", 5);
		map.put("ifhg2", 6);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "abc");
		map.put("pfxname", "abc");
		map.put("ifhg1", 5);
		map.put("ifhg2", 6);
		valList.add(map);

		value.put("valList", valList);
	}
	
	public void one8() throws Exception {
		URL url = Test2.class.getClassLoader().getResource("diagrams");
		System.out.println(url);
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//jshz.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 9, 0,1,2);
		book.getSheetAt(0).addMergedRegion(new CellRangeAddress(8, 8, 0, 1));
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore8() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "标段1/包号2");
		value.put("bidDesc", "变电站");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("ifhg", "t.ifhg1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("ifhg", "t.ifhg2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("xh", "1");
		map.put("pfxname", "要求1");
		map.put("ifhg1", 4);
		map.put("ifhg2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "2");
		map.put("pfxname", "要求2");
		map.put("ifhg1", 3);
		map.put("ifhg2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "3");
		map.put("pfxname", "要求3");
		map.put("ifhg1", "√");
		map.put("ifhg2", "×");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "4");
		map.put("pfxname", "要求3");
		map.put("ifhg1", 5);
		map.put("ifhg2", 6);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "abc");
		map.put("pfxname", "abc");
		map.put("ifhg1", 5);
		map.put("ifhg2", 6);
		valList.add(map);

		value.put("valList", valList);
	}
	
	public void one9() throws Exception {
		URL url = Test2.class.getClassLoader().getResource("diagrams");
		System.out.println(url);
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//jspfxz.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 9, 0,1,2);
		book.getSheetAt(0).addMergedRegion(new CellRangeAddress(8, 8, 0, 1));
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore9() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "标段1/包号2");
		value.put("bidDesc", "变电站");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("score", "t.score1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("score", "t.score2");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("pingfx", "1");
		map.put("pingfxz", "要求1");
		map.put("score1", 4);
		map.put("score2", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("pingfx", "2");
		map.put("pingfxz", "要求2");
		map.put("score1", 3);
		map.put("score2", 4);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("pingfx", "3");
		map.put("pingfxz", "要求3");
		map.put("score1", "√");
		map.put("score2", "×");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("pingfx", "4");
		map.put("pingfxz", "要求3");
		map.put("score1", 5);
		map.put("score2", 6);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("pingfx", "abc");
		map.put("pingfxz", "abc");
		map.put("score1", 5);
		map.put("score2", 6);
		valList.add(map);

		value.put("valList", valList);
	}
	
	public void one10() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//bhghz.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        //PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void testBefore10() {
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		value.put("projectName", "项目名称2");
		map = new HashMap<String, Object>();
		map.put("xh", "1");
		map.put("bidpackage", "a");
		map.put("wlmc", "c");
		map.put("biddername", "d");
		map.put("jsbhgyy", "e");
		map.put("swbhgyy", "f");
		map.put("psyj", "g");
		map.put("fhr", "g");
		map.put("psjl", "不合格");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "2");
		map.put("bidpackage", "a");
		map.put("wlmc", "cc");
		map.put("biddername", "dd");
		map.put("jsbhgyy", "ee");
		map.put("swbhgyy", "ff");
		map.put("psyj", "gg");
		map.put("fhr", "g");
		map.put("psjl", "不合格");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("xh", "3");
		map.put("bidpackage", "a");
		map.put("wlmc", "cc");
		map.put("biddername", "dd");
		map.put("jsbhgyy", "ee");
		map.put("swbhgyy", "ff");
		map.put("psyj", "gg");
		map.put("fhr", "g");
		map.put("psjl", "不合格");
		valList.add(map);
		
		
		value.put("valList", valList);
		
	}
	
	public void one11() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//cshb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//列从0开始，合并第一列和第三列相同的数据
        PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 1, 3);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void testBefore11() {
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		value.put("projectName", "项目名称2");
		map = new HashMap<String, Object>();
		map.put("xh", "1");
		map.put("wlmc", "c");
		map.put("biddername", "d");
		map.put("rwjs", "10");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "2");
		map.put("wlmc", "c");
		map.put("biddername", "d2");
		map.put("rwjs", "10");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("xh", "3");
		map.put("wlmc", "c");
		map.put("biddername", "d3");
		map.put("rwjs", "10");
		valList.add(map);
		
		map.put("xh", "4");
		map.put("wlmc", "cc");
		map.put("biddername", "d");
		map.put("rwjs", "12");
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("xh", "5");
		map.put("wlmc", "cc");
		map.put("biddername", "d2");
		map.put("rwjs", "12");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("xh", "6");
		map.put("wlmc", "cc");
		map.put("biddername", "d3");
		map.put("rwjs", "12");
		valList.add(map);
		value.put("valList", valList);
		
	}
	
	public void one12() throws Exception {
		//这个模板有隐藏列
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//zhpfjpxfx.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore12() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("bidpackage", "/");
		value.put("bidDesc", "");
		value.put("skillRate", "10");
		value.put("businessRate", "50");
		value.put("priceRate", "80");
		List<Map<String, Object>> colList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("biddername", "小明挑战");
		map.put("price", "t.price1");
		colList.add(map);

		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price2");
		colList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("biddername", "小红挑战");
		map.put("price", "t.price3");
		colList.add(map);

		value.put("colList", colList);

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 4);
		map.put("price2", 2);
		map.put("price3", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 3);
		map.put("price2", 4);
		map.put("price3", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 5);
		map.put("price2", 6);
		map.put("price3", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		map.put("price3", 2);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		map = new HashMap<String, Object>();
		map.put("bidpackage", "");
		map.put("price1", 7);
		map.put("price2", 8);
		valList.add(map);
		
		value.put("valList", valList);
		
		List<Map<String, Object>> fxList = new ArrayList<Map<String, Object>>();
		//先处理表头
		Map<String, Object> fxmap = new HashMap<String, Object>();
		fxmap.put("zbh", "1");
		fxmap.put("sbmc", "a");
		fxmap.put("gg", "a");
		fxmap.put("dw", "a");
		fxmap.put("sl", "a");
		fxList.add(fxmap);

		fxmap = new HashMap<String, Object>();
		fxmap.put("zbh", "1");
		fxmap.put("sbmc", "b");
		fxmap.put("gg", "b");
		fxmap.put("dw", "a");
		fxmap.put("sl", "a");
		fxList.add(fxmap);

		value.put("fxList", fxList);
		
	}
	
	public void one13() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//sbqkmfjyb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void testBefore13() {
		value.put("projectName", "1");
		value.put("projectNum", "2");
		value.put("bidName", "3");
		value.put("packageName", "4");
		value.put("kbrs", "10");
		value.put("jdrq", "2020-10-11");
	}
	
	public void one14() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//yzpjyj.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore14() {
		value.put("projectName", "1");
		value.put("projectNum", "2");
		value.put("projectUnit", "3");
	}
	
	public void one15() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//zbtzylb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        //PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	
	public void testBefore15() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("zbsj", "2010-10-10");
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/1");
		map.put("biddername", "a");
		map.put("tenderprice", "100");
		map.put("fwf", "");
		map.put("qm", "");
		map.put("dh", "");
		map.put("sj", "");
		
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/2");
		map.put("biddername", "b");
		map.put("tenderprice", "200");
		map.put("fwf", "");
		map.put("qm", "");
		map.put("dh", "");
		map.put("sj", "");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/3");
		map.put("biddername", "b");
		map.put("tenderprice", "200");
		map.put("fwf", "");
		map.put("qm", "");
		map.put("dh", "");
		map.put("sj", "");
		valList.add(map);
		value.put("valList", valList);
	}
	
	public void one16() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		  //  "D://model//sgtzs.xlsx");
				 "D://model//fwtzs.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        //PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore16() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("zbdw", "2");
		value.put("xmdw", "3");
		value.put("hj", "300");
		value.put("zblxr", "陈300");
		
		value.put("dqri", "2010-10-10");
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidname", "1");
		map.put("packagename", "a");
		map.put("projectname", "100");
		map.put("dd", "");
		map.put("gq", "1");
		map.put("zj", "2");
		
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidname", "2");
		map.put("packagename", "a1");
		map.put("projectname", "100");
		map.put("dd", "");
		map.put("gq", "1");
		map.put("zj", "2");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidname", "3");
		map.put("packagename", "a2");
		map.put("projectname", "100");
		map.put("dd", "");
		map.put("gq", "1");
		map.put("zj", "2");
		valList.add(map);
		value.put("valList", valList);
	}
	
	
	public void one17() throws Exception {
		TemplateExportParams params = new TemplateExportParams(
		    "D://model//fwylb.xlsx");
			//	 "D://model//sgylb.xlsx");
		//String path=url+"/fxjg.xlsx";
		//path=path.substring(6, path.length());
		//System.out.println("path："+path);
		//TemplateExportParams params = new TemplateExportParams(
		//		path);
		params.setColForEach(true);
		Workbook book = ExcelExportUtil.exportExcel(params, value);
        //PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 0, 0, 0, 6);

		//PoiMergeCellUtil.mergeCells(book.getSheetAt(0), 1, 0,1);
		FileOutputStream fos = new FileOutputStream("D:/model/ExcelExportTemplateColFeTest_one.xlsx");
		book.write(fos);
		fos.close();
	}
	
	public void testBefore17() {
		value.put("projectNum", "1");
		value.put("projectName", "2");
		value.put("hj", "300");
		value.put("dqri", "2010-10-10");
		Map<String, Object> map = new HashMap<String, Object>();

		List<Map<String, Object>> valList = new ArrayList<Map<String, Object>>();
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/2");
		map.put("projectname", "100");
		map.put("zj", "2");
		map.put("biddername", "2");
		map.put("gq", "2");
		map.put("phone", "2");
		map.put("person", "2");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/2");
		map.put("projectname", "100");
		map.put("zj", "2");
		map.put("biddername", "2");
		map.put("gq", "2");
		map.put("phone", "2");
		map.put("person", "2");
		valList.add(map);
		
		map = new HashMap<String, Object>();
		map.put("bidpackage", "1/2");
		map.put("projectname", "100");
		map.put("zj", "2");
		map.put("biddername", "2");
		map.put("gq", "2");
		map.put("phone", "2");
		map.put("person", "2");
		valList.add(map);
		value.put("valList", valList);
	}
	
	public static void main(String[] args) {
		Test2 t=new Test2();
		try {
			t.testBefore13();
			t.one13();
			//String time = new SimpleDateFormat("yyyy年MM月dd日").format(new Date());
			//System.out.println(time);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}

 

missccy
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
easypoi导入导出实例
10-24
easypoi完整的导入导出实例，内包含完整项目以及excel文件，导入可直接使用。
easy-poi导入导出excel实例
03-15
easy-poi导入导出excel实例,包含所需jar包,可直接使用
Easypoi的基础及使用示例
javaxiaobai21的博客
08-26 573
Easypoi的基础及使用
easyPOI导出案例
wazk2008的博客
05-28 1044
1.引入jar包 <dependency> <groupId>cn.afterturn</groupId> <artifactId>easypoi-base</artifactId> <version>3.2.0</version> </dependency> <dep...
使用EasyPoi轻松导入导出Excel文档的方法示例
08-25
主要介绍了使用EasyPoi轻松导入导出Excel文档的方法示例，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
easyPOI基本用法
04-01
### easyPOI基本用法详解 #### 1. Excel文件的简单导入和导出 **1.1 准备工作** 在使用easyPOI进行Excel文件处理前，我们需要完成一些必要的准备工作。 1. **构建Spring Boot项目：** - 首先，需要通过Spring ...
EasyPoi教程
09-30
为了快速上手EasyPoi，建议参考官方提供的示例项目`easypoi-test`，该示例涵盖了大部分常用功能。 **5.3 测试** EasyPoi提供了详尽的测试案例，包括JUnit单元测试和Spring MVC视图测试。通过这些测试案例可以帮助...
easypoi功能文档，介绍easypoi各种功能使用
11-30
- 运行示例应用程序，查看导出效果。 Easypoi作为一个高效、易用的工具，极大地简化了Excel和Word处理，让开发者能更专注于业务逻辑，而不是繁琐的文件操作。无论你是初学者还是经验丰富的开发者，Easypoi都能帮助...
easypoi jar包.rar
03-11
7. **使用示例**： 使用Easypoi时，通常需要创建一个Java类来表示Excel或Word的行数据，然后通过注解指定列映射。在导出时，只需创建对象列表，调用Easypoi提供的方法即可生成文件。对于导入，Easypoi会自动读取...
easyPOI导出.rar
07-18
从【压缩包子文件的文件名称列表】"easyPOI导出"来看，这个压缩包很可能包含了示例代码、教程或者库的使用指南，帮助用户理解和应用easyPOI进行Excel导出操作。内容可能包括Java源码、配置文件、测试用例、README...
用easypoi 制表 格式 列子
12-21
一个很实用的例子！比起poi操作excel 这个比较简单！方便
编码技巧——使用Easypoi导出Excel、多sheet、模板导出
热门推荐
娜娜米的博客
11-29 1万+
本文主要介绍easypoi导出Excel的代码示例；自己之前手动实现过导出工具类《编码技巧——导出工具类》，基于实体和注解，通过反射来映射实体字段和exce列的关系；在部分工程里面看到了easypoi的二方包，于是准备试用下，记录下如何引入并使用Easypoi的过程；
文件上传/easypoi简单模板导出Excel
qq_30944053的博客
04-18 887
工具类:Upload.java package com.example.sl.layer.util; import cn.afterturn.easypoi.excel.ExcelImportUtil; import cn.afterturn.easypoi.excel.entity.ImportParams; import org.apache.commons.lang3.StringUt...
easypoi 读取resource下的模板时TemplateExportParams的设置
FunnyWhiteCat的博客
04-20 9370
参考文章：SpringBoot读取Resource下文件的几种方式 我的模板是放在 resource 的 exportTemplate 文件夹下，以下是设置方法 TemplateExportParams params = new TemplateExportParams("exportTemplate/模板.xls"); 注意，路径不以'/'开头，一开始是下边的写法一致读不到。就这一个问题...
EasyPOI模版导出坑！使用TemplateExportParams模版导出，生成的Excel文件sheet页为空问题
jx2402836701的博客
05-16 1224
我的问题就是因为模版相关的代码都写在了默认的sheet2中，把sheet1删掉后，读取会异常，依然会读取到两个sheet页，然后默认会用第一个sheet，而我的模版代码在第二个sheet中，这时候导出来的Excel就是空的，表头数据内容都没有。如题，读取到一个HssfWorkBook文档对象，调试发现该对象中有2个sheet表单对象。excel默认有3个sheet，删除后面的，没问题，删除前面的，就出这个问题。而实际文档对象中只有1个sheet表单，也没有隐藏的表单。这样，导致读取excel文档报错。
[easypoi]模板导出
AnnieRabbit的博客
04-28 2881
easypoi 的模板导出 一.确定想实现的导出样式 二.添加依赖 因为原项目中有poi 引入,这里需要排除掉 <dependency> <groupId>cn.afterturn</groupId> <artifactId>easypoi-spring-boot-starter</artifactId> <version>4.1.2</version&gt
基于easypoi实现自定义模板导出excel
qq_43842093的博客
12-19 5968
项目中需要做一个统计报表功能，实现各种Excel报表数据导出。要求表头能够动态配置，表数据通过存储过程实现，也要求能够动态配置。 技术选型： 由于之前在项目中使用过easypoi，相对于原生apache poi，能够用很少的代码写出Excel导入、导出功能，且API清晰好理解。因此优先选择了使用easypoi，验证功能需求能否实现。easypoi是基于apache poi开发，在此基础上进行了封装和扩展，特别复杂的功能就需要使用基础poi来开发了。 开发指南：https://opensource.aft.
EasyPOI（四）导入、注解导出、模板导出
ACGkaka的博客
06-10 2031
EasyPOI 是一款开源的基于Java语言的Excel操作工具。 官方文档1：http://easypoi.mydoc.io/ 官方文档2：http://doc.wupaas.com/docs/easypoi/easypoi-1c0u6ksp2r091 官方源码：https://gitee.com/lemur/easypoi.git 官方测试案例：https://gitee.com/lemur/easypoi-test.git 1.导入Excel 官方Demo： https://github...
使用easyPOI根据模板导出
wang20010104的博客
05-10 2864
使用easyPOI根据模板导出
easypoi excel模板导出 java代码示例
最新发布
06-13
好的，这里给你一个完整的例子，演示如何使用easypoi库导出excel模板。假设你有一个excel模板文件`template.xlsx`，其中有一张名为`Sheet1`的表格，需要填充数据后导出为`output.xlsx`文件。 ```java import cn.afterturn.easypoi.excel.ExcelExportUtil; import cn.afterturn.easypoi.excel.entity.TemplateExportParams; import org.apache.poi.ss.usermodel.Workbook; import java.io.FileOutputStream; import java.io.IOException; import java.util.HashMap; import java.util.Map; public class ExcelTemplateExporter { public static void main(String[] args) throws IOException { // 创建填充数据的Map Map<String, Object> data = new HashMap<>(); data.put("name", "张三"); data.put("age", 18); data.put("gender", "男"); // 创建excel导出参数 TemplateExportParams params = new TemplateExportParams("template.xlsx"); // 导出excel文件 Workbook workbook = ExcelExportUtil.exportExcel(params, data); FileOutputStream fos = new FileOutputStream("output.xlsx"); workbook.write(fos); fos.close(); System.out.println("Excel导出成功！"); } } ``` 这个例子中，我们首先创建了一个`Map`对象，将需要填充的数据放入其中。接着，我们创建了一个`TemplateExportParams`对象，指定了excel模板文件的路径。最后，我们调用`ExcelExportUtil.exportExcel`方法，将模板和填充数据传入，得到一个填充好数据的`Workbook`对象。最后将`Workbook`对象输出为`output.xlsx`文件。 需要注意的是，这个例子中使用的是easypoi库，相较于poi库，easypoi库可以更快速、简便地进行excel导入导出，并且支持更多的excel操作功能。在实际项目中，你可以根据具体需求选择使用不同的excel库。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值