Java POI Read Word fileApache 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.1. Read the jar packages required for Word 2003 and Word 2007Word files that read version 2003 (. doc) are relatively simple and require only Poi-3.5-beta6-20090622.jar and Poi-scratchpad-3.5-beta6-20090622.jar two jar packages, while 2007 version (. docx) on the trouble, I said this trouble is not when
The previous two days summed up some examples of Excel and CSV combined with testng for data-driven testing, for Excel to store testcase and keywords How to parse, also do a corresponding summary, I hope in the study of the road forward, there is no place, I hope we point out common progress together.
The use of the POI to Excel parsing, the need for the jar package file:
Poi-3.11-20141221.jar
Poi-ooxml-3.11-20141221.jar
Poi-
Java_poi ms-excel2003 (extension. xls) upgrade to ms-excel2007 and later (extension. xlsx) Technical Process OverviewEric.zhang (Nickname: No. 7th of the Traveler)Date: November 11, 2015A. PrefacePOI technology is the Apache Foundation's Open Source Library, which provides APIs to Java programs to read and write to Microsoft Office format archives. Detailed explanation see Baidu Encyclopedia http://baike.baidu.com/link?url=CaOC3cXmdxU-2fjV-VfSZjoKvrKEpONcQiWypy0HwbpBTHZNLLrVKFL6BnOR-mQ1_ Xpbunl
The GNOME situation is a bit bad-Linux general technology-Linux technology and application information. The following is a detailed description. On the issue of OOXML, both Richard Stallman and ITWire, chairman of the Free Software Foundation, praised KDE and KOffice developers for sticking to the Principles and uniting against OOXML. They are also seriously concerned about the GNOME Foundation, because it
Recently in the system to the customer, the user asked for the need to be able to import Word files, now Microsoft Word has several versions 97, 2003, 2007, the three versions of the format of data storage is quite different, and now 97 has basically exited the market, Few people use this version, so in our system only consider 2003 version and 2007 version, because we only need to be able to read word text content, where the text style, pictures and other information can be ignored, and do not
provides many practical functions and can be used for development of other read/write file format projects.
NPOI. OOXML. dll npoi. XSSF Excel 2007 (xlsx) format read/write Library
NPOI. OOXML. dll npoi. XWPF Word 2007 (docx) format read/write Library
NPOI. OpenXml4Net. dll npoi. OpenXml4Net OpenXml underlying zip package read/write Library
NPOI. OpenXmlFormats. dll npoi. OpenXmlFormats Microsoft Office Ope
Sometimes we need to enter a lot of data in the project, Excel operations1: First you need to import a rack package into your project:Jxl.jar,Poi-3.6-20091214.jarPoi-3.8-beta5-20111217.jarPoi-examples-3.6-20091214.jarPoi-examples-3.8-beta5-20111217.jarPoi-excelant-3.8-beta5-20111217.jarPoi-ooxml-3.6-20091214.jarPoi-ooxml-3.8-beta5-20111217.jarPoi-ooxml-schemas-3.
Poi reads the word content, and poi reads the word content
Pache POI is an open source library of the Apache Software Foundation. POI provides APIs for Java programs to read and write Microsoft Office files.
1. Read the jar packages required by word 2003 and word 2007.
Reading the 2003 documents (.doc) word file is relatively simple, just need poi-3.5-beta6-20090622.jar and poi-scratchpad-3.5-beta6-20090622.jar two jar packages, and 2007 documents (.docx) is too much trouble, the trouble I menti
this trouble is not when we write code trouble, is to import the jar package compared more, there are the following 7:1. Openxml4j-bin-beta.jar2. Poi-3.5-beta6-20090622.jar3. Poi-ooxml-3.5-beta6-20090622.jar4. Dom4j-1.6.1.jar5. Geronimo-stax-api_1.0_spec-1.0.jar6. Ooxml-schemas-1.0.jar7. Xmlbeans-2.3.0.jar4-7 of these are the jar packages that Poi-ooxml-3.5-beta
The Apache POI is an open source library of the Apache Software Foundation, and POI provides the ability for the API to read and write to Microsoft Office format files in Java programs.
1. Read the jar packs that Word 2003 and Word 2007 need
A Word file that reads Version 2003 (. doc) is relatively simple, requiring only Poi-3.5-beta6-20090622.jar and Poi-scratchpad-3.5-beta6-20090622.jar two jar packages, and 2007 version (. docx) on more trouble, I said this trouble is not the time we write
implement a more complex scenario, consider using POI, but if you want to generate some big data, consider using JXL, or CSV is a good choice, but CSV is not really excelThis passage comes from http://blog.csdn.net/lilinandlilin/article/details/24098699.This clearly distinguishes between the two, which is only the beginning, not the content to be shared today:Here's what to share today: POI read ExcelFirst jar package is not small, in my network can be down to the connection:Http://pan.baidu.co
In the project open, we often need to use Excel to import the exported data, and POI technology is a choice to achieve our needs.
POI supports all versions of Office
POI Full name poorobfuscation implementation, literally "poor fuzzy implementation", uses the POI interface to manipulate the read and write capabilities of Microsoft Office suite tools through Java. Official website: http://poi.apache.org,
Download jar packs and source packs from the website.
Introduction to Jar Packs : ① for on
Yesterday, the beta version of 3.5 was already supported by the 2007 Open XML Format (DOCX,PPTX,XLSX) for POI.
Need to join Poi-ooxml-3.5-beta6-xxxx.jar. But the Poi-ooxml-3.5-beta6-xxxx.jar package requires several packages under the Ooxml-lib directory to run.
The code is as follows
Import java.util.ArrayList; Import Java.io.File; Import Java.io.FileInputStr
Article title: open-source community debate Topic 2: Standard organization that leads to a different path. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
[Editor's note] how can we develop a true technical standard? Is it necessary for the International Organization for Standardization to repeatedly check, debate, and vote? What if it is only an Rubber stamp
Recently, a "big debate" has been held on electronic document standards. The question is: can OOXML become an international standard. The core issue of document standards is the so-called "document format", which is a recognized specification for storing electronic information (text description files ). In a computer operating system, the use of computer programs (programming languages and related algorithms) to achieve this specification is called a
=" Wkiom1eq2mszayesaadxrtx5dbu411.png "/>Unzip the downloaded Poi-bin-3.14.zip file650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/85/A4/wKiom1eq2VrhnJy5AAB1rgP88k0016.png "title=" Poi_ Jar.png "alt=" Wkiom1eq2vrhnjy5aab1rgp88k0016.png "/>Import the required jar packages into the project
Version
Jar Package
Operations 2003 and previous versions of Excel
Poi-3.14-20160307.jar
Operate on 2007 and later versions
Poi-
Introduction to POI and Excel There are two main toolkits for working with Excel in Java: JXL and POI. JXL can only operate Excel, with the. xls suffix of Excel. The POI can operate in Excel 95 and later versions of Excel, with the suffix. xls (version 03) and. xlsx (07) formats.So, if you need to import and export excel in your project, you might need a poi. Learn some of the concepts of Excel before you explain it, which is also the basis for POI operations. An Excel file is a workbook work
-3.10.1-20140818.jar (if the requirement is 03, the following two jar packages do not need to be introduced)Poi-ooxml-3.10.1-20140818.jar,Poi-ooxml-schemas-3.10.1-20140818.jar, and copy the Xmlbeans-2.6.0.jar,dom4j-1.6.1.jar in the Ooxml-lib directory.There are several main objects in the POI package that correspond to several objects in Excel:(more than 07 of th
Perfectly compatible with excel2003 and excel2007 reads, all Excel types are processed, depending on the package as follows:Poi-3.10-fnal.jarPoi-ooxml-3.10-fnal.jarPoi-ooxml-schemas-3.10-fnal.jarXmlbeans-2.6.0.jarDom4j-1.6.1.jarNot much to say, directly on the code.ImportJava.io.FileInputStream;Importjava.io.IOException;ImportJava.io.InputStream;ImportJava.io.PushbackInputStream;ImportJava.text.SimpleDateFo
to directly open the OOXML format file of Office 2007, but you cannot save the file as OOXML, because some of the existing OOXML files cannot be converted correctly. For example, if a file contains multiple verbal characters (such as English and Japanese) in the same line, the line spacing will be damaged during import. However, if you save the file as a Word 20
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.