OldExcelParserTest.java

/*
 * 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.tika.parser.microsoft;

import static org.apache.tika.parser.microsoft.AbstractPOIContainerExtractionTest.getTestFile;
import static org.junit.jupiter.api.Assertions.assertEquals;

import org.junit.jupiter.api.Disabled;
import org.junit.jupiter.api.Test;
import org.xml.sax.ContentHandler;

import org.apache.tika.TikaTest;
import org.apache.tika.detect.DefaultDetector;
import org.apache.tika.detect.Detector;
import org.apache.tika.io.TikaInputStream;
import org.apache.tika.metadata.Metadata;
import org.apache.tika.metadata.TikaCoreProperties;
import org.apache.tika.mime.MediaType;
import org.apache.tika.parser.ParseContext;
import org.apache.tika.sax.BodyContentHandler;

/**
 * Tests for the Old Excel (2-4) parser
 */
public class OldExcelParserTest extends TikaTest {
    private static final String file = "testEXCEL_4.xls";

    @Test
    public void testDetection() throws Exception {
        Detector detector = new DefaultDetector();
        try (TikaInputStream tis = getTestFile(file)) {
            assertEquals(MediaType.application("vnd.ms-excel.sheet.4"),
                    detector.detect(tis, new Metadata(), new ParseContext()));
        }
    }

    // Disabled, until we can get the POI code to tell us the version
    @Test
    @Disabled
    public void testMetadata() throws Exception {
        TikaInputStream tis = getTestFile(file);

        Metadata metadata = new Metadata();
        ContentHandler handler = new BodyContentHandler();

        OldExcelParser parser = new OldExcelParser();
        parser.parse(tis, handler, metadata, new ParseContext());

        // We can get the content type
        assertEquals("application/vnd.ms-excel.sheet.4", metadata.get(Metadata.CONTENT_TYPE));

        // But no other metadata
        assertEquals(null, metadata.get(TikaCoreProperties.TITLE));
        assertEquals(null, metadata.get(TikaCoreProperties.SUBJECT));
    }

    /**
     * Check we can get the plain text properly
     */
    @Test
    public void testPlainText() throws Exception {
        ContentHandler handler = new BodyContentHandler();
        Metadata metadata = new Metadata();

        try (TikaInputStream tis = getTestFile(file)) {
            new OldExcelParser().parse(tis, handler, metadata, new ParseContext());
        }

        String text = handler.toString();

        // Check we find a few words we expect in there
        assertContains("Size", text);
        assertContains("Returns", text);

        // Check we find a few numbers we expect in there
        assertContains("11", text);
        assertContains("784", text);
    }

    /**
     * Check the HTML version comes through correctly
     */
    @Test
    public void testHTML() throws Exception {
        XMLResult result = getXML(file);
        String xml = result.xml;

        // Sheet name not found - only 5+ have sheet names
        assertNotContained("<p>Sheet 1</p>", xml);

        // String cells
        assertContains("<p>Table 10 -", xml);
        assertContains("<p>Tax</p>", xml);
        assertContains("<p>N/A</p>", xml);

        // Number cells
        assertContains("<p>(1)</p>", xml);
        assertContains("<p>5.0</p>", xml);
    }


    @Test
    public void testToXMLInOldExcelParser() throws Exception {
        String xml = getXML("testEXCEL_5.xls").xml;
        assertContains("Written and saved in Microsoft Excel X for Mac Service Release 1", xml);
    }
}