URL解析Excel工具类

解析网络上的的Excel表格，解析表格数据插入到数据库之中。这个工具类中的返回信息包含了自己公司封装的返回工具，使用时替换即可

package cn.kingcar.cms.util.excel;
import cn.kingcar.cms.enums.error.ErrorEnum;
import cn.kingcar.cms.vo.csr.CsrExcelImportVO;
import cn.kingcar.framework.domain.ResultDTO;
import cn.kingcar.framework.utils.crud.ResultTool;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
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.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.net.URL;
import java.net.URLConnection;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Pattern;

/**
 * @description:
 * @author: fengqianli
 **/
public class CsrExcelImportUtil {
   

    // 解析Excel,读取内容,path Excel路径
    public static ResultDTO<List<CsrExcelImportVO>> parseExcel(String path) throws IOException {
   

        URL url = new URL(path);
        URLConnection conn = (url).openConnection();
        BufferedInputStream bis = null;
        bis = new BufferedInputStream(conn.getInputStream());
        ResultDTO<List<CsrExcelImportVO>> list=null;
        Workbook workbook = null;
        if (url.getPath().endsWi