diff options
author | Dominik Stadler <centic@apache.org> | 2024-11-30 09:29:43 +0000 |
---|---|---|
committer | Dominik Stadler <centic@apache.org> | 2024-11-30 09:29:43 +0000 |
commit | 33f944f922df09209757ccbf731f609814c4da95 (patch) | |
tree | a70d0a16723938529854b498f04d98068ed9f9d9 /poi-examples/src/main/groovy/SpreadSheetDemo.groovy | |
parent | 3e0306d2533406e77cf2a38f8706b9a646c5be8d (diff) | |
download | poi-33f944f922df09209757ccbf731f609814c4da95.tar.gz poi-33f944f922df09209757ccbf731f609814c4da95.zip |
Groovy script example: Use latest POI and fix to run again
Fix path to test-file
Fix changed constants
Add settings.gradle
Adjust Rat exclusions
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1922229 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi-examples/src/main/groovy/SpreadSheetDemo.groovy')
-rw-r--r-- | poi-examples/src/main/groovy/SpreadSheetDemo.groovy | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/poi-examples/src/main/groovy/SpreadSheetDemo.groovy b/poi-examples/src/main/groovy/SpreadSheetDemo.groovy index b9f30c0ce6..0789b56a70 100644 --- a/poi-examples/src/main/groovy/SpreadSheetDemo.groovy +++ b/poi-examples/src/main/groovy/SpreadSheetDemo.groovy @@ -36,7 +36,7 @@ WorkbookFactory.create(f,null,true).withCloseable { workbook -> def sheet = workbook.getSheetAt(sheetNum) sheet.each { row -> - def nonEmptyCells = row.grep { c -> c.getCellType() != Cell.CELL_TYPE_BLANK } + def nonEmptyCells = row.grep { c -> c.getCellType() != CellType.BLANK } println " Row ${row.getRowNum()} has ${nonEmptyCells.size()} non-empty cells:" nonEmptyCells.each { c -> def cRef = [c] as CellReference @@ -52,7 +52,7 @@ WorkbookFactory.create(f,null,true).withCloseable { workbook -> ns1.createRow(1).createCell(0).setCellValue("TODO - Populate with data") Sheet ns2 = workbook.createSheet("Generated 2") - exportHeader(ns2, headerStyle, "This is a demo sheet", + exportHeader(ns2, headerStyle, "This is a demo sheet", ["ID","Title","Date","Author","Num"] as String[]) ns2.createRow(2).createCell(0).setCellValue(1) ns2.createRow(3).createCell(0).setCellValue(4) |