java导入xls和xlsx格式

来源:互联网 发布:网络rtt 编辑:程序博客网 时间:2024/04/28 01:21
            InputStream inputStream = new BufferedInputStream(new FileInputStream(file));             Sheet sheet = null;            //读写xls和xlsx格式时,HSSFWorkbook针对xls,XSSFWorkbook针对xlsx            if (POIFSFileSystem.hasPOIFSHeader(inputStream)) {                HSSFWorkbook workBook = new HSSFWorkbook(new BufferedInputStream(inputStream));                sheet = workBook.getSheetAt(0);            }else{                XSSFWorkbook workBook = new XSSFWorkbook(new BufferedInputStream(inputStream));                sheet = workBook.getSheetAt(0);            }


 

0 0
原创粉丝点击