?? testmsexcelextraction.java
字號:
/*
* File : $Source: /usr/local/cvs/opencms/test/org/opencms/search/extractors/TestMsExcelExtraction.java,v $
* Date : $Date: 2005/06/23 11:12:02 $
* Version: $Revision: 1.5 $
*
* This library is part of OpenCms -
* the Open Source Content Mananagement System
*
* Copyright (c) 2005 Alkacon Software GmbH (http://www.alkacon.com)
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* For further information about Alkacon Software GmbH, please see the
* company website: http://www.alkacon.com
*
* For further information about OpenCms, please see the
* project website: http://www.opencms.org
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
package org.opencms.search.extractors;
import java.io.InputStream;
import java.util.Map;
import junit.framework.TestCase;
/**
* Tests the text extraction form an Excel file.<p>
*/
public class TestMsExcelExtraction extends TestCase {
/**
* Default JUnit constructor.<p>
*
* @param arg0 JUnit parameters
*/
public TestMsExcelExtraction(String arg0) {
super(arg0);
}
/**
* Tests the basic Excel extraction.<p>
*
* @throws Exception if the test fails
*/
public void testBasicExcelExtration() throws Exception {
// open an input stream for the test file
InputStream in = getClass().getClassLoader().getResourceAsStream("org/opencms/search/extractors/test1.xls");
// extract the content
I_CmsExtractionResult extractionResult = CmsExtractorMsExcel.getExtractor().extractText(in);
String result = extractionResult.getContent();
System.out.println("---------------------------------------------------------------");
System.out.println("Extracted from MS Excel:");
System.out.println(result);
assertTrue(result.indexOf("Alkacon Software") > -1);
assertTrue(result.indexOf("The OpenCms experts") > -1);
assertTrue(result.indexOf("Some content here.") > -1);
assertTrue(result.indexOf("Some content there.") > -1);
assertTrue(result.indexOf("Some content on a second sheet.") > -1);
assertTrue(result.indexOf("Some content on the third sheet.") > -1);
assertTrue(result.indexOf("\u00e4\u00f6\u00fc\u00c4\u00d6\u00dc\u00df\u20ac") > -1);
Map meta = extractionResult.getMetaInfo();
assertEquals("Alkacon Software - The OpenCms experts", meta.get(I_CmsExtractionResult.META_TITLE));
assertEquals("This is the subject", meta.get(I_CmsExtractionResult.META_SUBJECT));
assertEquals("Alexander Kandzior", meta.get(I_CmsExtractionResult.META_AUTHOR));
assertEquals("Alkacon Software", meta.get(I_CmsExtractionResult.META_COMPANY));
assertEquals("This is the comment", meta.get(I_CmsExtractionResult.META_COMMENTS));
assertEquals("Key1, Key2", meta.get(I_CmsExtractionResult.META_KEYWORDS));
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -