首先感谢强哥,这个工具类是他整理的,我负责拿小本本记下来。
package com.jxy.java.test;
import java.io.InputStream;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
/**
* Excel文件数据管理器,主要是数据导入和导出
* @author qiang.xu
*
*/
public class ExcelDataUtils {
static Logger logger = Logger.getLogger(ExcelDataUtils.class);
/** Excel标题参数 **/
private JSONObject titParam = new JSONObject();
private int defR = 0;
private int checkR = 100;
/* 存放每个步骤的处理结果 */
public JSONObject result = new JSONObject();
/** 默认的标题和属性名关联参数 **/
private void initParam(){
titParam.put("问题", "ItemName");
titParam.put("答案", "answer");
titParam.put("其它问法1", "sameTit1");
titParam.put("其它问法2", "sameTit2");
titParam.put("其它问法3", "sameTit3");
titParam.put("推荐问题1", "recommend1");
titParam.put("推荐问题2", "recommend2");
titParam.put("推荐问题3", "recommend3");
titParam.put("FAQ分类", "category");
titParam.put("生效时间", "effectTime");
titParam.put("有效期", "validityTime");
titParam.put("技能ID", "skill");
titParam.put("渠道", "from");
}
/**
* 构造方法
* @param checkR 每多少条数据回调一次
* @param titParam