Opening Existing Excel sheet in Java using Apache POI
Apache POI is a powerful API by which one can read, write and modify any Microsoft document like powerpoint, world, or excel.
Apache POI have different classes and method to work upon different MS Office Document.
- POIFS –
It’s Stand for “Poor Obfuscation Implementation File System”. This component is the basic factor of all other POI elements. It is used to read different files explicitly.
It’s Stand for “Horrible Spreadsheet Format”. It is used to read and write xls format of MS-Excel files.
It’s Stand for “XML Spreadsheet Format”. It is used for xlsx file format of MS-Excel.
It’s Stand for “Horrible Property Set Format”. It is used to extract property sets of the MS-Office files.
It’s Stand for “Horrible Word Processor Format”. It is used to read and write doc extension files of MS-Word.
It’s Stand for “XML Word Processor Format”. It is used to read and write docx extension files of MS-Word.
It’s Stand for “Horrible Slide Layout Format”. It is used for read, create, and edit PowerPoint presentations.
It’s Stand for “Horrible Diagram Format”. It contains classes and methods for MS-Visio binary files.
It’s Stand for “Horrible PuBlisher Format”. It is used to read and write MS-Publisher files.
Steps to Open Existing Excel Sheet in Java, in eclipse
- Create a JAVA Maven project
- Add dependency in pom.xml file
- Create a class in javaResource folder
- Run the code as java application
File location in eclipse
Attention reader! Don’t stop learning now. Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more, please refer Complete Interview Preparation Course.