package com.copowers.sdpt.common;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFCell;
import java.io.InputStream;
import java.text.DecimalFormat;
import java.util.Iterator;
import java.util.Map;
import static org.apache.poi.ss.usermodel.CellType.NUMERIC;
/**
* Writer: loong
*/
@SuppressWarnings("unchecked")
public class PoiUitl {
/**
* 替换Excel模板文件内容
* @param item 文档数据
*/
public static HSSFWorkbook replaceModel(Map<String,Object> item, InputStream ino) {
boolean bool = true;
try {
POIFSFileSystem fs =new POIFSFileSystem(ino);
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt
POI进行excel内容替换
最新推荐文章于 2023-02-07 17:51:59 发布