This is the back-end small class of the Xiuzhen Academy. Each shared article is from

[background introduction] [knowledge analysis] [common problems] [solutions] [coding practice] [extended thinking] [more discussion] [References]

Eight aspects of in-depth analysis of back-end knowledge / skills. This article shares:

[basic use of POI]

1. Background introduction

Apache POI is an open source project of the Apache Software Foundation. POI provides APIs for Java programs to read and write files in Microsoft Office format Net developers can use npoi (POI for. Net) to access the functions of Microsoft office documents.

2. Knowledge analysis

POI structure description

Package name Description

HSSF provides the function of reading and writing files in Microsoft Excel XLS format.

Xssf provides the ability to read and write Microsoft Excel OOXML xlsx format files.

Hwpf provides the ability to read and write files in Microsoft Word Doc format.

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 files in Microsoft Outlook format.

Description of common API classes of HSSF package in poi

Class name Description

Document object for hssfworkbookexcel

Form for hssfsheetexcel

Rows in hssfroweexcel

Grid cell of hssfcellexcel

Hssffontexcel font

Hssfdataformat date format for grid cells

Header of hssfheaderexcel document sheet

Footer of hssffooterexcel document sheet

Hssfcellstyle grid cell style

Hssfdateutil date

Hssfprintsetup print

Hssferrorconstants error message table

3. Frequently asked questions

How to use POI when new requirements are put forward

4. Solutions

Learn to consult third-party APIs

5. Coding practice

undefined_ Tencent video

6. Expand thinking

How to use styles

7. References

8. More discussion

Video link:

Ppt link:

That's all for today's sharing. You are welcome to like, forward, leave messages and make bricks~

Skill tree It Academy

"We believe that everyone can become an engineer. From now on, find a senior brother to introduce you, control your learning rhythm, and stop being confused on the way to learning.".

Here is the skill tree In it academy, thousands of senior brothers have found their own learning route here. Learning is transparent and growth is visible. Senior brothers have 1-to-1 free guidance. Come and study with me~

My invitation code:, or you can click this link directly:

Author: sevn_ Dbb9 link: https://www.jianshu.com/p/fa9b067206ca Source: the copyright of Jianshu Jianshu belongs to the author. Please contact the author for authorization and indicate the source for any form of reprint.

For more information, you can join the IT communication group 565734203 to discuss and communicate with you

Here is the skill tree · it Academy: a gathering place for beginners to switch to the Internet