java读写excel之POI篇—003

最新推荐文章于 2024-03-17 13:43:49 发布

转载最新推荐文章于 2024-03-17 13:43:49 发布 · 103 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/hxsg/blog/509483

文章标签：

#java

本文详细解析了为什么80%的码农难以晋升为架构师，并通过实例展示了如何使用WorkbookFactory和POIFSFileSystem打开Excel文件，以及如何处理加密的Workbook。文章深入探讨了代码实现细节，旨在帮助开发者理解和掌握关键技能。

为什么80%的码农都做不了架构师？>>>

使用WorkbookFactory打开Workbook

@Test
    public void openWorkbookByWorkbookFactory(){
        FileInputStream fileInputStream = null;
        Workbook workbook = null;
        try {
            fileInputStream = new FileInputStream("D:\\test.xls");
            workbook = WorkbookFactory.create(fileInputStream);
            //获取第一个sheet Name
            System.out.println(workbook.getSheetName(0));
            //获取sheet总数
            System.out.println(workbook.getNumberOfSheets());
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (InvalidFormatException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                fileInputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

二，使用POIFSFileSystem打开Workbook

@Test
    public void openWorkbookByPOIFSFileSystem(){
        FileInputStream fileInputStream = null;
        Workbook workbook = null;
        try {
            fileInputStream = new FileInputStream("D:\\test.xls");
            POIFSFileSystem poifsFileSystem = new POIFSFileSystem(fileInputStream);
            workbook = new HSSFWorkbook(poifsFileSystem);
            //制定sheet Name还回sheet index
            System.out.println(workbook.getSheetIndex("三"));
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                fileInputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        
    }

三，打开加密的Workbook(读加密)

@Test
    public void operWorkbookOfSN(){
        try {
            FileInputStream fileInputStream = new FileInputStream("D:\\test.xls");
            BufferedInputStream bufferedInputStream = new BufferedInputStream(fileInputStream);
            POIFSFileSystem poifsFileSystem = new POIFSFileSystem(bufferedInputStream);
            Biff8EncryptionKey.setCurrentUserPassword("password");
            HSSFWorkbook hssfWorkbook = new HSSFWorkbook(poifsFileSystem);
            System.out.println("====================EncryptedWorkbook====================");  
            System.out.println("Number of Sheets:" + hssfWorkbook.getNumberOfSheets());  
            System.out.println("Sheet0's name:" + hssfWorkbook.getSheetName(0));
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

转载于:https://my.oschina.net/hxsg/blog/509483