java全文检索word中的内容_搜索引擎时对WORD,EXCEL,PDF,POWERPOINT文件全文检索的总结...

这篇博客总结了使用JAVA进行全文检索时,如何读取并处理WORD, EXCEL, PDF, POWERPOINT文件的内容。通过Apache POI库处理OFFICE文档,PDFBOX库处理PDF文件,实现了对这些文件的全文检索。" 73835814,3100793,命令模式:理解行为设计模式的应用,"['设计模式', '行为模式', '软件设计', '系统优化', '编程原理']
摘要由CSDN通过智能技术生成

搜索引擎时对WORD,EXCEL,PDF,POWERPOINT文件全文检索的总结

(2012-02-12 16:31:59)

标签:

pdf文档

幻灯片

pdf文件

全文检索

控件

it

JAVA读取WORD,EXCEL,POWERPOINT,PDF文件的方法

http://blog.sina.com.cn/u/54c1567b010008vh

OFFICE文档使用POI控件,PDF可以使用PDFBOX0.7.3控件,完全支持中文,用XPDF也行,不过感觉PDFBOX比较好,而且作者也在更新。水平有限,万望各位指正

WORD:

import org.apache.lucene.document.Document;

import org.apache.lucene.document.Field;

import org.apache.poi.hwpf.extractor.WordExtractor;

import java.io.File;

import java.io.InputStream;

import java.io.FileInputStream;

import com.search.code.Index;

public Document getDocument(Index index, String url, String title,

InputStream is) throws DocCenterException {

String bodyText = null;

try {

WordExtractor ex = new

WordExtractor(is);//is是WORD文件的InputStream

bodyText = ex.getText();

if(!bodyText.equals( " ")){

index.AddIndex(url, title, bodyText);

}

}catch (DocCenterException e) {

throw new DocCenterException( "无法从该Mocriosoft Word文档中提取内容 ",

e);

}catch(Exception e){

e.printStackTrace();

}

}

return null;

}

Excel:

import org.apache.lucene.document.Document;

import org.apache.lucene.document.Field;

import org.apache.poi.hwpf.extractor.WordExtractor;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFCell;

import java.io.File;

import java.io.InputStream;

import java.io.FileInputStream;

import com.search.code.Index;

public Document getDocument(Index index, String url, String title,

InputStream is) throws DocCenterException {

StringBuffer content = new StringBuffer();

try{

HSSFWorkbook workbook = new

HSSFWorkbook(is);//创建对Excel工作簿文件的引用

for (int numSheets = 0; numSheets <

workbook.getNumberOfSheets(); numSheets++) {

if (null != workbook.getSheetAt(numSheets)) {

HSSFSheet aSheet = workbook.getSheetAt(numSheets);//获得一个sheet

for (int rowNumOfSheet = 0; rowNumOfSheet <=

aSheet.getLastRowNum(); rowNumOfSheet++) {

if (null != aSheet.getRow(rowNumOfSheet)) {

HSSFRow aRow = aSheet.getRow(rowNumOfSheet); //获得一个行

for (short cellNumOfRow = 0; cellNumOfRow <=

aRow.getLastCellNum(); cellNumOfRow++) {

if (null != aRow.getCell(cellNumOfRow)) {

HSSFCell aCell = aRow.getCell(cellNumOfRow);//获得列值

content.append(aCell.getStringCellValue());

}

}

}

}

}

}

if(!content.equals( " ")){

index.AddIndex(url, title, content.toString());

}

}catch (DocCenterException e) {

throw new DocCenterException( "无法从该Mocriosoft Word文档中提取内容 ",

e);

}catch(Exception e) {

System.out.println( "已运行xlRead() : " + e );

}

return null;

}

PowerPoint:

import java.io.InputStream;

import org.apache.lucene.document.Document;

import org.apache.poi.hslf.HSLFSlideShow;

import org.apache.poi.hslf.model.TextRun;

import org.apache.poi.hslf.model.Slide;

import org.apache.poi.hslf.usermodel.SlideShow;

public Document getDocument(Index index, String url, String title,

InputStream is)

throws DocCenterException {

StringBuffer content = new StringBuffer( " ");

try{

SlideShow ss = new SlideShow(new HSLFSlideShow(is));//is

为文件的InputStream,建立SlideShow

Slide[] slides = ss.getSlides();//获得每一张幻灯片

for(int i=0;i

TextRun[] t =

slides[i].getTextRuns();//为了取得幻灯片的文字内容,建立TextRun

for(int j=0;j

content.append(t[j].getText());//这里会将文字内容加到content中去

}

content.append(slides[i].getTitle());

}

index.AddIndex(url, title, content.toString());

}catch(Exception ex){

System.out.println(ex.toString());

}

return null;

}

PDF:

import java.io.InputStream;

import java.io.IOException;

import org.apache.lucene.document.Document;

import org.pdfbox.cos.COSDocument;

import org.pdfbox.pdfparser.PDFParser;

import org.pdfbox.pdmodel.PDDocument;

import org.pdfbox.pdmodel.PDDocumentInformation;

import org.pdfbox.util.PDFTextStripper;

import com.search.code.Index;

public Document getDocument(Index index, String url, String title,

InputStream is)throws DocCenterException {

COSDocument cosDoc = null;

try {

cosDoc = parseDocument(is);

} catch (IOException e) {

closeCOSDocument(cosDoc);

throw new DocCenterException( "无法处理该PDF文档 ", e);

}

if (cosDoc.isEncrypted()) {

if (cosDoc != null)

closeCOSDocument(cosDoc);

throw new DocCenterException( "该PDF文档是加密文档,无法处理 ");

}

String docText = null;

try {

PDFTextStripper stripper = new PDFTextStripper();

docText = stripper.getText(new PDDocument(cosDoc));

} catch (IOException e) {

closeCOSDocument(cosDoc);

throw new DocCenterException( "无法处理该PDF文档 ", e);

}

PDDocument pdDoc = null;

try {

pdDoc = new PDDocument(cosDoc);

PDDocumentInformation docInfo =

pdDoc.getDocumentInformation();

if(docInfo.getTitle()!=null &&

!docInfo.getTitle().equals( " ")){

title = docInfo.getTitle();

}

} catch (Exception e) {

closeCOSDocument(cosDoc);

closePDDocument(pdDoc);

System.err.println( "无法取得该PDF文档的元数据 " + e.getMessage());

} finally {

closeCOSDocument(cosDoc);

closePDDocument(pdDoc);

}

return null;

}

private static COSDocument parseDocument(InputStream is) throws

IOException {

PDFParser parser = new PDFParser(is);

parser.parse();

return parser.getDocument();

}

private void closeCOSDocument(COSDocument cosDoc) {

if (cosDoc != null) {

try {

cosDoc.close();

} catch (IOException e) {

}

}

}

private void closePDDocument(PDDocument pdDoc) {

if (pdDoc != null) {

try {

pdDoc.close();

} catch (IOException e) {

}

}

}

代码复制可能出错,不过代码经过测试,绝对能用,POI为3.0-rc4,PDFBOX为0.7.3

POI: http://jakarta.apache.org/poi/index.html

PDFBOX: http://www.pdfbox.org/

分享:

a4c26d1e5885305701be709a3d33442f.png喜欢

0

a4c26d1e5885305701be709a3d33442f.png赠金笔

加载中,请稍候......

评论加载中,请稍候...

发评论

登录名: 密码: 找回密码 注册记住登录状态

昵   称:

评论并转载此博文

a4c26d1e5885305701be709a3d33442f.png

发评论

以上网友发言只代表其个人观点,不代表新浪网的观点或立场。

Excel2003常用函数完全手册 目 录 一、函数应用基础........... 1 (一)函数和公式................. 1 1.什么是函数…................. 1 2.什么是公式…................. 1 (二)函数的参数.................. 1 1.常量............….................. 1 2.逻辑值............….............. 1 3.数组..............…................ 1 4.错误值..........…................ 1 5.单元格引用.…................. 1 6.嵌套函数...…................... 2 7.名称和标志......…........................ 2 (三)函数输入方法............... 2 1.“插入函数”对话框.….. 2 2.编辑栏输入.................….. 3 二、函数速查一览.............. 3 (一)数据库函数............... 3 1.DAVERAGE..................... 3 2.DCOUNT.............…......... 3 3.DCOUNTA...........…......... 3 4.DGET............………......... 3 5.DMAX............……........... 3 6.DMIN..............………....... 3 7.DPRODUCT...................... 3 8.DSTDEV...........……......... 3 9.DSTDEVP..........…............ 4 10.DSUM...............……........ 4 11.DVAR...............………..... 4 12.DVARP.............……......... 4 13.GETPIVOTDATA............. 4 (二)日期与间函数......... 4 1.DATE.................…….......... 4 2.DATEVALUE....….............. 4 3.DAY...................……........... 4 4.DAYS360...……................... 5 5.EDATE.......…...................... 5 6.EOMONTH..........…........................ 5 7.HOUR..........….................... 5 8.MINUTE.....…..................... 5 9.MONTH............................. 5 10.NETWORKDAYS ........... 5 11.NOW..........…................... 6 12.SECOND..….................... 6 13.TIME.........…................... 6 14.TIMEVALUE .................. 6 15.TODAY......…................... 6 16.WEEKDAY....................... 6 17.WEEKNUM...................... 6 18.WORKDAY....................... 6 19.YEAR........….................... 7 20.YEARFRAC ..................... 7 (三)外部函数....................... 7 1.EUROCONVERT ................ 7 2.SQL.REQUEST ......…..................... 7 (四)工程函数....................... 7 1.BESSELI.........…….............. 7 2.BESSELJ..........……......
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值