TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Apache POI

Apache POI Components

Overview

The Apache POI Components support different file formats of the MS Documents. The binary formats with file extensions such as .doc, .xls, .ppt. The new version of the API also supports  MS Office OOXML file formats such as .xlsx, .docx, .pptx.

Excel -> HSSF & XSSF

Word -> HWPF & XWPF

PowerPoint -> HSLF & XSLF

Visio -> HDGF & XDGF

Outlook -> HSMF

Publisher -> HPBF

 

Apache POI Components

Apache POI Components

Apache POI Jar contains several Java classes, interfaces that allows the programmer to interact with Microsoft Documents. Some of the components are as follows:

  • POIFS
  • HSSF
  • XSSF
  • HWPF
  • XWPF
  • HDGF
  • XDGF , etc

 

Apache POI API

POIFS

POIFS stands for Poor Obfuscation Implementation File System. This is the basic for all other components. We can find the classes and interfaces under the package:

package org.apache.poi.poifs.*;

HSSF & XSSF

HSSF stands for Horrible Spreadsheet Format. It is used to read and write .xls format Excel files. XSSF stands for XML Spreadsheet Format which is used read and write .xlsx files. 

Apache POI supports all the basic features of Excel sheets. We can use this library for Excel Automation.

HWPF & XWPF

HSSF stands for Horrible Word Processor Format. It is used to read and write .doc format files. XSSF stands for XML Word Processor Format which is used read and write .docx files. 

—

Apache POI Tutorials:

https://www.testingdocs.com/apache-poi-tutorials/

More Information on Apache POI API:

https://poi.apache.org/

Related Posts

ApachePoi_ReadExcelRow

Apache POI /

Read Excel File using Apache POI

Configure Build Path

Apache POI /

Add Apache POI To Java Project

Apache POI Download

Apache POI /

Download Apache POI

Update Excel File

Apache POI /

Update Excel File using Apache POI

Excel_Sheet_Movies_Names

Apache POI /

Getting number of Rows count from an Excel sheet

› Apache POI Workbook Interface

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version