使用Java解析和生成Excel
概述
Excel是我们平时工作中比较常用的用于存储二维表数据的,JAVA也可以直接对Excel进行操作,分别有jxl和poi,2种方式。
HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.
从官方文档中了解到:POI提供的HSSF包用于操作 Excel '97(-2007)的.xls文件,而XSSF包则用于操作Excel2007之后的.xslx文件。
本片文章主要参考poi官网:http://poi.apache.org/index.html
代码 要使用poi,必须引入poi的jar包,maven依赖如下:
[Java] 纯文本查看 复制代码
1 <dependency>
2 <groupId>org.apache.poi</groupId>
3 <artifactId>poi</artifactId>
4 <version> 3.14 </version>
5 </dependency>
6
7 <dependency>
8 <groupId>org.apache.poi</groupId>
9 <artifactId>poi-ooxml</artifactId>
10 <version> 3.14 </version>
11 </dependency>
12 <dependency>
13 <groupId>org.apache.poi</groupId>
14 <artifactId>poi-ooxml-schemas</artifactId>
15 <version> 3.14 </version>
16 </dependency>
|
使用poi创建execl文件
[Java] 纯文本查看 复制代码
1 package test.hd.poi;
2
3 import java.io.FileOutputStream;
4 import java.io.IOException;
5 import java.util.Date;
6
7 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
8 import org.apache.poi.xssf.usermodel.XSSFWorkbook;
9 import org.apache.poi.ss.usermodel.Cell;
10 import org.apache.poi.ss.usermodel.CellStyle;
11 import org.apache.poi.ss.usermodel.ClientAnchor;
12 import org.apache.poi.ss.usermodel.Comment;
13 import org.apache.poi.ss.usermodel.CreationHelper;
14 import org.apache.poi.ss.usermodel.DataFormat;
15 import org.apache.poi.ss.usermodel.Drawing;
16 import org.apache.poi.ss.usermodel.Font;
17 import org.apache.poi.ss.usermodel.RichTextString;
18 import org.apache.poi.ss.usermodel.Row;
19 import org.apache.poi.ss.usermodel.Sheet;
20 import org.apache.poi.ss.usermodel.Workbook;
21 import org.apache.poi.ss.util.CellRangeAddress;
22
23 public class CreateExcel {
24
25 public static void main(String[] args) throws IOException, InterruptedException {
26 Workbook[] wbs = new Workbook[] { new HSSFWorkbook(), new XSSFWorkbook() };
27 for ( int i = 0 ; i < wbs.length; i++) {
|