| /* ==================================================================== |
| 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.hssf.eventusermodel; |
| |
| import static org.junit.jupiter.api.Assertions.assertArrayEquals; |
| import static org.junit.jupiter.api.Assertions.assertEquals; |
| import static org.junit.jupiter.api.Assertions.assertFalse; |
| import static org.junit.jupiter.api.Assertions.assertThrows; |
| import static org.junit.jupiter.api.Assertions.assertTrue; |
| |
| import java.io.IOException; |
| import java.io.InputStream; |
| import java.util.ArrayList; |
| import java.util.List; |
| |
| import org.apache.poi.EncryptedDocumentException; |
| import org.apache.poi.hssf.HSSFTestDataSamples; |
| import org.apache.poi.hssf.record.BoundSheetRecord; |
| import org.apache.poi.hssf.record.ContinueRecord; |
| import org.apache.poi.hssf.record.DVALRecord; |
| import org.apache.poi.hssf.record.DVRecord; |
| import org.apache.poi.hssf.record.EOFRecord; |
| import org.apache.poi.hssf.record.FeatHdrRecord; |
| import org.apache.poi.hssf.record.NumberRecord; |
| import org.apache.poi.hssf.record.SelectionRecord; |
| import org.apache.poi.hssf.record.WindowTwoRecord; |
| import org.apache.poi.hssf.record.crypto.Biff8EncryptionKey; |
| import org.apache.poi.poifs.filesystem.POIFSFileSystem; |
| import org.junit.jupiter.api.Test; |
| |
| /** |
| * Testing for {@link HSSFEventFactory} |
| */ |
| final class TestHSSFEventFactory { |
| private final List<org.apache.poi.hssf.record.Record> records = new ArrayList<>(); |
| |
| private void openSample(String sampleFileName) throws IOException { |
| records.clear(); |
| HSSFRequest req = new HSSFRequest(); |
| req.addListenerForAllRecords(records::add); |
| try (InputStream is = HSSFTestDataSamples.openSampleFileStream(sampleFileName); |
| POIFSFileSystem fs = new POIFSFileSystem(is)) { |
| HSSFEventFactory factory = new HSSFEventFactory(); |
| factory.processWorkbookEvents(req, fs); |
| } |
| } |
| |
| @Test |
| void testWithMissingRecords() throws Exception { |
| |
| openSample("SimpleWithSkip.xls"); |
| |
| int numRec = records.size(); |
| |
| // Check we got the records |
| assertTrue( numRec > 100 ); |
| |
| // Check that the last few records are as we expect |
| // (Makes sure we don't accidently skip the end ones) |
| Class<?>[] exp = { WindowTwoRecord.class, SelectionRecord.class, EOFRecord.class }; |
| Class<?>[] act = records.subList(numRec - 3, numRec).stream().map(Object::getClass).toArray(Class[]::new); |
| assertArrayEquals(exp, act); |
| } |
| |
| @Test |
| void testWithCrazyContinueRecords() throws Exception { |
| // Some files have crazy ordering of their continue records |
| // Check that we don't break on them (bug #42844) |
| |
| openSample("ContinueRecordProblem.xls"); |
| |
| int numRec = records.size(); |
| // Check we got the records |
| assertTrue( numRec > 100 ); |
| |
| // And none of them are continue ones |
| assertFalse(records.stream().anyMatch(r -> r instanceof ContinueRecord)); |
| |
| // Check that the last few records are as we expect |
| // (Makes sure we don't accidentally skip the end ones) |
| Class<?>[] exp = { DVALRecord.class, DVRecord.class, FeatHdrRecord.class, EOFRecord.class }; |
| Class<?>[] act = records.subList(numRec-4, numRec).stream().map(Object::getClass).toArray(Class[]::new); |
| assertArrayEquals(exp, act); |
| } |
| |
| /** |
| * Unknown records can be continued. |
| * Check that HSSFEventFactory doesn't break on them. |
| * (the test file was provided in a reopen of bug #42844) |
| */ |
| @Test |
| @SuppressWarnings("java:S2699") |
| void testUnknownContinueRecords() throws Exception { |
| openSample("42844.xls"); |
| } |
| |
| @Test |
| @SuppressWarnings("java:S2699") |
| void testWithDifferentWorkbookName() throws Exception { |
| openSample("BOOK_in_capitals.xls"); |
| openSample("WORKBOOK_in_capitals.xls"); |
| } |
| |
| @Test |
| @SuppressWarnings("java:S2699") |
| void testWithPasswordProtectedWorkbooksNoPass() { |
| // Without a password, can't be read |
| assertThrows(EncryptedDocumentException.class, () -> openSample("xor-encryption-abc.xls")); |
| } |
| |
| @Test |
| void testWithPasswordProtectedWorkbooks() throws Exception { |
| // With the password, is properly processed |
| Biff8EncryptionKey.setCurrentUserPassword("abc"); |
| try { |
| openSample("xor-encryption-abc.xls"); |
| |
| // Check we got the sheet and the contents |
| assertTrue(records.size() > 50); |
| |
| // Has one sheet, with values 1,2,3 in column A rows 1-3 |
| boolean hasSheet = false, hasA1 = false, hasA2 = false, hasA3 = false; |
| for (org.apache.poi.hssf.record.Record r : records) { |
| if (r instanceof BoundSheetRecord) { |
| BoundSheetRecord bsr = (BoundSheetRecord) r; |
| assertEquals("Sheet1", bsr.getSheetname()); |
| hasSheet = true; |
| } |
| if (r instanceof NumberRecord) { |
| NumberRecord nr = (NumberRecord) r; |
| if (nr.getColumn() == 0 && nr.getRow() == 0) { |
| assertEquals(1, (int) nr.getValue()); |
| hasA1 = true; |
| } |
| if (nr.getColumn() == 0 && nr.getRow() == 1) { |
| assertEquals(2, (int) nr.getValue()); |
| hasA2 = true; |
| } |
| if (nr.getColumn() == 0 && nr.getRow() == 2) { |
| assertEquals(3, (int) nr.getValue()); |
| hasA3 = true; |
| } |
| } |
| } |
| |
| assertTrue(hasSheet, "Sheet record not found"); |
| assertTrue(hasA1, "Numeric record for A1 not found"); |
| assertTrue(hasA2, "Numeric record for A2 not found"); |
| assertTrue(hasA3, "Numeric record for A3 not found"); |
| } finally { |
| Biff8EncryptionKey.setCurrentUserPassword(null); |
| } |
| } |
| } |