See <https://builds.apache.org/job/POI-DSL-Windows-1.8/134/display/redirect?page=changes>
Changes: [nick] Unit test to try to reproduce bug #62108 (currenly works though...) [nick] Update the groovy example [nick] Add some write/change code as well for Groovy [nick] Commit examples from the JVM Languages page ------------------------------------------ [...truncated 593.54 KB...] [zip] Building zip: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist\poi-bin-4.0.0-SNAPSHOT-20180216.zip> [tar] Building tar: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist\poi-bin-4.0.0-SNAPSHOT-20180216.tar.gz> [zip] Building zip: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist\poi-src-4.0.0-SNAPSHOT-20180216.zip> [tar] Building tar: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist\poi-src-4.0.0-SNAPSHOT-20180216.tar.gz> [echo] Creating Maven POMs maven-poms: [copy] Copying 6 files to <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist\maven> [echo] Maven POMs are located in <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist> [echo] Use ant dist-nexus to deploy the artifacts in the remote repository [echo] Distribution located in <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist> [echo] Use "ant dist-checksum" to create md5/sha1/sha512 checksums and GPG signatures findbugs: [get] Destination already exists (skipping): <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/lib\findbugs-noUpdateChecks-3.0.1.zip> [unzip] Expanding: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/lib\findbugs-noUpdateChecks-3.0.1.zip> into <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\findbugs> [findbugs] Executing findbugs FindBugsTask from ant task [findbugs] Running FindBugs... [findbugs] Warnings generated: 47 [findbugs] Calculating exit code... [findbugs] Setting 'bugs found' flag (1) [findbugs] Exit code set to: 1 [findbugs] Java Result: 1 [findbugs] Output saved to build/findbugs.xml [xslt] Transforming into <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build> [xslt] Processing <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\findbugs.xml> to <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\findbugs.html> [xslt] Loading stylesheet jar:<https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build/findbugs/lib/findbugs.jar!/fancy-hist.xsl> release-notes: [copy] Copying 1 file to <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\dist> rat-check: [mkdir] Created dir: <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build\rat> [echo] [echo] ***************************************************** [echo] Summary [echo] ------- [echo] Generated at: 2018-02-16T12:39:54+00:00 [echo] [echo] Notes: 1 [echo] Binaries: 120 [echo] Archives: 0 [echo] Standards: 3762 [echo] [echo] Apache Licensed: 3757 [echo] Generated Documents: 0 [echo] [echo] JavaDocs are generated, thus a license header is optional. [echo] Generated files do not require license headers. [echo] [echo] 5 Unknown Licenses [echo] [echo] ***************************************************** [echo] [echo] Files with unapproved licenses: [echo] [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] [echo] ***************************************************** [echo] [echo] ***************************************************** [echo] Files with Apache License headers will be marked AL [echo] Binary files (which do not require any license headers) will be marked B [echo] Compressed archives will be marked A [echo] Notices, licenses etc. will be marked N [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] [echo] ***************************************************** [echo] [echo] Printing headers for text files without a valid license header... [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] ===================================================== [echo] (ns poi.core [echo] (:gen-class) [echo] (:use [clojure.java.io :only [input-stream]]) [echo] (:import [org.apache.poi.ss.usermodel WorkbookFactory DataFormatter])) [echo] [echo] [echo] (defn sheets [wb] (map #(.getSheetAt wb %1) (range 0 (.getNumberOfSheets wb)))) [echo] [echo] (defn print-all [wb] [echo] (let [df (DataFormatter.)] [echo] (doseq [sheet (sheets wb)] [echo] (doseq [row (seq sheet)] [echo] (doseq [cell (seq row)] [echo] (println (.formatAsString (.getAddress cell)) ": " (.formatCellValue df cell))))))) [echo] [echo] (defn -main [& args] [echo] (when-let [name (first args)] [echo] (let [wb (WorkbookFactory/create (input-stream name))] [echo] (print-all wb)))) [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] ===================================================== [echo] import org.apache.poi.ss.usermodel.* [echo] import org.apache.poi.ss.util.* [echo] import java.io.File [echo] [echo] if (args.length == 0) { [echo] println "Use:" [echo] println " SpreadSheetDemo <excel-file> [output-file]" [echo] return 1 [echo] } [echo] [echo] File f = new File(args[0]) [echo] DataFormatter formatter = new DataFormatter() [echo] WorkbookFactory.create(f,null,true).withCloseable { workbook -> [echo] println "Has ${workbook.getNumberOfSheets()} sheets" [echo] [echo] // Dump the contents of the spreadsheet [echo] (0..<workbook.getNumberOfSheets()).each { sheetNum -> [echo] println "Sheet ${sheetNum} is called ${workbook.getSheetName(sheetNum)}" [echo] [echo] def sheet = workbook.getSheetAt(sheetNum) [echo] sheet.each { row -> [echo] def nonEmptyCells = row.grep { c -> c.getCellType() != Cell.CELL_TYPE_BLANK } [echo] println " Row ${row.getRowNum()} has ${nonEmptyCells.size()} non-empty cells:" [echo] nonEmptyCells.each { c -> [echo] def cRef = [c] as CellReference [echo] println " * ${cRef.formatAsString()} = ${formatter.formatCellValue(c)}" [echo] } [echo] } [echo] } [echo] [echo] // Add two new sheets and populate [echo] CellStyle headerStyle = makeHeaderStyle(workbook) [echo] Sheet ns1 = workbook.createSheet("Generated 1") [echo] exportHeader(ns1, headerStyle, null, ["ID","Title","Num"] as String[]) [echo] ns1.createRow(1).createCell(0).setCellValue("TODO - Populate with data") [echo] [echo] Sheet ns2 = workbook.createSheet("Generated 2") [echo] exportHeader(ns2, headerStyle, "This is a demo sheet", [echo] ["ID","Title","Date","Author","Num"] as String[]) [echo] ns2.createRow(2).createCell(0).setCellValue(1) [echo] ns2.createRow(3).createCell(0).setCellValue(4) [echo] ns2.createRow(4).createCell(0).setCellValue(1) [echo] [echo] // Save [echo] File output = File.createTempFile("output-", (f.getName() =~ /(\.\w+$)/)[0][0]) [echo] output.withOutputStream { os -> workbook.write(os) } [echo] println "Saved as ${output}" [echo] } [echo] [echo] CellStyle makeHeaderStyle(Workbook wb) { [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] ===================================================== [echo] // Add the POI core and OOXML support dependencies into your gradle build, [echo] // along with all of Groovy so it can run as a standalone script [echo] apply plugin: 'groovy' [echo] repositories { [echo] mavenCentral() [echo] } [echo] dependencies { [echo] compile 'org.codehaus.groovy:groovy-all:2.4.13' [echo] compile 'org.apache.poi:poi:3.17' [echo] compile 'org.apache.poi:poi-ooxml:3.17' [echo] } [echo] [echo] // Our files are in the current directory [echo] sourceSets { [echo] main { groovy { srcDirs = ['.'] } } [echo] } [echo] [echo] // Run out read demo by default [echo] tasks.withType(JavaExec) { [echo] classpath = sourceSets.main.runtimeClasspath [echo] } [echo] task runScript(type: JavaExec) { [echo] main = "SpreadSheetDemo" [echo] args = ["../../../test-data/spreadsheet/Simple.xls"] [echo] } [echo] defaultTasks 'runScript' [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] ===================================================== [echo] // Import the required classes [echo] import org.apache.poi.ss.usermodel.{WorkbookFactory, DataFormatter} [echo] import java.io.{File, FileOutputStream} [echo] [echo] object XSSFMain extends App { [echo] [echo] // Automatically convert Java collections to Scala equivalents [echo] import scala.collection.JavaConversions._ [echo] [echo] // Read the contents of the workbook [echo] val workbook = WorkbookFactory.create(new File("SampleSS.xlsx")) [echo] val formatter = new DataFormatter() [echo] for { [echo] // Iterate and print the sheets [echo] (sheet, i) <- workbook.zipWithIndex [echo] _ = println(s"Sheet $i of ${workbook.getNumberOfSheets}: ${sheet.getSheetName}") [echo] [echo] // Iterate and print the rows [echo] row <- sheet [echo] _ = println(s"\tRow ${row.getRowNum}") [echo] [echo] // Iterate and print the cells [echo] cell <- row [echo] } { [echo] println(s"\t\t${cell.getCellAddress}: ${formatter.formatCellValue(cell)}") [echo] } [echo] [echo] // Add a sheet to the workbook [echo] val sheet = workbook.createSheet("new sheet") [echo] val row = sheet.createRow(7) [echo] val cell = row.createCell(42) [echo] cell.setAsActiveCell() [echo] cell.setCellValue("The answer to life, the universe, and everything") [echo] [echo] // Save the updated workbook as a new file [echo] val fos = new FileOutputStream("SampleSS-updated.xlsx") [echo] workbook.write(fos) [echo] workbook.close() [echo] } [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] ===================================================== [echo] // Add the POI core and OOXML support dependencies into your build.sbt [echo] libraryDependencies ++= Seq( [echo] "org.apache.poi" % "poi" % "3.17", [echo] "org.apache.poi" % "poi-ooxml" % "3.17", [echo] "org.apache.poi" % "poi-ooxml-schemas" "3.17", [echo] ) BUILD FAILED <https://builds.apache.org/job/POI-DSL-Windows-1.8/ws/build.xml>:2088: condition satisfied Total time: 21 minutes 6 seconds Build step 'Invoke Ant' marked build as failure Skipping publisher since build result is FAILURE Archiving artifacts [Fast Archiver] Compressed 235.91 MB of artifacts by 54.9% relative to #133 Skipping publisher since build result is FAILURE Recording test results --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org