ooxml

Requirement: The most recent project needs to move the app's upload menu function to the PC side to achieve, the main difficulty is the image of the bulk import, because the framework is the company's own development, I really dare not compliment, upload files I use JS to the server, in the background to read ....Why upload to the server, because now the security of the browser is improved, input file cannot get the true absolute address .... Jar:poi-3.12.jar Poi-

Cellrangeaddress (2, 2,0, Num_of_columns- 1)); Data.addserie (xs, ys1); Data.addserie (xs, YS2); Chart.plot (data, Bottomaxis, Leftaxis); //Write the output to a file FileOutputStream fileout = new FileOutputStream ("ooxml-scatter-chart.xlsx"); Wb.write (fileout); Fileout.close (); } } The following decomposition:1. The following code creates a new workbook and a work form object[Java]View PlainCopy Workbook

(style);Hssfcell CELLB1 = Row2.createcell ((short) (2 * num + 3));Hssfcell cellb2 = Row2.createcell ((short) (2 * num + 4));Cellb1.setencoding (HSSFCELL.ENCODING_UTF_16);Cellb1.setcellvalue ("Quantity");Cellb1.setcellstyle (style);Cellb2.setencoding (HSSFCELL.ENCODING_UTF_16);Cellb2.setcellvalue ("Amount");Cellb2.setcellstyle (style);FileOutputStream fileout = new FileOutputStream ("Workbook.xls");Wb.write (fileout);Fileout.close ();System.out.print ("OK");} catch (Exception ex) {Ex.printstackt

website: http://sourceforge.net/projects/itextsharp/Description: itext# (ITEXTSHARP) is a C # ported version of the IText Java Open Source Library, which allows you to generate PDFs from scratch.Relevant file formats: PDF, RTF, BMP, GIF, PNG,TIFF, JPEGRelated technologies: OpenPGP, OpenSSL, TSP (timestamp protocol), X509, OCSP, Biginterger, BCPGGiflibLanguage: C #Official website: Http://www.codeplex.com/GifLib or Http://www.cndotnet.org/GifLibDescription: Giflib can read and write GIF format w

Apache POI is a free open source cross-platform Java Api,apache poi written in Java that provides the Java program with the ability to read and write to Microsoft Office format archives. The POI is an acronym for "Poor Obfuscation implementation", meaning "poor fuzzy implementation."Apache POI is a Java API that creates and maintains operations for various office Open XML (OOXML) compliant and Microsoft OLE 2 composite document formats (OLE2). You can

-1.1.jar using the CXF jar packageOro-2.0.8.jar jar package required for validator frameworkOscache-2.1.jar caching Tools for Java objectsPoi-3.1-final-20080629.jar operation Exce Required jar PackagePoi-contrib-3.1-final-20080629.jar operation Exce Required jar PackagePoi-ooxml-3.6-20091214.jar provides actions for Office Word, Excel, Visio, and PPTPoi-ooxml-schemas-3.6-20091214.jar provides actions for Of

MAVEN-built Project-->pom.xml file Eclipse provides dependencies to directly add dependent jar packages: Search for POI and poi-ooxml directly, and MAVEN will automatically rely on the jar package you need: POI provides support for older versions of Microsoft Office, eg. xls Excel Poi-ooxml provides new versions of Microsoft Office support, eg. xlsx Excel or manual

.jar Operation Exce Required JAR Package Poi-contrib-3.1-final-20080629.jar Operation Exce Required JAR Package Poi-ooxml-3.6-20091214.jar Provides actions for Word, Excel, Visio, and PPT for office Poi-ooxml-schemas-3.6-20091214.jar Provides actions for Word, Excel, Visio, and PPT for office Poi-scratchpad-3.1-final-20080629.jar

Use poi to read and write Excel For a programmer, file operations are common, especially for Excel files. Here I will introduce a POI tool used in the project to Operate Excel. There are many concepts about POI on the Internet. For more information, you can use Baidu. Here I will just give a brief introduction. POI is an apache class library that provides java developers with support for Office file processing (word, ppt, and Excel. Here are some examples to illustrate. Preparations The versio

One, the jar to be imported1.commons-collections4-4.1.jar2.poi-3.17-beta1.jar3.poi-ooxml-3.17-beta1.jar4.poi-ooxml-schemas-3.17-beta1.jar5.xmlbeans-2.6.0.jarSecond, the main API1.import Org.apache.poi.ss.usermodel.Workbook, corresponding to Excel documents;2.import Org.apache.poi.hssf.usermodel.HSSFWorkbook, Excel document corresponding to XLS format;3.import Org.apache.poi.xssf.usermodel.XSSFWorkbook, Exce

#Official website: http://sourceforge.net/projects/itextsharp/Description: itext# (ITEXTSHARP) is a C # ported version of the IText Java Open Source Library, which allows you to generate PDFs from scratch.Relevant file formats: PDF, RTF, BMP, GIF, PNG,TIFF, JPEGRelated technologies: OpenPGP, OpenSSL, TSP (timestamp protocol), X509, OCSP, Biginterger, BCPGGiflibLanguage: C #Official website: Http://www.codeplex.com/GifLib or Http://www.cndotnet.org/GifLibDescription: Giflib can read and write GI

.jar Operation Exce Required JAR Package Poi-contrib-3.1-final-20080629.jar Operation Exce Required JAR Package Poi-ooxml-3.6-20091214.jar Provides actions for Word, Excel, Visio, and PPT for office Poi-ooxml-schemas-3.6-20091214.jar Provides actions for Word, Excel, Visio, and PPT for office Poi-scratchpad-3.1-final-20080629.jar

Use POI to read the Execl table, return an object (may be a bit imperfect, but should be able to meet the usual use), the use of reflection and so on;The jar packages used are:Commons-collections4-4.1.jarPoi-3.17.jarPoi-ooxml.3.17.jarPoi-ooxml-schemas.3.17.jarXmllbeans-2.6.0.jar/*** Static Property Bag* @author Administrator**/public class Common {public static final String office_excel_2003_postfix = "xls"

---restore content starts---The jar packages that you need to rely on forFTP- forSina crawl used, but with selenium needed version conflict 2.44selenium comes with 4.3.4httplient-->//Mvnrepository.com/artifact/mysql/mysql-connector-java --//Mvnrepository.com/artifact/org.apache.poi/poi-ooxml -- for Use selenium and poi-//Mvnrepository.com/artifact/org.apache.poi/poi-ooxml --2. configuration file ContentsWbz

common ways to parse Excel Jxl,poiJXL is relatively simple to use, but only supports the Excel2003 version, which means that JXL cannot parse the. xlsx Excel file, and the POI will recognize the Excel version for parsing, so most people are more inclined to poiJXL need to import Jxl.jar package in Project when usingPoi needs to be importedPoi-3.14-20160307.jarPoi-ooxml-3.14-20160307.jarPoi-ooxml-schemas-3.

recognition (ANother Tool for Language recognition) is a language tool that provides a framework for constructing language recognizers through syntax descriptions that contain Java, C + +, or C # actions (action), The translator and interpreter. See: http://www.ibm.com/developerworks/cn/java/j-lo-antlr/index.html?ca=drs- Json-lib-2.2.3-jdk15.jar Java parses the jar required by JSON. Mysql.jar Needless to say, MySQL database is required. Ojdbc14_g.jar Oracal required for the database. Pushle

cross-platform deployments. LAUNCH4J: Wraps 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 docum

lightweight threading and Actor for the JVM. 　　ReleaseTools for distributing Java applications using native format. Bintray: Versioning binary releases, which can be used in conjunction with Maven or Gradle. IzPack: Establish authorization tools for cross-platform deployments. LAUNCH4J: Wraps 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 li

. LAUNCH4J: Wraps 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 development

docx (ooxml format), has a Chinese Office software document Format (*.uof,*.xml), this file format is our own file format. Save as WPS text Trial notes 1.uof, double-click the file, WPS does not set itself to open the default file, but also to open the user selection program. Finally, you can open the file in docx format. Conversion of PDF file format WPS Office 2010 Output to PDF file is still good, click on the toolbar menu can be directly genera