excel的导入导出

时间：2018-07-31 18:36:53 阅读：242 评论：0 收藏：0 [点我收藏+]

技术分享图片

ExcelUtil.java

package com.guilf.consumer.excel;

import com.alibaba.fastjson.JSONObject;

import java.io.*;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.POIXMLDocument;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.opc.OPCPackage;
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.ss.util.NumberToTextConverter;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.util.StringUtils;


/**
 * EXCEL导入工具类
 */
public class ExcelUtil {
	/**
	 * 将导入的EXCEL转化为LIST数组
	 *
	 * @param inputStream
	 *            文件输入流
	 * @param startRow
	 *            记录起始行
	 * @param dataLen
	 *            记录所占列数
	 * @return list数组
	 * @throws IOException
	 * @throws InvalidFormatException
	 */
	public static List<String[]> readExcel(InputStream inputStream,
			int startRow, int dataLen) throws IOException,
			InvalidFormatException {

		Workbook workbook = getWorkbook(inputStream);

		Sheet sheet = workbook.getSheetAt(0);

		return getDataList(startRow, dataLen, sheet);
	}

	private static List<String[]> getDataList(int startRow, int dataLen, Sheet sheet)
	{
		int rowNum = sheet.getLastRowNum();

		List<String[]> list = new ArrayList<String[]>();
		// 从第三行开始读
		for (int i = startRow; i <= rowNum; i++)
		{
			Row row = sheet.getRow(i);

			String dataArr[] = new String[dataLen];
			StringBuilder sb = new StringBuilder(0);

			for (int j = 0; j < dataLen; j++)
			{
				String data = "";

				Cell cell = row.getCell(j);
				if (null == cell)
				{
					continue;
				}

				switch (cell.getCellType())
				{
				case Cell.CELL_TYPE_ERROR:{
					 byte errorValue = cell.getErrorCellValue();
					 System.out.println(errorValue);
					break;
				}
				case Cell.CELL_TYPE_FORMULA:
					try
					{
						data=cell.getStringCellValue();
					} catch (Exception e){
						data="";
					}
					
					if(StringUtils.isEmpty(data)){
						try{
							data = NumberToTextConverter.toText(cell.getNumericCellValue());
						} catch (Exception e){
							data="";
						}
					}
					if(StringUtils.isEmpty(data)){
						try
						{
							cell.setCellType(Cell.CELL_TYPE_STRING);
							data=String.valueOf(cell.getStringCellValue());
							data=data.replace("#N/A", "");
						} catch (Exception e)
						{
							data="";
						}
					}
					break;
				case Cell.CELL_TYPE_STRING:
					data = cell.getStringCellValue();
					break;
				case Cell.CELL_TYPE_NUMERIC:
					data = NumberToTextConverter.toText(cell.getNumericCellValue());
					break;
				case Cell.CELL_TYPE_BOOLEAN:
					data = String.valueOf(cell.getBooleanCellValue());
					break;
				case Cell.CELL_TYPE_BLANK:
					data = "";
					break;
				default:
					data = "";
					break;
				}

				if (isTrimEmpty(data))
				{
					data = "";
				}

				dataArr[j] = data;
				sb.append(data);
			}

			if (isTrimEmpty(sb.toString()))// 如果空行则跳出，说明该行无数据
			{
				break;
			}
			list.add(dataArr);
		}
		return list;
	}

	private static boolean isTrimEmpty(String s)
	  {
	    return ((s == null) || (s.trim().isEmpty()));
	  }

	private static Workbook getWorkbook(InputStream inputStream)
			throws IOException, InvalidFormatException {
		Workbook workbook;
		if (!inputStream.markSupported()) {
			inputStream = new PushbackInputStream(inputStream, 8);
		}

		if (POIXMLDocument.hasOOXMLHeader(inputStream)) {
			workbook = new XSSFWorkbook(OPCPackage.open(inputStream));
		} else {
			workbook = new HSSFWorkbook(inputStream);
		}
		inputStream.close();

		return workbook;
	}

	public static void main(String[] args) {
		String str = "E:\\Temp\\aa.xls";
		try {
			FileInputStream inputStream = new FileInputStream(str);
			List<String[]> list = ExcelUtil.readExcel(inputStream, 3, 15);
			System.out.println(JSONObject.toJSONString(list));
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

　　SimpleExportExcelUtil.java

package com.guilf.consumer.excel;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.regex.Pattern;

public class SimpleExportExcelUtil
{
    public static void exportExcel(String sheetTitle, String[] attrNames,
                                   List<?> dataList, HttpServletRequest request,
                                   HttpServletResponse response, String[] HEADERS,
                                   String[] NEXT_HEADERS, String fileName, String[] lastRow)
    {
        OutputStream outputStream = null;
        try
        {
            response.setContentType("application/vnd.ms-excel");
            response.addHeader("Content-Disposition", "attachment; filename="
                    + fileName + ".xls");
            outputStream = response.getOutputStream();
            HSSFWorkbook workbook = assemberWorkbook(sheetTitle, attrNames, dataList, response, HEADERS, NEXT_HEADERS, lastRow);
            workbook.write(outputStream);

        } catch (IOException e)
        {
            e.printStackTrace();
        } finally
        {
            if (outputStream != null)
            {

                try
                {
                    outputStream.flush();
                    outputStream.close();
                } catch (IOException e)
                {
                    e.printStackTrace();
                }
            }
            request.getSession().removeAttribute("flag");
            System.gc();
        }

    }

    private static HSSFWorkbook assemberWorkbook(String sheetTitle, String[] attrNames, List<?> dataList, HttpServletResponse response, String[] HEADERS, String[] NEXT_HEADERS, String[] lastRow)
    {
        // 声明一个工作薄
        HSSFWorkbook workbook = new HSSFWorkbook();
        int dsize = dataList.size();
        int size = dsize % 20000 == 0 ? dsize / 20000 : dsize / 20000 + 1;

        if ((0==size)||(1==size))
        {
            data(workbook, sheetTitle, attrNames, dataList, response,
                    HEADERS, NEXT_HEADERS, lastRow);
        } else
        {
            List<Object> sds = new ArrayList<Object>();
            for (int i = 1; i <= size; i++)
            {
                if (i == size)
                {
                    for (int j = 0; j < dsize - (size - 1) * 20000; j++)
                    {
                        sds.add(dataList.get(j + (size - 1) * 20000));
                    }
                } else
                {
                    for (int j = 0; j < 20000; j++)
                    {
                        sds.add(dataList.get(j + 20000 * (i - 1)));
                    }
                }
                data(workbook, sheetTitle + i, attrNames, sds, response,
                        HEADERS, NEXT_HEADERS, lastRow);

                sds.removeAll(sds);
            }
        }
        return workbook;
    }

    
    // 一个excel表生成多张表格的
    public static void exportExcelMoreSheet(HttpServletRequest request,HttpServletResponse response, List<Map<String, Object>> listMap, String fileName)
			{
			OutputStream outputStream = null;
			try
			{
			response.setContentType("application/vnd.ms-excel");
			response.addHeader("Content-Disposition", "attachment; filename="
			+ fileName + ".xls");
			outputStream = response.getOutputStream();
			 // 声明一个工作薄
	        HSSFWorkbook workbook = new HSSFWorkbook();
			workbook = assemberWorkbookMoreSheet(workbook, response, listMap);
			workbook.write(outputStream);
			
			} catch (IOException e)
			{
			e.printStackTrace();
			} finally
			{
			if (outputStream != null)
			{
			
			try
			{
			outputStream.flush();
			outputStream.close();
			} catch (IOException e)
			{
			e.printStackTrace();
			}
			}
			request.getSession().removeAttribute("flag");
			System.gc();
			}
			
			}

    @SuppressWarnings("unchecked")
    private static HSSFWorkbook assemberWorkbookMoreSheet(HSSFWorkbook workbook, HttpServletResponse response,  List<Map<String, Object>> listMap)
    {
       for(int k = 0; k<listMap.size(); k++){
    	   
		List<?> dataList = (List<Map<String, Object>>) listMap.get(k).get("dataList");
		String sheetTitle = (String) listMap.get(k).get("sheetTitle");
		String[] attrNames=(String[]) listMap.get(k).get("attrNames");
		String[] HEADERS=(String[]) listMap.get(k).get("headers");
		String[] NEXT_HEADERS=(String[]) listMap.get(k).get("nextHeaders");
		String[] lastRow=(String[]) listMap.get(k).get("lastRow");
		int dsize;
		if(dataList == null || dataList.size() == 0)
		{
			dataList = new ArrayList<Map<String,Object>>();
			dsize = 0 ;
		}
		else{
			dsize = dataList.size();
		}
        int size = dsize % 20000 == 0 ? dsize / 20000 : dsize / 20000 + 1;

        if ((0==size)||(1==size))
        {
        	int n = 0;
        	for(int m=0; m<k; m++)
        	{
        		if(Objects.equals(sheetTitle, listMap.get(m).get("sheetTitle"))){
        			n++;
        		}
        	}
        	if(n != 0){
        		data(workbook, sheetTitle+"-"+n, attrNames, dataList, response,
                        HEADERS, NEXT_HEADERS, lastRow);
        	}
        	else{
        		data(workbook, sheetTitle, attrNames, dataList, response,
                        HEADERS, NEXT_HEADERS, lastRow);
        	}
        } else
        {
            List<Object> sds = new ArrayList<Object>();
            for (int i = 1; i <= size; i++)
            {
                if (i == size)
                {
                    for (int j = 0; j < dsize - (size - 1) * 20000; j++)
                    {
                        sds.add(dataList.get(j + (size - 1) * 20000));
                    }
                } else
                {
                    for (int j = 0; j < 20000; j++)
                    {
                        sds.add(dataList.get(j + 20000 * (i - 1)));
                    }
                }
                data(workbook, sheetTitle+i, attrNames, sds, response,
                        HEADERS, NEXT_HEADERS, lastRow);

                sds.removeAll(sds);
            }
        }
       }
        return workbook;
    }
    
    private static HSSFCellStyle createHeaderCellStyle(HSSFWorkbook workbook)
    {
        // 生成一个样式
        HSSFCellStyle style = workbook.createCellStyle();
        // 设置这些样式
        // style.setFillForegroundColor(HSSFColor.SKY_BLUE.index);
        // style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        // style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        // style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        // style.setBorderRight(HSSFCellStyle.BORDER_THIN);
        // style.setBorderTop(HSSFCellStyle.BORDER_THIN);
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        return style;
    }

    private static HSSFCellStyle createBodyCellStyle(HSSFWorkbook workbook)
    {
        // 生成一个样式
        HSSFCellStyle style = workbook.createCellStyle();
        // 设置这些样式
        // style.setFillForegroundColor(HSSFColor.LIGHT_YELLOW.index);
        // style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        // style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        // style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        // style.setBorderRight(HSSFCellStyle.BORDER_THIN);
        // style.setBorderTop(HSSFCellStyle.BORDER_THIN);
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        return style;
    }

    private static HSSFFont createHeaderFont(HSSFWorkbook workbook)
    {
        // 生成一个字体
        HSSFFont font = workbook.createFont();
        // font.setColor(HSSFColor.VIOLET.index);
        font.setFontHeightInPoints((short) 10);
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

        return font;
    }

    private static HSSFFont createBodyFont(HSSFWorkbook workbook)
    {
        // 生成一个字体
        HSSFFont font = workbook.createFont();
        font.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);

        return font;
    }

    @SuppressWarnings({"deprecation"})
    private static void data(HSSFWorkbook workbook, String sheetTitle,
                             String[] attrNames, List<?> dataList, HttpServletResponse response,
                             String[] HEADERS, String[] NEXT_HEADERS, String[] lastRow)
    {
        // 生成一个表格
        HSSFSheet sheet =workbook.createSheet(sheetTitle);
        // 设置表格默认列宽度为15个字节
        sheet.setDefaultColumnWidth((short) 15);

        HSSFCellStyle headerStyle = createHeaderCellStyle(workbook);
        // 把字体应用到当前的样式
        headerStyle.setFont(createHeaderFont(workbook));

        HSSFCellStyle bodyStyle = createBodyCellStyle(workbook);
        // 把字体应用到当前的样式
        bodyStyle.setFont(createBodyFont(workbook));

        // 声明一个画图的顶级管理器
        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
        // 定义注释的大小和位置,详见文档
        HSSFComment comment = patriarch.createComment(new HSSFClientAnchor(0,
                0, 0, 0, (short) 4, 2, (short) 6, 5));
        // 设置注释内容
        comment.setString(new HSSFRichTextString("我的钢铁(www.mysteel.com)"));
        // 设置注释作者，当鼠标移动到单元格上是可以在状态栏中看到该内容.
        comment.setAuthor("mysteel");

        // 产生表格标题行
        HSSFRow row = sheet.createRow(0);
        row.setHeight((short) 400);
        int headrow = 1;

        if (HEADERS != null)
        {
            for (short i = 0; i < HEADERS.length; i++)
            {
                HSSFCell cell = row.createCell(i);
                cell.setCellStyle(headerStyle);
                cell.setCellValue(new HSSFRichTextString(HEADERS[i]));
            }

            // 合并表头单元格
            sheet.addMergedRegion(new CellRangeAddress(0, 0, 0,
                    NEXT_HEADERS.length - 1));
            headrow = 2;
        }

        // 产生表格次标题行
        HSSFRow row2 = sheet.createRow(headrow - 1);
        row2.setHeight((short) 400);
        HSSFCell cell = null;
        for (short i = 0; i < NEXT_HEADERS.length; i++)
        {
            cell = row2.createCell(i);
            cell.setCellStyle(headerStyle);
            cell.setCellValue(new HSSFRichTextString(NEXT_HEADERS[i]));
        }

        Pattern p = Pattern.compile("^//d+(//.//d+)?$");

        // 遍历集合数据，产生数据行
        for (int i = 0; i < dataList.size(); i++)
        {
            row = sheet.createRow(i + headrow);

            @SuppressWarnings({"unchecked", "rawtypes"})
            Map<String, Object> map = (Map) dataList.get(i);

            //obj = dataList.get(i);
            // 利用反射，根据javabean属性的先后顺序，动态调用getXxx()方法得到属性值

            for (short j = 0; j < attrNames.length; j++)
            {
                cell = row.createCell(j);
                cell.setCellStyle(bodyStyle);
                String fieldName = attrNames[j];
                /*String methodName = "get"
						+ fieldName.substring(0, 1).toUpperCase()
						+ fieldName.substring(1);*/
                try
                {
					/*Method method = obj.getClass().getMethod(methodName,
							new Class[] {});*/
                    //Object value = method.invoke(obj, new Object[] {});

                    Object value = map.get(fieldName);

                    // 判断值的类型后进行强制类型转换
                    String textValue = null;

                    if (value != null)
                    {
                        if (value instanceof Boolean)
                        {
                            //
                        } else if (value instanceof Date)
                        {
                            //textValue = DateTool.formatJustDate(((Date) value).getTime());
                        } else if (value instanceof byte[])
                        {
                            // 有图片时，设置行高为60px;
                            row.setHeightInPoints(60);
                            // 设置图片所在列宽度为80px,注意这里单位的一个换算
                            sheet.setColumnWidth(j, (short) (35.7 * 100));
                            // sheet.autoSizeColumn(i);
                            byte[] byteValue = (byte[]) value;
                            HSSFClientAnchor anchor = new HSSFClientAnchor(0,
                                    0, 1023, 255, (short) 6, i + 1, (short) 6,
                                    i + 1);
                            anchor.setAnchorType(2);
                            patriarch.createPicture(anchor, workbook
                                    .addPicture(byteValue,
                                            HSSFWorkbook.PICTURE_TYPE_JPEG));
                        } else
                        {
                            // 其它数据类型都当作字符串简单处理
                            textValue = value.toString();
                        }
                    }
                    // 如果不是图片数据，就利用正则表达式判断textValue是否全部由数字组成
                    if (textValue != null)
                    {
                        if (p.matcher(textValue).matches())
                        {
                            // 是数字当作double处理
                            cell.setCellValue(Double.parseDouble(textValue));
                        } else
                        {
                            cell.setCellValue(textValue);
                        }
                    }
                } catch (SecurityException e)
                {
                    e.printStackTrace();
                } catch (IllegalArgumentException e)
                {
                    e.printStackTrace();
                } finally
                {
                    // 清理资源
                }
            }
        }

        if (lastRow != null && lastRow.length > 0)
        {
            row = sheet.createRow(dataList.size() + headrow);
            cell = row.createCell(0);
            cell.setCellStyle(headerStyle);
            cell.setCellValue("合计:");
            int index = 0;
            for (int j = 1; j < NEXT_HEADERS.length; j++)
            {
                if (j >= NEXT_HEADERS.length - lastRow.length)
                {
                    cell = row.createCell(j);
                    cell.setCellStyle(headerStyle);
                    cell.setCellValue(lastRow[index]);
                    index++;
                } else
                {
                    cell = row.createCell(j);
                }
            }

        }
    }
    
//    private static HSSFSheet createSheet(HSSFWorkbook workbook, String sheetTitle, String[] header)
//	{
//		HSSFSheet sheet = workbook.createSheet(sheetTitle);
//		sheet.setDefaultColumnWidth(12);
//		sheet.setColumnWidth(0, 6000);
//		sheet.setColumnWidth(1, 6000);
//		sheet.setColumnWidth(2, 5000);
//		sheet.setColumnWidth(3, 5000);
//		sheet.setColumnWidth(4, 5000);
//		sheet.setColumnWidth(10, 6000);
//		sheet.setColumnWidth(14, 5000);
//		
//		HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
//		HSSFComment comment = patriarch.createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5));
//		comment.setString(new HSSFRichTextString("我的钢铁(www.mysteel.com)"));
//		comment.setAuthor("Mysteel");
//		
//		HSSFFont font = createHeaderFont(workbook);
//		HSSFCellStyle style = createHeaderCellStyle(workbook);
//		style.setFont(font);
//		HSSFRow row = sheet.createRow(0);
//		row.setHeight((short)400);
//		
//		for (int i = 0; i < header.length; i++)
//		{
//			HSSFCell cell = row.createCell(i);
//			cell.setCellStyle(style);
//			cell.setCellValue(new HSSFRichTextString(header[i]));
//		}
//		
//		return sheet;
//	}
    
}

　　vm页面

<label class="btn btn-default" id="labelClick" for="uploadApplyItemData">导入数据</label>
	<input id="uploadApplyItemData"  type="file" name="uploadFile" accept="*.xls"  value="导入数据"/>

//异步上传excel文件
	$(‘#uploadApplyItemData‘).fileupload({
		url:‘uploading.do‘,
		dataType:‘json‘, 
		type:‘post‘,
        done: function (e, res) {
        	var dataList = res.result.data;
         	$(‘#myExcelIn‘).find(‘tr‘).remove();
         	$(dataList).each(function(i, data){
         		getContentHtml();
        		var tr = $(‘#myExcelIn‘).find(‘tr‘)[i];
        		var tds = $(tr).find("td");
        		$(tds[0]).text(data[0]);
        		$(tds[1]).text(data[1]);
         	});
        },
        fail:function (e, data){
        	var a=1;
        }
    });

　　java

package com.guilf.consumer.controller;

import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.alibaba.fastjson.JSONObject;
import com.guilf.consumer.excel.ExcelUtil;
import com.guilf.consumer.excel.SimpleExportExcelUtil;
//import com.guilf.project.entity.User;
//import com.guilf.project.service.UserService;


@Controller("excelController")
@RequestMapping("/")
public class ExcelController
{
	//@Autowired
	//private UserService userService;
	
	@RequestMapping("excel")
    public String hello(){
        return "excelInAndOut";
        
    }

	// excel导入
	@RequestMapping(value="uploading",method=RequestMethod.POST)
	@ResponseBody
	public Object uploadExcel( HttpServletRequest request, HttpServletResponse response,
			@RequestParam("uploadFile") MultipartFile uploadFile
			) throws Exception
	{
		if((null!=uploadFile)&&(!(uploadFile.getOriginalFilename().endsWith(".xls")||
				uploadFile.getOriginalFilename().endsWith(".xlsx")))){
			throw new Exception("导入文件类型错误!");
		}
		
		
		JSONObject rejson = new JSONObject();
		try
		{
			//HttpServletRequest request, HttpServletResponse response,
			List<String[]> list=ExcelUtil.readExcel(uploadFile.getInputStream(), 0, 2);
			//List<Object> ret=importAo.check(list, 3);

			rejson.put("data", list);
		} 
		catch (Exception e)
		{
			e.printStackTrace();
			throw new Exception(e.getMessage());
		} 
	
		String userAgent = request.getHeader("User-Agent");
		if (userAgent.contains("MSIE 9"))
		{
			response.setContentType("text/plain");
			return rejson.toJSONString();
		}

		return rejson;
	}

	//excel导出
	@SuppressWarnings("unchecked")
	@RequestMapping("excelOut")
	public void excelOut(HttpServletRequest request, HttpServletResponse response) throws Exception
	{
		try
		{
			Map<String, Object> map = exportOrder();
			String sheetTitle=(String) map.get("sheetTitle");
			String[] attrNames=(String[]) map.get("attrNames");
			String[] headers=(String[]) map.get("headers");
			List<Map<String, Object>> dataList = (List<Map<String, Object>>) map.get("dataList");
			SimpleExportExcelUtil.exportExcel(sheetTitle, attrNames, dataList, request, response,
					null, headers,  URLEncoder.encode("我的导出excel", "utf-8"), null);
		} catch (Exception e)
		{
			e.printStackTrace();
			throw new Exception(e.getMessage());
		}
	}
	private Map<String, Object> exportOrder() throws Exception
	{
		Map<String, Object> result = new HashMap<String, Object>();
		String sheetTitle = "我的导出excel";
		String[] attrNames = {"第一值", "第二值"};
		String[] NEXT_HEADERS = {"第一值", "第二值"};
		result.put("sheetTitle", sheetTitle);
		result.put("attrNames", attrNames);
		result.put("headers", NEXT_HEADERS);
		List<Map<String, Object>> dataList = listOrderMap();
		result.put("dataList", dataList);
		return result;
    }

	private List<Map<String, Object>> listOrderMap()
    {
    	// 查询订单信息
    	List<Map<String,Object>> listExcel = new ArrayList<Map<String,Object>>();
    	for(int i=0 ;i<7; i++)
    	{
    		Map<String, Object> paramMap = new HashMap<String, Object>();
        	paramMap.put("第一值", "dd"+i);
        	paramMap.put("第二值", "rr"+i);
        	listExcel.add(paramMap);
    	}

    	return listExcel;
    }
}

excel的导入导出

原文：https://www.cnblogs.com/guilf/p/9397225.html

踩

(0)

评论一句话评论（0）

分享档案

更多>

2021年09月23日 (328)
2021年09月24日 (313)
2021年09月17日 (191)
2021年09月15日 (369)
2021年09月16日 (411)
2021年09月13日 (439)
2021年09月11日 (398)
2021年09月12日 (393)
2021年09月10日 (160)
2021年09月08日 (222)