I. Overview
1. Apache POI is an open source library of the Apache Software Foundation, where POI provides the ability for Java programs to read and write to Microsoft Office format files.
2. Structure
HSSF-Provides the ability to read and write Microsoft Excel xls format files.
XSSF-Provides the ability to read and write Microsoft Excel OOXML xlsx format files.
HWPF-Provides the ability to read and write Microsoft Word doc format files.
HSLF-Provides the ability to read and write files in Microsoft PowerPoint format.
HDGF-Provides the ability to read files in Microsoft Visio format.
HPBF-Provides the ability to read files in Microsoft Publisher format.
HSMF-Provides the ability to read Microsoft Outlook format Archives
Second, HSSF code example
1.excel Structure
Hssfworkbook Excel Document Object Introduction
hssfsheet Excel Forms
hssfrow lines of Excel
Hssfcell Excel's lattice unit
Hssffont Excel Fonts
hssfname name
Hssfdataformat Date Format
Add the following 2 items to the poi1.7:
Hssfheader sheet Head
hssffooter Sheet Tail
Hssfcellstyle cell style
secondary operations include
Hssfdateutil Date
Hssfprintsetup Printing
hssferrorconstants error message Table