POI使用详解（Maven依赖、常用类介绍）

川长思鸟来 2023-01-23 12:56 17阅读 0赞

## 1 Maven依赖 ##

<dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi</artifactId>
                <version>4.1.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>4.1.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml-schemas</artifactId>
                <version>4.1.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-scratchpad</artifactId>
                <version>4.1.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>ooxml-schemas</artifactId>
                <version>1.4</version>
            </dependency>

## 2 常用类介绍 ##

<table style="width:700px;"> 
 <thead> 
  <tr> 
   <th colspan="3">HSSF（03版Excel文档，提供读写Microsoft Excel XLS格式档案的功能。）</th> 
  </tr> 
  <tr> 
   <th>序号</th> 
   <th>类名</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>1</td> 
   <td>HSSFWorkbook</td> 
   <td>Excel的文档对象</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>HSSFSheet</td> 
   <td>Excel的表单</td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>HSSFRow</td> 
   <td>Excel的行</td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>HSSFCell</td> 
   <td>Excel的单元格</td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>HSSFFont</td> 
   <td>Excel字体</td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>HSSFDataFormat</td> 
   <td>单元格的日期格式</td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>HSSFHeader</td> 
   <td>Excel文档Sheet的页眉</td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>HSSFFooter</td> 
   <td>Excel文档Sheet的页脚</td> 
  </tr> 
  <tr> 
   <td>9</td> 
   <td>HSSFCellStyle</td> 
   <td>单元格样式</td> 
  </tr> 
  <tr> 
   <td>10</td> 
   <td>HSSFDateUtil</td> 
   <td>日期</td> 
  </tr> 
  <tr> 
   <td>11</td> 
   <td>HSSFPrintSetup</td> 
   <td>打印</td> 
  </tr> 
  <tr> 
   <th colspan="3">XSSF（07版Excel文档，提供读写Microsoft Excel OOXML XLSX格式档案的功能）</th> 
  </tr> 
  <tr> 
   <th>序号</th> 
   <th>类名</th> 
   <th>说明</th> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td>XSSFWorkbook</td> 
   <td>Excel的文档对象</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>XSSFSheet</td> 
   <td>Excel的表单</td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>XSSFRow</td> 
   <td>Excel的行</td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>XSSFCell</td> 
   <td>Excel的单元格</td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>XSSFFont</td> 
   <td>Excel字体</td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>XSSFDataFormat</td> 
   <td>单元格的日期格式</td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>XSSFCellStyle</td> 
   <td>单元格样式</td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>XSSFPrintSetup</td> 
   <td>打印</td> 
  </tr> 
  <tr> 
   <th colspan="3">HWPF（03版Word文档，HWPF提供读写Microsoft Word DOC格式档案的功能）</th> 
  </tr> 
  <tr> 
   <th>序号</th> 
   <th>类名</th> 
   <th>说明</th> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td>HWPFDocument</td> 
   <td>文档对象</td> 
  </tr> 
  <tr> 
   <th colspan="3">XWPF（07版Word文档，XWPF提供读写Microsoft Word DOCX格式档案的功能）</th> 
  </tr> 
  <tr> 
   <th>序号</th> 
   <th>类名</th> 
   <th>说明</th> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td>XWPFDocument</td> 
   <td>文档对象</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>XWPFParagraph</td> 
   <td>段落对象</td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>XWPFRun</td> 
   <td>相同样式的文本对象</td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>XWPFTable</td> 
   <td>表格对象</td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>XWPFTableRow</td> 
   <td>表格中的行对象</td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>XWPFTableCell</td> 
   <td>表格中的单元格对象</td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>XWPFHeader</td> 
   <td>页眉对象</td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>XWPFFooter</td> 
   <td>页脚对象</td> 
  </tr> 
  <tr> 
   <td>9</td> 
   <td>XWPFComment</td> 
   <td>批注对象</td> 
  </tr> 
  <tr> 
   <td>10</td> 
   <td>XWPFChart</td> 
   <td>图表对象</td> 
  </tr> 
 </tbody> 
</table>