java poi导出与导入excel 工具类

最新推荐文章于 2023-08-01 10:05:23 发布

未来_之路

最新推荐文章于 2023-08-01 10:05:23 发布

阅读量781

点赞数 1

分类专栏： java 文章标签： poi 导出导入 excel

本文链接：https://blog.csdn.net/weilai_zhilu/article/details/53304600

版权

1.工具类

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
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.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;

public class ExportUtil {

	public static void main(String[] args) {
		String tableName = "用户信息";
		Map<String, String> columnMap = new HashMap<String, String>();
		columnMap.put("id", "用户编号");
		columnMap.put("realName", "用户姓名");
		columnMap.put("phone", "手机号");
		columnMap.put("address", "地址");
		
		List<Map<String, Object>> listData = new ArrayList<Map<String, Object>>();
		for (int i = 0; i < 100; i++) {
			Map<String, Object> valueMap = new HashMap<String, Object>();
			valueMap.put("id", ""+i);
			valueMap.put("realName", "齐天大圣"+i);
			valueMap.put("phone", 1300322167+i);
			valueMap.put("address", "上海市"+i);
			listData.add(valueMap);
		}
		
		List<UserPojo> listBean = new ArrayList<UserPojo>();
		for (int i = 0; i < 2; i++) {
			UserPojo user = new UserPojo();
			user.setId(i);
			user.setRealName("实体：齐天大圣" + i);
			user.setPhone("实