the HSLF project page.
HDGF for Visio file operations: In addition POI provides a pure Java interface for HDGF document operations in the Microsoft Visio97 (-2003) file format. It currently only supports read operations, at a very low level, and only supports simple text extraction. For more information, see the HDGF project page.
HPSF Document properties: HPS
Conventions) using OPENXML4J. For each existing MS Office module component, an attempt was made to provide a common high-level Java API to the OLE2 and OOXML document formats. Excel (SS=HSSF+XSSF)Word (HWPF+XWPF), PowerPoint (HSLF+XSLF), Outlook (HSMF), Visio (HDGF), TNEF (HMEF), and Publisher (HPBF). The project provides this functionality as much as possible in collaboration with other projects. For example: Cocoon provides serialization of HSSF, w
The Apache POI is an open source library of the Apache Software Foundation to help Java programs read and write to Microsoft Office format files. POI provides the following types for parsing Microsoft Office format files:
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
following for the specific jar package you should use:Component MapThe Apache POI distribution consists for many document file formats. This are provided in several Jar files. Not all of the Jars is needed for every format. The following tables show the relationships between POI components, Maven repository tags, and the project ' s Jar files.
Component
Application Type
Maven Artifactid
Notes
Poifs
OLE2 Filesystem
Poi
Required to work wi
Apache POI distribution consists for many document file formats. This are provided in several Jar files. Not all of the Jars is needed for every format. The following tables show the relationships between POI components, Maven repository tags, and the project ' s Jar files.
Component
Application Type
Maven Artifactid
Notes
Poifs
OLE2 Filesystem
Poi
Required to work with ole2/poifs based files
Hpsf
OLE2 Property Sets
Recently done a small project, in the middle of a link is to save the data in the collection to a local Excel file, the local Excel file read into the collection
POI 'To put it simply: POI is provided by Apache and provides read and write support for documents in Microsoft Office format!
HSSF-provides the ability to read and write files in Microsoft Excel format.
XSSF-provides the ability to read and write Microsoft Excel ooxml format files.
HWPF-provides the ability to rea
I. Overview1. 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. StructureHSSF-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
Hssf-provides the ability to read and write files in Microsoft Excel XLS format.
Xssf-read and write Microsoft ExcelOoxmlThe XLSX format file function.
Hwpf-provides the ability to read and write Microsoft Word doc files.
Hslf-supports reading and writing Microsoft PowerPoint files.
Hdgf-provides the ability to read files in Microsoft Visio format.
Hpbf-supports reading files in Microsoft Publisher format.
HSMF-provides the ability to read
format): It is used for ms-excel in the xlsx file format.
HPSF (horrible property formatting): It is used to extract Ms-office file property settings.
HWPF (horrible word processor format) : It is a file that is used to read and write Ms-word document extensions. Span style= "line-height:0px;" >
XWPF (XML word Processor format): It is a file used to read and write Ms-word docx extensions.
HSLF (Scary Slide layout format): It is used to read, create, and edit PowerP
Apache POI is an open source Java project that reads and writes Microsoft OLE2 component documents such as Excel, Word, and so on. Currently the POI has a ruby version.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 DOC97 format files.
XWPF-provides the ability to read and write Microsoft Word DOC20
POI Excel and poiexcel
I. POI Overview
Apache POI is an open-source library of the Apache Software Foundation. POI provides APIs for Java programs to read and write Microsoft Office files.Structure:
HSSF-provides the ability to read and write Microsoft Excel files.
XSSF-provides the ability to read and write files in Microsoft Excel OOXML format.
HWPF-read and write Microsoft Word files.
HSLF-supports reading and writing Microsoft PowerPoint files.
the ability to read and write files in Microsoft Excel OOXML format. The extension name is .xlsx.
HWPF-read and write Microsoft Word files.
HSLF-supports reading and writing Microsoft PowerPoint files.
HDGF-read and write Microsoft Visio files.
Tutorial:
Http://www.tuicool.com/sites/JjAjq2? Pn = 0
Open Source Address: https://github.com/tonyqus/npoi/
NPOI. Examples many Examples are based on Version 1.0
An encapsulation library of ExcelReport Based
Excel OOXML format.
HWPF-provides the ability to read and write Microsoft Word files.
HSLF-provides the ability to read and write Microsoft PowerPoint files.
HDGF-provides the ability to read and write Microsoft Visio files.
This document describes how to use POI to read and write Excel.
The above sentence is the main sentence of this article. If you can solve your problem, please take a closer look.
The project uses the latest poi-3.14-20160307.
POI-Microsoft Office read/write support, npoi read/write word
I recently made a small project. one stage is to save the data in the set to a local Excel file and read the local Excel file to the set.
Poi'
To put it simply, POI is provided by apache and supports reading and writing documents in Microsoft Office format!
HSSF-provides the ability to read and write Microsoft Excel files.
XSSF-provides the ability to read and write files in Microsoft Excel OOXML format.
HWPF-read and write Micros
file systems): This component is a fundamental factor for all other POI components. It is used to explicitly read different files.
HSSF (horrible spreadsheet format): It is used to read and write the XLS format of the Ms-excel file.
XSSF (XML format): It is used for ms-excel in the xlsx file format.
HPSF (horrible property formatting): It is used to extract Ms-office file property settings.
HWPF (terrible word processor format): It is a file used to read and write Ms-word's docu
Apache's POI project can be used to work with MS Office documents, and CodePlex has a. NET version of it. The POI project creates and maintains various Java APIs that operate on Ooxml and OLE2 file formats. Most MS Office is in OLE2 format. POI HSMF Subproject to support Outlook, support Visio by HDGF subprojects, and support publisher through HPBF subprojects.
Use POI to extract a simple example of Word:
To introduce both the Poi-3.7.jat and POI-SC
1.Apache POI IntroductionApache POI is the Apache Software Foundation's open source function library, the official name is: Apache poi-the Java API for Microsoft Documents,poi provides APIs to Java programs for Microsoft The ability to read and write office-formatted documents. NET developers can use Npoi (POI for. net) to access the functionality of the POI.
2.Apache POI Structure
HSSF-provides the ability to read and write Microsoft Excel xls format files.
XSSF-provides the ability to read a
Read CatalogueStart 1.POI structure with common class 2.Excel basic operation 3.Excel Cell operations 4. Use the Excel Formula 5. Use the Graphics 6.Excel table to operate the 7.Excel row and column operation 8.Excel Other functions 9.POI basic operations on word back to top1.POI structure and common class (1) POI IntroductionApache POI is an open source project for the Apache Software Foundation, where POI provides APIs to Java programs to read and write to Microsoft Office format archives. NET
From official website:
Component
Application Type
Maven Artifactid
Notes
Poifs
OLE2 Filesystem
Poi
Required to work with ole2/poifs based files
Hpsf
OLE2 Property Sets
Poi
Hssf
Excel XLS
Poi
For HSSF only, if common SS are needed see below
Hslf
PowerPoint PPT
Poi-scratchpad
Hwpf
Word DOC
Poi-scratchpad
(File System implementation with poor obfuscation technology ):This component is the basic factor for all other POI components. It is used to explicitly read different files.
HSSF (terrible spreadsheet format ):It is used to read and write MS-Excel files in the xls format.
XSSF (XML format ):It is used in the XLSX file format in MS-Excel.
HPSF (terrible attribute setting format ):It is used to extract attributes of MS-Office files.
HWPF (terrible Word Processor Format ):It is used to read a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.