Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
What Is poi-examples-5.2.3.jar?
What Is poi-examples-5.2.3.jar?
✍: FYIcenter.com
poi-examples-5.2.3.jar is one of the JAR files for Apache POI 5.2.3, which provides an API for Microsoft document files of Word, Excel, PowerPoint, and Visio.
poi-examples-5.2.3.jar provides examples for both poi.jar and poi-ooxml.jar components.
poi-examples-5.2.3.jar is distributed as part of the poi-bin-5.2.3-20220909.zip download file.
JAR File Size and Download Location:
JAR name: poi-examples-5.2.3.jar Target JDK version: 1.6 Dependency: poi.jar poi-ooxml.jar File name: poi-examples-5.2.3.jar File size: 388829 bytes Release date: 09-09-2022 Download: Apache POI Website
Here are Java Source Code files for poi-examples-5.2.3.jar:
⏎ org/apache/poi/examples/xssf/usermodel/CreatePivotTable2.java
/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.examples.xssf.usermodel; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.Calendar; import java.util.Date; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.SpreadsheetVersion; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.DataConsolidateFunction; import org.apache.poi.ss.usermodel.DataFormat; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.util.AreaReference; import org.apache.poi.ss.util.CellReference; import org.apache.poi.util.LocaleUtil; import org.apache.poi.xssf.usermodel.XSSFPivotTable; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class CreatePivotTable2 { public static void main(String[] args) throws FileNotFoundException, IOException, InvalidFormatException { try (XSSFWorkbook wb = new XSSFWorkbook()) { XSSFSheet sheet = wb.createSheet(); //Create some data to build the pivot table on setCellData(sheet); AreaReference source = new AreaReference("A1:E7", SpreadsheetVersion.EXCEL2007); CellReference position = new CellReference("H1"); // Create a pivot table on this sheet, with H1 as the top-left cell.. // The pivot table's data source is on the same sheet in A1:E7 XSSFPivotTable pivotTable = sheet.createPivotTable(source, position); //Configure the pivot table //Use first column as row label pivotTable.addRowLabel(0); //Sum up the second column with column title and data format pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 1, "Values", "#,##0.00"); //Use third column (month) as columns (side by side) pivotTable.addColLabel(3, "DD.MM.YYYY"); //Add filter on forth column pivotTable.addReportFilter(4); try (FileOutputStream fileOut = new FileOutputStream("ooxml-pivottable2.xlsx")) { wb.write(fileOut); } } } public static void setCellData(XSSFSheet sheet){ Calendar cal1 = LocaleUtil.getLocaleCalendar(); cal1.set(2017, 0, 1, 0, 0, 0); Calendar cal2 = LocaleUtil.getLocaleCalendar(); cal2.set(2017, 1, 1, 0, 0, 0); Row row1 = sheet.createRow(0); // Create a cell and put a value in it. // first row are column titles Cell cell11 = row1.createCell(0); cell11.setCellValue("Names"); Cell cell12 = row1.createCell(1); cell12.setCellValue("Values"); Cell cell13 = row1.createCell(2); cell13.setCellValue("%"); Cell cell14 = row1.createCell(3); cell14.setCellValue("Month"); Cell cell15 = row1.createCell(4); cell15.setCellValue("No"); CellStyle csDbl = sheet.getWorkbook().createCellStyle(); DataFormat dfDbl = sheet.getWorkbook().createDataFormat(); csDbl.setDataFormat(dfDbl.getFormat("#,##0.00")); CellStyle csDt = sheet.getWorkbook().createCellStyle(); DataFormat dfDt = sheet.getWorkbook().createDataFormat(); csDt.setDataFormat(dfDt.getFormat("dd/MM/yyyy")); // data setDataRow(sheet, 1, "Jane", 1120.5, 100, cal1.getTime(), 1, csDbl, csDt); setDataRow(sheet, 2, "Jane", 1453.2, 95, cal2.getTime(), 2, csDbl, csDt); setDataRow(sheet, 3, "Tarzan", 1869.8, 88, cal1.getTime(), 1, csDbl, csDt); setDataRow(sheet, 4, "Tarzan", 1536.2, 92, cal2.getTime(), 2, csDbl, csDt); setDataRow(sheet, 5, "Terk", 1624.1, 75, cal1.getTime(), 1, csDbl, csDt); setDataRow(sheet, 6, "Terk", 1569.3, 82, cal2.getTime(), 2, csDbl, csDt); sheet.autoSizeColumn(3); } public static void setDataRow(XSSFSheet sheet, int rowNum, String name, double v1, int v2, Date dt, int no, CellStyle csDbl, CellStyle csDt){ Row row = sheet.createRow(rowNum); // set the values for one row Cell c1 = row.createCell(0); c1.setCellValue(name); Cell c2 = row.createCell(1); c2.setCellValue(v1); c2.setCellStyle(csDbl); Cell c3 = row.createCell(2); c3.setCellValue(v2); Cell c4 = row.createCell(3); c4.setCellValue(dt); c4.setCellStyle(csDt); Cell c5 = row.createCell(4); c5.setCellValue(no); } }
⏎ org/apache/poi/examples/xssf/usermodel/CreatePivotTable2.java
Or download all of them as a single archive file:
File name: poi-examples-5.2.3-src.zip File size: 396538 bytes Release date: 2022-09-09 Download
⇒ Download and Install poi-bin-3.15-20160924.zip
⇐ What Is poi-scratchpad-5.2.3.jar?
2017-03-22, 11315👍, 0💬
Popular Posts:
commons-io-2.6-sources.j aris the source JAR file for Apache Commons IO 2.6, which is a library of u...
JDK 11 java.desktop.jmod is the JMOD file for JDK 11 Desktop module. JDK 11 Desktop module compiled ...
Jetty provides an HTTP server, HTTP client, and javax.servlet container. These components are open s...
Apache Commons Lang 3 is the 3rd version of Apache Commons Lang, which provides a host of helper uti...
How to download and install iText7-Core-7.1.4.zip? iText7-Core-7.1.4.zip is the binary package of iT...