通过url（http://...）读excel文件

public static List<String> readExcel(URL url) throws IOException {
    // 返回HttpURLConnection 对象
    URLConnection conn = url.openConnection();
    BufferedInputStream bis = null;
    bis = new BufferedInputStream(conn.getInputStream());
    //System.out.println("file type:" + HttpURLConnection.guessContentTypeFromStream(bis));    //判断格式是否为excel文件
    //url.getPath得到文件的路径
    Workbook workbook = null;
    if (url.getPath().endsWith("xls")) {
        workbook = new HSSFWorkbook(bis);
    } else if (url.getPath().endsWith("xlsx")) {
        workbook = new XSSFWorkbook(bis);
    } else {
        System.out.println("文件格式错误,请检查文件格式！");
    }
    //workbook.getNumberOfSheets() 总共多少页
    //sheet.getPhysicalNumberOfRows() 总共有多少行

    //第一页
    Sheet sheet = workbook.getSheetAt(0);
    //第一行
    Row row = sheet.getRow(0);
    //第一行第一个
    int start = row.getFirstCellNum();
    //第一行最后一个
    int end = row.getLastCellNum();
    //System.out.println(start + "------" + end);
    List<String> list = new ArrayList<>();
    for (int i = start; i < end; i++) {
        list.add(row.getCell(i).getStringCellValue());
    }

    workbook.close();
    bis.close();
    return list;
}

 

如有侵权，请通知博主删除，谢谢！