XML security you don't know0x00 XML Introduction
XML eXtensible Markup Language, designed for data transmission and storage. Its diverse forms
For example:
1. document Format (OOXML, ODF, PDF, RSS, docx ...) 2. image Format (SVG, EXIF Headers ,...) 3. configuration file (custom name, usually. xml) 4. network Protocol (WebDAV, CalDAV, XMLRPC, SOAP, REST, XMPP, SAML, XACML ,...)
Some features designed in XML, such as XML schemas (following XML Schemas
XML security-XML attack methods you don't know
The XML eXtensible Markup Language is designed to transmit and store data in various forms. Some features designed in XML, such as XML schemas (following XML Schemas specifications) and documents type definitions (DTDs), are both sources of security issues. Even though it was publicly discussed for the last decade, a large number of software still died in XML attacks.
0x00 XML Introduction
XML eXtensible Markup Language, designed for data transmissi
Descriptionhi Jan,I has noticed that, I set a column width there is aDiscrepancy between the width that I set in code and whatExcel reports.From the code below, Excel reports the width of be 11.27.Excel reports the height to being exactly what I set.Osheet.column (1). Width = 12.0d;Osheet.row (1). Height = 27.75d;Duardoclosed Nov at 5:00pm byThis is the OOXML value. You can has a look at it if you rename your document *.zip, extract it and look in the
A colleague asked me to parse 0.6 million pieces of data to an Excel table, remove the specified data, and write the data in a decisive manner. After half of the data, he didn't need it anymore.
Jar package
Commons-codec-1.5.jarcommons-logging-1.1.jardom4j-1.6.1.jarjunit-3.8.1.jarlog4j-1.2.13.jarpoi-3.9-20121203.jarpoi-examples-3.9-20121203.jarpoi-excelant-3.9-20121203.jarpoi-ooxml-3.9-20121203.jarpoi-scratchpad-3.9-20121203.jarstax-api-1.0.1.jarx
addition to this, there are also some serious library examples, such as aspose.pdf (class library for operating PDF files), aspose. Flash (class library for operating Flash files), and aspose. Report (class library for operating reports). If you are interested, you can go to the official website for research. These class libraries contain two languages: JAVA . net. this section mainly introduces aspose. words. net . Aspose. Words for. NET is very powerful. You can use this to generate WOR
Poi is an API provided by Apache for processing files such as Excel.
1. Download the JAR File
Http://poi.apache.org/download.html#POI-3.7
The current stable version is 3.7.
Development and download in window:Poi-bin-3.7-20101029.zip
2. decompress the package.
3. Create a project under eclipse.
Import the following JAR files to the project.
Jar files in the root directory
Jar files under the lib directory
Ooxml-libooxml-lib JAR File
4. Test the cla
Apache.org provides a project (poi) dedicated for office software operations. This greatly facilitates the operation and reading of the content for statistical analysis. Ingress is poi-bin-3.7-20101029.zipComponent APIsExcel (SS = HSSF + XSSF)Word (HWPF + XWPF)PowerPoint (HSLF + XSLF)OpenXML4J (OOXML)OLE2 Filesystem (POIFS)OLE2 Document Props (HPSF)Outlook (HSMF)Visio (HDGF)Publisher (HPBF)
The document provides two different writing methods: Old Cod
for cross-platform deployment.
Launch4j: Package JAR files into small Windows executable files.
Packr: packages program JAR, resources, and JVM into local files for Windows, Linux, and Mac OS X.
Document Processing
Function library used to process documents in Office format.
Apache POI: supports OOXML (XLSX, docx, PPTX) and OLE2 (XLS, DOC or PPT) files.
JOpenDocument: Process OpenDocument Format documents.
Game Development
Game Development Frame
with Maven or Gradle.
IzPack: used to create an authorization tool for cross-platform deployment.
Launch4j: Package JAR files into small Windows executable files.
Packr: packages program JAR, resources, and JVM into local files for Windows, Linux, and Mac OS X.
Document Processing
Function library used to process documents in Office format.
Apache POI: supports OOXML (XLSX, docx, PPTX) and OLE2 (XLS, DOC or PPT) files.
JOpenDocument: Pro
Poi export excel and poiexcel
I. Introduction
HSSF is the implementation of POI project's pure Java Excel97 (-2007) file format. XSSF is a Java implementation of the POI project Excel 2007 OOXML (.xlsx) file format. HSSF and XSSF provides multiple ways to read from, create, modify, read, and write workbooks.
It provides the following functions:
Provides a low-level structure for Special Needs
An efficient read-only access event model api
Provides
I,
Poi is a sub-project of Apache. It aims to provide Java APIs packages for operations on various documents based on ooxml (Microsoft Office open XML) and ole2 (Object Linking and Embedding. This project is divided into several components, including a component called hwpf, which can only operate on Word files. This is the component I will use. The full name of hwpf is horrible word processor format. Translating to Chinese is a "terrible document p
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.
Its structure is as follows:Hssf-provides the ability to read and write Microsoft Excel files: hssf is the abbreviation of horrible spreadsheet format, that is, "annoying spreadsheet format ". Perhaps the hssf name is a bit funny. In essence, it is a very serious and formal API. With hssf, you can use pure Java code to read, write, and modify Excel
a daily basis. certain Microsoft products (Windows Vista including. net Framework, Windows Server 2008, SQL Server 2008, Office 2007, Exchange 2007, and Office Sharepoint Server 2007, and future versions of these products, referred to in this document as "high-volume products") have become so central to operational continuity of MERs 'businesses that interoperability and data portability solutions are more valued than ever.In fact, Microsoft's intention is also obvious:1)
If you want to import Excel data to a database or export the data in the database as Excel, poi is a good choice. Apache poi is an open source code library of the Apache Software Foundation. Poi provides APIs to Java programs for MicrosoftOffice Format File Read and Write Functions.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 Micr
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.Basic functionsEditStructure: HSSF-provides the ability to read and write files in Microsoft Excel format. XSSF-Provides read-write Microsoft features of Excel ooxml format archives. HWPF-provides the ability to read and write files in Microsoft Word format. HSLF-provides the abilit
Java export Excel exceeds 65,536 processingIt Community referral information-itindex.netAPRPOI package export Excel exceeds 65536 error:Java.lang.IllegalArgumentException:Invalid row number (65536) outside allowWorkaround 1:XSS Replace HSSPoi by:Xssfworkbook wb = new Xssfworkbook ();Xssfsheet sheet1= wb.createsheet ("test");Support office2007, can be more than 65536 rows, when the data is more, will report memory overflow error, workaround see: http://blog.csdn.net/wula0010/article/details/53298
1: First Import all packages under the Poi-3.12-beta1 sibling directory, and then import all the packages under the Ooxml-lib folder2:New tocsv (); Tcsv.convertexceltocsv ("c:\\users\\administrator\\desktop\\bigdata\\simpheno.xlsx", "C:\\ Users\\administrator\\desktop\\bigdata ");These two groups are sufficient to generate a CSV file that can be read correctly in the generated CSV file after testing. It doesn't have to be as com
1. Download Apache Latest POI version on Apache website: poi-bin-3.11-20141221.zip, unzip;Note Here is the binary distribution download, binary distribution is a jar package, the source distribution is a file containing the sources, you can open the Java code2. Introduction of the jar package in Eclipse: Project-properties-libraries-add External JARsApache's official website provides some examples: http://poi.apache.org/spreadsheet/quick-guide.htmlNote: the "POI java.lang.noclassdeffounderror:or
the jar as a compact Windows executable file.
PACKR: Package The program jar, resources, and JVM into native files for Windows, Linux, and Mac OS X.
Document processingA library of functions used to process documents in office format.
Apache POI: Supports Ooxml (XLSX, DOCX, PPTX) as well as OLE2 (XLS, DOC or PPT)-formatted documents.
Jopendocument: Handles OpenDocument format documents.
Game developmentGame development Fram
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.