POI를 이용한 excel, word, powerpoint, visio 텍스트 추출

조건       : POI 3.5 이상

한글 추출도 잘된다.



[워드]

import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import org.apache.poi.hwpf.extractor.WordExtractor; public class POITest { public static void main(String args[]){ String src = "D:\\study\\data\\test.doc"; String text = null; try { File file = new File(src); InputStream is = new FileInputStream(file); WordExtractor wd = new WordExtractor(is); text = wd.getText(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } System.out.println(text); } }

[엑셀]
xls 에서 텍스트 추출하는 것은 그냥 하면 되는데,
xlsx 에서 텍스트를 추출하기 위해서는,
ooxml-lib 폴더 안의 4개의 jar 파일을 추가해줘야 한다.
그리고 log4j jar 파일도 추가해준다.

아직까지는 xlsx 추출이 완벽해 보이지는 않는다.

import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import org.apache.poi.hssf.extractor.ExcelExtractor; import org.apache.poi.poifs.filesystem.POIFSFileSystem; public class ExcelTest { public static void main(String args[]){ String src = "D:\\study\\data\\test.xls"; String text = null; try { File file = new File(src); InputStream is = new FileInputStream(file); ExcelExtractor extractor = new ExcelExtractor(new POIFSFileSystem(is)); text = extractor.getText(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } System.out.println(text); } } import java.io.IOException; import org.apache.poi.openxml4j.exceptions.OpenXML4JException; import org.apache.poi.xssf.extractor.XSSFExcelExtractor; import org.apache.xmlbeans.XmlException; public class ExcelTest { public static void main(String args[]){ String src2 = "D:\\study\\data\\test2.xlsx"; String text2 = null; try { XSSFExcelExtractor extractor2 = new XSSFExcelExtractor(src2); text2 = extractor2.getText(); } catch (XmlException e) { e.printStackTrace(); } catch (OpenXML4JException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } System.out.println(text2); } }