ExcelExportTemplateTest

package com.bmw.ntt.utils;

import com.bmw.ttm.excel.ExcelUtil;
import com.bmw.ttm.util.UtilDate;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.jeecgframework.poi.excel.ExcelExportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.TemplateExportParams;
import org.jeecgframework.poi.excel.entity.enmus.ExcelStyleType;
import org.jeecgframework.poi.excel.entity.enmus.ExcelType;
import org.jeecgframework.poi.excel.export.ExcelExportServer;
import org.junit.Before;
import org.junit.Test;

import java.io.File;
import java.io.FileOutputStream;
import java.util.*;

public class ExcelExportTemplateTest {

    //List<CourseEntity> list = new ArrayList<CourseEntity>();
//    CourseEntity       courseEntity;

    //@Test
//    public void one() throws Exception {
//        TemplateExportParams params = new TemplateExportParams(
//            "C:\\Users\\13571\\Desktop\\exportTemp.xls", true);
//        params.setHeadingRows(2);
//        params.setHeadingStartRow(2);
//        params.setStyle(ExcelStyleType.BORDER.getClazz());
//        Map<String, Object> map = new HashMap<String, Object>();
//        //sheet 1
//        map.put("year", "2013");
//        map.put("sunCourses", list.size());
//        Map<String, Object> obj = new HashMap<String, Object>();
//        map.put("obj", obj);
//        obj.put("name", list.size());
//
//
//        // sheet 2
//        map.put("month", 10);
//        Map<String, Object> temp;
//        for (int i = 1; i < 8; i++) {
//            temp = new HashMap<String, Object>();
//            temp.put("per", i * 10);
//            temp.put("mon", i * 1000);
//            temp.put("summon", i * 10000);
//            map.put("i" + i, temp);
//        }
//        Workbook book = ExcelExportUtil.exportExcel(params, CourseEntity.class, list, map);
//        File savefile = new File("D:/excel/");
//        if (!savefile.exists()) {
//            savefile.mkdirs();
//        }
//        FileOutputStream fos = new FileOutputStream("D:/excel/exportTemp-ntt-twoSheet.xls");
//        book.write(fos);
//        fos.close();
//
//    }

    //@Before
//    public void testBefore() {
//        courseEntity = new CourseEntity();
//        courseEntity.setId("1131");
//        courseEntity.setName("小白");
//
//        TeacherEntity teacherEntity = new TeacherEntity();
//        teacherEntity.setId("12131231");
//        teacherEntity.setName("你们");
//        courseEntity.setChineseTeacher(teacherEntity);
//
//        teacherEntity = new TeacherEntity();
//        teacherEntity.setId("121312314312421131");
//        teacherEntity.setName("老王");
//        courseEntity.setMathTeacher(teacherEntity);
//
//        StudentEntity studentEntity = new StudentEntity();
//        studentEntity.setId("11231");
//        studentEntity.setName("撒旦法司法局");
//        studentEntity.setBirthday(new Date());
//        studentEntity.setSex(1);
//        List<StudentEntity> studentList = new ArrayList<StudentEntity>();
//        studentList.add(studentEntity);
//        studentList.add(studentEntity);
//        courseEntity.setStudents(studentList);
//
//        for (int i = 0; i < 3; i++) {
//            list.add(courseEntity);
//        }
//    }

    @Test
    public void two() throws Exception {
//        TemplateExportParams params = new TemplateExportParams(
//            "C:\\Users\\13571\\Desktop\\exportTemp.xls", 1);
        TemplateExportParams params = new TemplateExportParams("C:\\Users\\13571\\Desktop\\exportTemp.xls", 1);
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("month", 10);
        Map<String, Object> temp;
        for (int i = 1; i < 8; i++) {
            temp = new HashMap<String, Object>();
            temp.put("per", i * 10);
            temp.put("mon", i * 1000);
            temp.put("summon", i * 10000);
            map.put("i" + i, temp);
        }
        params.setTempParams("t");
        params.setSheetName("sheetname");
        Workbook book = ExcelExportUtil.exportExcel(params, map);
        File savefile = new File("D:/excel/");
        if (!savefile.exists()) {
            savefile.mkdirs();
        }
        FileOutputStream fos = new FileOutputStream("D:/excel/exportTemp-ntt-sheets4.xls");
        book.write(fos);
        fos.close();

    }


    @Test
    public void four() throws Exception {
        TemplateExportParams params = new TemplateExportParams(
                "C:\\Users\\13571\\Desktop\\ExamNoticeTemplate.xls");
        params.setStyle(ExcelStyleType.BORDER.getClazz());
        String studentNotice = "1、所有考生根据考试安排表准时出席认证开场说明会和各考试项目，如果没有在规定时间内参加认证或迟到时间5分钟以上的作自动放弃处理, 取消认证资格;\n" +
        "\n 2、考试当天请出示身份证，严禁携带手机等通讯设备，如果携带，需交给老师统一保管，一旦发现使用手机，以作弊论处； ";

        Map<String, Object> temp = new HashMap<>();
        temp.put("cerName", "2016年BMW技师L1认证_3月25日XATC");
        temp.put("name", "寇广杰");
        temp.put("tel", "13820887481");
        temp.put("position", "机电");
        temp.put("address", "BMW西安培训中心");
        temp.put("dealer", "天津浩之宝");
        temp.put("timeTip", "2016-03-25--2016-03-25 \n " +
                "具体时间安排请到考试现场查询");
        temp.put("studentNotice", studentNotice);
        temp.put("verCode", "087312");
        List<Map<String, String>> listMap = new ArrayList<Map<String, String>>();
        for (int i = 0; i < 13; i++) {
            Map<String, String> lm = new HashMap<String, String>();
            lm.put("id", i+"");
            lm.put("itemName", "功能操作"+i);
            listMap.add(lm);
        }

        params.setSheetName("考试通知");
        //Workbook book = ExcelExportUtil.exportExcel(params, Map.class, itemNameList, temp);
        temp.put("maplist", listMap);

        Workbook book = ExcelExportUtil.exportExcel(params, temp);
        book.createSheet("考试通知2");
        TemplateExportParams params2 = params;
        params2.setSheetName("test1");
        Workbook book2 = ExcelExportUtil.exportExcel(params2, temp);
        File savefile = new File("D:/excel/");
        if (!savefile.exists()) {
            savefile.mkdirs();
        }
        //POIUtils.copySheet((HSSFWorkbook)book, (HSSFSheet)book2.getSheet("test1"), (HSSFSheet)book.getSheet("考试通知2"), true);

        POIUtilCopyWorkBook.copySheet((HSSFWorkbook)book2, (HSSFWorkbook)book, 0, 1);
        FileOutputStream fos = new FileOutputStream("D:/excel/exportTemp-ntt-A222.xls");
        book.write(fos);
        FileOutputStream fos1 = new FileOutputStream("D:/excel/exportTemp-ntt-B222.xls");
        book2.write(fos1);
        fos.close();
        fos1.close();
    }

    @Test
    public void outName(){
        String name = "ExamNotice"+"_"+ UtilDate.convertDateTimeWithUnderScore(new Date())+".xlsx";
        System.out.println(name);
    }

}