Examples with POIFSFileSystem org.apache.poi.poifs.filesystem.POIFSFileSystem used on opensource projects

Example 41 with POIFSFileSystem

use of org.apache.poi.poifs.filesystem.POIFSFileSystem in project poi by apache.

the class TestFormatTrackingHSSFListener method processFile.

private void processFile(String filename) throws Exception {
    HSSFRequest req = new HSSFRequest();
    mockListen = new MockHSSFListener();
    listener = new FormatTrackingHSSFListener(mockListen);
    req.addListenerForAllRecords(listener);
    File file = HSSFTestDataSamples.getSampleFile(filename);
    HSSFEventFactory factory = new HSSFEventFactory();
    POIFSFileSystem fs = new POIFSFileSystem(file);
    factory.processWorkbookEvents(req, fs);
    fs.close();
}

Example 42 with POIFSFileSystem

use of org.apache.poi.poifs.filesystem.POIFSFileSystem in project poi by apache.

the class TestMissingRecordAwareHSSFListener method readRecords.

private void readRecords(String sampleFileName) {
    HSSFRequest req = new HSSFRequest();
    MockHSSFListener mockListen = new MockHSSFListener();
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(mockListen);
    req.addListenerForAllRecords(listener);
    HSSFEventFactory factory = new HSSFEventFactory();
    try {
        InputStream is = HSSFTestDataSamples.openSampleFileStream(sampleFileName);
        POIFSFileSystem fs = new POIFSFileSystem(is);
        factory.processWorkbookEvents(req, fs);
    } catch (IOException e) {
        throw new RuntimeException(e);
    }
    r = mockListen.getRecords();
    assertTrue(r.length > 100);
}

Example 43 with POIFSFileSystem

use of org.apache.poi.poifs.filesystem.POIFSFileSystem in project poi by apache.

the class TestExcelExtractor method createExtractor.

private static ExcelExtractor createExtractor(String sampleFileName) throws IOException {
    File file = HSSFTestDataSamples.getSampleFile(sampleFileName);
    POIFSFileSystem fs = new POIFSFileSystem(file);
    ExcelExtractor extractor = new ExcelExtractor(fs);
    extractor.setFilesystem(fs);
    return extractor;
}

Example 44 with POIFSFileSystem

use of org.apache.poi.poifs.filesystem.POIFSFileSystem in project poi by apache.

the class TestExcelExtractor method testWithEmbededInOwn.

/**
	 * Excel embeded in excel
	 */
@Test
public void testWithEmbededInOwn() throws Exception {
    POIDataSamples ssSamples = POIDataSamples.getSpreadSheetInstance();
    POIFSFileSystem fs = null;
    HSSFWorkbook wbA = null, wbB = null;
    ExcelExtractor exA = null, exB = null, ex = null;
    try {
        fs = new POIFSFileSystem(ssSamples.getFile("excel_with_embeded.xls"));
        DirectoryNode dirA = (DirectoryNode) fs.getRoot().getEntry("MBD0000A3B5");
        DirectoryNode dirB = (DirectoryNode) fs.getRoot().getEntry("MBD0000A3B4");
        wbA = new HSSFWorkbook(dirA, fs, true);
        wbB = new HSSFWorkbook(dirB, fs, true);
        exA = new ExcelExtractor(wbA);
        exB = new ExcelExtractor(wbB);
        assertEquals("Sheet1\nTest excel file\nThis is the first file\nSheet2\nSheet3\n", exA.getText());
        assertEquals("Sample Excel", exA.getSummaryInformation().getTitle());
        assertEquals("Sheet1\nAnother excel file\nThis is the second file\nSheet2\nSheet3\n", exB.getText());
        assertEquals("Sample Excel 2", exB.getSummaryInformation().getTitle());
        // And the base file too
        ex = new ExcelExtractor(fs);
        assertEquals("Sheet1\nI have lots of embeded files in me\nSheet2\nSheet3\n", ex.getText());
        assertEquals("Excel With Embeded", ex.getSummaryInformation().getTitle());
    } finally {
        if (ex != null)
            ex.close();
        if (exB != null)
            exB.close();
        if (exA != null)
            exA.close();
        if (wbB != null)
            wbB.close();
        if (wbA != null)
            wbA.close();
        if (fs != null)
            fs.close();
    }
}

Example 45 with POIFSFileSystem

use of org.apache.poi.poifs.filesystem.POIFSFileSystem in project poi by apache.

the class TestExcelExtractor method testWithEmbeded.

/**
	 * Embeded in a non-excel file
	 */
@Test
public void testWithEmbeded() throws Exception {
    POIFSFileSystem fs = null;
    HSSFWorkbook wbA = null, wbB = null;
    ExcelExtractor exA = null, exB = null;
    try {
        fs = new POIFSFileSystem(POIDataSamples.getDocumentInstance().getFile("word_with_embeded.doc"));
        DirectoryNode objPool = (DirectoryNode) fs.getRoot().getEntry("ObjectPool");
        DirectoryNode dirA = (DirectoryNode) objPool.getEntry("_1269427460");
        DirectoryNode dirB = (DirectoryNode) objPool.getEntry("_1269427461");
        wbA = new HSSFWorkbook(dirA, fs, true);
        exA = new ExcelExtractor(wbA);
        wbB = new HSSFWorkbook(dirB, fs, true);
        exB = new ExcelExtractor(wbB);
        assertEquals("Sheet1\nTest excel file\nThis is the first file\nSheet2\nSheet3\n", exA.getText());
        assertEquals("Sample Excel", exA.getSummaryInformation().getTitle());
        assertEquals("Sheet1\nAnother excel file\nThis is the second file\nSheet2\nSheet3\n", exB.getText());
        assertEquals("Sample Excel 2", exB.getSummaryInformation().getTitle());
    } finally {
        if (exB != null)
            exB.close();
        if (wbB != null)
            wbB.close();
        if (exA != null)
            exA.close();
        if (wbA != null)
            wbA.close();
        if (fs != null)
            fs.close();
    }
}