POI简单介绍

一、概述

apache的POI，是Apache软件基金会的开放源码函式库，POI提供API给Java程序对Microsoft Office格式档案读和写的功能。

二、使用

官网下载压缩包，解压。导入poi的核心包到项目工程，一般是名字最短的那个。

例子

public class POITest {



         @Test

         public void test1() throws FileNotFoundException, IOException {

                   String filePath = "C:\\Users\\Administrator\\Desktop\\截图\\test1.xls";

                   HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(new File(filePath)));

                   HSSFSheet hssfSheet = workbook.getSheetAt(0);

                   for (Row row : hssfSheet) {

                            for (Cell cell : row) {

                                     String value = cell.getStringCellValue();

                                     System.out.print(value + "\t");

                            }

                            System.out.println();

                   }

         }

}