/*
* 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.ooxml;
import java.io.InputStream;
import java.util.Locale;
import junit.framework.TestCase;
import org.apache.tika.metadata.Metadata;
import org.apache.tika.metadata.TikaMetadataKeys;
import org.apache.tika.parser.Parser;
import org.apache.tika.sax.BodyContentHandler;
import org.xml.sax.ContentHandler;
import org.apache.tika.parser.AutoDetectParser;
public class OOXMLParserTest extends TestCase {
// TODO: This is a workaround until TIKA-371 is fixed
private Locale defaultLocale;
protected void setUp() {
defaultLocale = Locale.getDefault();
Locale.setDefault(Locale.US);
}
protected void tearDown() {
Locale.setDefault(defaultLocale);
}
public void testExcel() throws Exception {
InputStream input = OOXMLParserTest.class
.getResourceAsStream("/test-documents/testEXCEL.xlsx");
Parser parser = new AutoDetectParser();
Metadata metadata = new Metadata();
// TODO: should auto-detect without the resource name
metadata.set(Metadata.RESOURCE_NAME_KEY, "testEXCEL.xlsx");
ContentHandler handler = new BodyContentHandler();
try {
parser.parse(input, handler, metadata);
assertEquals(
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
metadata.get(Metadata.CONTENT_TYPE));
assertEquals("Simple Excel document", metadata.get(Metadata.TITLE));
assertEquals("Keith Bennett", metadata.get(Metadata.AUTHOR));
String content = handler.toString();
assertTrue(content.contains("Sample Excel Worksheet"));
assertTrue(content.contains("Numbers and their Squares"));
assertTrue(content.contains("9"));
assertFalse(content.contains("9.0"));
assertTrue(content.contains("196"));
assertFalse(content.contains("196.0"));
assertEquals("false", metadata.get(TikaMetadataKeys.PROTECTED));
} finally {
input.close();
}
}
public void testExcelFormats() throws Exception {
InputStream input = OOXMLParserTest.class
.getResourceAsStream("/test-documents/testEXCEL-formats.xlsx");
Parser parser = new AutoDetectParser();
Metadata metadata = new Metadata();
// TODO: should auto-detect without the resource name
metadata.set(Metadata.RESOURCE_NAME_KEY, "testEXCEL-formats.xlsx");
ContentHandler handler = new BodyContentHandler();
try {
parser.parse(input, handler, metadata);
assertEquals(
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
metadata.get(Metadata.CONTENT_TYPE));
String content = handler.toString();
// Number #,##0.00
assertTrue(content.contains("1,599.99"));
assertTrue(content.contains("-1,599.99"));
// Currency $#,##0.00;[Red]($#,##0.00)
assertTrue(content.contains("$1,599.99"));
assertTrue(content.contains("($1,599.99)"));
// Scientific 0.00E+00
assertTrue(content.contains("1.98E08"));
assertTrue(content.contains("-1.98E08"));
// Percentage
assertTrue(content.contains("2%"));
assertTrue(content.contains("2.50%"));
// Time Format: h:mm
assertTrue(content.contains("6:15"));
assertTrue(content.contains("18:15"));
// Date Format: d-mmm-yy
assertTrue(content.contains("17-May-07"));
// Below assertions represent outstanding formatting issues to be addressed
// they are included to allow the issues to be progressed with the Apache POI
// team - See TIKA-103.
/*************************************************************************
// Date Format: m/d/yy
assertTrue(content.contains("03/10/2009"));
// Date/Time Format
assertTrue(content.contains("19/01/2008 04:35"));
// Custom Number (0 "dollars and" .00 "cents")
assertTrue(content.contains("19 dollars and .99 cents"));
// Custom Number ("At" h:mm AM/PM "on" dddd mmmm d"," yyyy)
assertTrue(content.contains("At 4:20 AM on Thursday May 17, 2007"));
// Fraction (2.5): # ?/?
assertTrue(content.contains("2 1 / 2"));
**************************************************************************/
} finally {
input.close();
}
}
public void testPowerPoint() throws Exception {
InputStream input = OOXMLParserTest.class
.getResourceAsStream("/test-documents/testPPT.pptx");
Parser parser = new AutoDetectParser();
Metadata metadata = new Metadata();
// TODO: should auto-detect without the resource name
metadata.set(Metadata.RESOURCE_NAME_KEY, "testPPT.pptx");
ContentHandler handler = new BodyContentHandler();
try {
parser.parse(input, handler, metadata);
assertEquals(
"application/vnd.openxmlformats-officedocument.presentationml.presentation",
metadata.get(Metadata.CONTENT_TYPE));
assertEquals("Sample Powerpoint Slide", metadata.get(Metadata.TITLE));
assertEquals("Keith Bennett", metadata.get(Metadata.AUTHOR));
String content = handler.toString();
assertTrue(content.contains("Sample Powerpoint Slide"));
assertTrue(content.contains("Powerpoint X for Mac"));
} finally {
input.close();
}
}
public void testWord() throws Exception {
InputStream input = OOXMLParserTest.class
.getResourceAsStream("/test-documents/testWORD.docx");
Parser parser = new AutoDetectParser();
Metadata metadata = new Metadata();
// TODO: should auto-detect without the resource name
metadata.set(Metadata.RESOURCE_NAME_KEY, "testWORD.docx");
ContentHandler handler = new BodyContentHandler();
try {
parser.parse(input, handler, metadata);
assertEquals(
"application/vnd.openxmlformats-officedocument.wordprocessingml.document",
metadata.get(Metadata.CONTENT_TYPE));
assertEquals("Sample Word Document", metadata.get(Metadata.TITLE));
assertEquals("Keith Bennett", metadata.get(Metadata.AUTHOR));
assertTrue(handler.toString().contains("Sample Word Document"));
} finally {
input.close();
}
}
public void testProtectedExcel() throws Exception {
InputStream input = OOXMLParserTest.class
.getResourceAsStream("/test-documents/protected.xlsx");
Parser parser = new AutoDetectParser();
Metadata metadata = new Metadata();
ContentHandler handler = new BodyContentHandler();
try {
parser.parse(input, handler, metadata);
assertEquals(
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
metadata.get(Metadata.CONTENT_TYPE));
assertEquals("true", metadata.get(TikaMetadataKeys.PROTECTED));
} finally {
input.close();
}
}
}