POI를 이용하여 word, excel 텍스트 추출

출처 http://ndarkness.tistory.com/9

<워드>

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); } }

<엑셀>

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); } }