cn.renlm.plugins.MyExcel.handler.DataWriterHandler Maven / Gradle / Ivy

Go to download
/*
 * Copyright (c) 2020 Renlm
 * MyExcel is licensed under Mulan PSL v2.
 * You can use this software according to the terms and conditions of the Mulan PSL v2.
 * You may obtain a copy of Mulan PSL v2 at:
 * 	http://license.coscl.org.cn/MulanPSL2
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PSL v2 for more details.
 */
package cn.renlm.plugins.MyExcel.handler;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;

import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.ClassUtil;
import cn.hutool.core.util.NumberUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import cn.renlm.plugins.MyExcel.config.MyColumn;
import cn.renlm.plugins.MyExcel.config.column.Dict.DictItem;
import cn.renlm.plugins.MyExcel.config.column.Dict.DictType;
import cn.renlm.plugins.MyExcel.entity.CellUnit;
import cn.renlm.plugins.MyExcel.util.StyleUtil;

/**
 * 数据写入处理
 * 
 * @author RenLiMing(任黎明)
 *
 */
public class DataWriterHandler {

	private final SXSSFWorkbook wb;

	private final SXSSFSheet createSheet;

	private final int dataRowStart;

	private final List> fieldTitles;

	public DataWriterHandler(SXSSFWorkbook wb, SXSSFSheet createSheet, int dataRowStart,
			List> fieldTitles) {
		this.wb = wb;
		this.createSheet = createSheet;
		this.dataRowStart = dataRowStart;
		this.fieldTitles = fieldTitles;
	}

	public String getSheetName() {
		return this.createSheet.getSheetName();
	}

	/**
	 * 数据写入
	 * 
	 * @param object
	 */
	public void write(Object object) {
		List