spring mvc中导入导出excel

POI介绍

 Apache POI是Apache软件基金会的开源项目，POI提供API给Java程序对Microsoft Office格式档案读和写的功能

导入jar包：poi-4.1.2.jar，xwork-core-2.3.15.3.jar

1、写excel

package excel;
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.ss.usermodel.CellType;

import java.io.File;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;

public class ExcelTest {
   

    public static void main(String[] args)  throws  Exception{
   
        HSSFWorkbook workbook =new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("服务报表");
        HSSFRow row = sheet.createRow(0);

        HSSFCell cell = row.createCell(0);
        cell.setCellType(CellType.STRING);
        cell.setCellValue("类型");

        HSSFCell cell1 = row.createCell(