java获取excel文件中的数据和图片

package xxx;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.formula.functions.T;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.lang.reflect.Field;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;

public class AnalysiUtil {
   

    //传递参数例子如下，imgNames是图片属性名字按顺序组成的集合,rows时有用的行，lists是某行中有用的列的集合，排序和rows中对应，names是实体类中每个单元格数据对应的属性名称
    //遇到按行列取的数据可以修改下面的for循环
    //int[] rows = {0,1,3,5};//上方有用的行数
    //List<List<Integer>> lists = Arrays.asList(Arrays.asList(0),Arrays.asList(1,8),Arrays.asList(3),Arrays.asList(1,4,7,11));//和rows对应，每行要取列的数据
    //List<List<String>> names = Arrays.asList(Arrays.asList("name"),Arrays.asList("engineeringName","engineeringPosition"),Arrays.asList("designParameters"),
    //                           Arrays.asList("constructionDate","concreteSupplier","concreteVolume","concreteStrength"));//每一格对应的实体类名称
    //获取阿里云上的excel文件
    //URL httpurl = new URL("url地址");
    //URLConnection urlConnection = httpurl.openConnection();
    //InputStream in = urlConnection.getInputStream();
    //XSSFWorkbook workbook = new XSSFWorkbook(in); 2003用HSSFWorkbook
    public static <T> boolean getExeclData(T Parame, XSSFWorkbook workbook, int[] rows, List<List<Integer>> lists, List<List<String>> names, List<String> imgNames){
   
        try{
   
            Row row= null;
            Field f = null;
            Cell cell = null;//获取到单元格内数据
            //建立文件，如果传递的是MultipartFile，则
            //Workbook work