See <https://builds.apache.org/job/POI/767/changes>
Changes: [dnorth] Make it a complete sentence. [dnorth] Example to go with refactor for https://bz.apache.org/bugzilla/show_bug.cgi?id=58219 ------------------------------------------ [...truncated 8177 lines...] [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDStarFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDate.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDays360.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDec2Bin.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDec2Hex.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDelta.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestDeltaFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestEDate.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestEOMonth.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestFactDoubleFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestFinanceLib.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestFind.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestFixed.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestFixedFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestHex2Dec.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIPMT.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestImRealFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestImaginaryFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIndex.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIndexFunctionFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIndirect.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIndirectFunctionFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIntercept.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIrr.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestIsBlank.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestLeftRight.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestLen.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestLogicalFunction.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestLookupFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestMatch.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestMatchFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestMathX.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestMid.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestMirr.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestNper.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestNpv.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestOct2Dec.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestOffset.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestPPMT.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestPmt.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestPoisson.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestQuotient.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestQuotientFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestRank.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestReptFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestRomanFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestRoundFuncs.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestRowCol.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSlope.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestStatsLib.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSubtotal.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumif.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumifs.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestSumproduct.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTFunc.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestText.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTime.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTrim.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestTrunc.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestValue.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestWeekNumFunctionsFromSpreadsheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestWeekNumFunctionsFromSpreadsheet2013.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/functions/TestXYNumericFunction.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/AbstractPtgTestCase.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/AllFormulaTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestArea3DPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAreaErrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAreaPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestArrayPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestAttrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestErrPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestExternalFunctionFormulas.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestExternalNameReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestFuncPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestFuncVarPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestIntersectionPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestPercentPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestRangePtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestRef3DPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestReferencePtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/formula/ptg/TestUnionPtg.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestBugzillaIssues.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestCellComment.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestConditionalFormatting.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestDataFormat.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestDataValidation.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestFont.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestHyperlink.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestNamedRange.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestPicture.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheet.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetAutosizeColumn.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetHiding.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetUpdateArrayFormulas.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestDateUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/TestFractionFormat.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/usermodel/charts/TestDataSources.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/AllSSUtilTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberComparingSpreadsheetGenerator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberComparisonExamples.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberRenderingSpreadsheetGenerator.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/NumberToTextConversionExamples.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestAreaReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestCellRangeAddress.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestCellReference.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestDateFormatConverter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestExpandedDouble.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestNumberComparer.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestNumberToTextConverter.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestRegion.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestSheetBuilder.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestSheetUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/TestWorkbookUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/ss/util/cellwalk/TestCellWalk.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/AllPOIUtilTests.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/DummyPOILogger.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/LocalTestNode.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestArrayUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestBinaryTree.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestBitField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestByteField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestHexDump.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestIntList.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestIntegerField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLittleEndian.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLittleEndianStreams.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestLongField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestPOILogFactory.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestPOILogger.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestShortField.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestShortList.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestStringUtil.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/TestTempFile.java> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties1> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties2> [echo] AL <https://builds.apache.org/job/POI/ws/src/testcases/org/apache/poi/util/data/test_properties3> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FFData_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgLw95_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgLw97_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/FibRgW97_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/LFOLVLBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/StdfBase_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/StdfPost2000_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/Stshif_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/bkf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/chp_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/dml-shapeGeometry.xjb> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/dop_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/fld_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/frd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/fspa_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/grfhic_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/hresi_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lfo_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lstf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/lvlf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/pap_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/picf_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/sep_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/shd80_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/shd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tap_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tbd_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tc_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/definitions/tlp_type.xml> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype.xsl> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype_document.xsl> [echo] AL <https://builds.apache.org/job/POI/ws/src/types/styles/hdftype_test.xsl> [echo] [echo] ***************************************************** [echo] Printing headers for files without AL header... [echo] [echo] [echo] ======================================================================= [echo] ==<https://builds.apache.org/job/POI/ws/src/examples/src/org/apache/poi/xssf/streaming/examples/HybridStreaming.java> [echo] ======================================================================= [echo] package org.apache.poi.xssf.streaming.examples; [echo] [echo] import java.io.FileInputStream; [echo] import java.io.IOException; [echo] import java.io.InputStream; [echo] [echo] import org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable; [echo] import org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler; [echo] import org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler.SheetContentsHandler; [echo] import org.apache.poi.xssf.usermodel.XSSFComment; [echo] import org.apache.poi.xssf.usermodel.XSSFSheet; [echo] import org.apache.poi.xssf.usermodel.XSSFWorkbook; [echo] import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet; [echo] import org.xml.sax.SAXException; [echo] [echo] /** [echo] * This demonstrates how a hybrid approach to workbook read can be taken, using [echo] * a mix of traditional XSSF and streaming one particular worksheet (perhaps one [echo] * which is too big for the ordinary DOM parse). [echo] */ [echo] public class HybridStreaming { [echo] [echo] private static final String SHEET_TO_STREAM = "large sheet"; [echo] [echo] public static void main(String[] args) throws IOException, SAXException { [echo] InputStream sourceBytes = new FileInputStream("/path/too/workbook.xlsx"); [echo] XSSFWorkbook workbook = new XSSFWorkbook(sourceBytes) { [echo] /** Avoid DOM parse of large sheet */ [echo] public void parseSheet(java.util.Map<String,XSSFSheet> shIdMap, CTSheet ctSheet) { [echo] if (SHEET_TO_STREAM.equals(ctSheet.getName())) { [echo] return; [echo] } [echo] }; [echo] }; [echo] [echo] // Having avoided a DOM-based parse of the sheet, we can stream it instead. [echo] ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(workbook.getPackage()); [echo] new XSSFSheetXMLHandler(workbook.getStylesSource(), strings, createSheetContentsHandler(), false); [echo] workbook.close(); [echo] } [echo] [echo] private static SheetContentsHandler createSheetContentsHandler() { [echo] return new SheetContentsHandler() { [echo] [echo] public void startRow(int rowNum) { [echo] } [echo] [echo] public void headerFooter(String text, boolean isHeader, String tagName) { [echo] } [echo] BUILD FAILED <https://builds.apache.org/job/POI/ws/build.xml>:1721: condition satisfied Total time: 17 minutes 36 seconds Build step 'Invoke Ant' marked build as failure [FINDBUGS] Skipping publisher since build result is FAILURE [WARNINGS] Skipping publisher since build result is FAILURE Archiving artifacts Sending artifact delta relative to POI #766 Archived 4640 artifacts Archive block size is 32768 Received 2879 blocks and 102991719 bytes Compression is 47.8% Took 45 sec Recording test results --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
