excel文本提取

需要导入poi-3.9-20121203.jar

import java.io.FileInputStream;
import java.io.InputStream;


import org.apache.poi.hssf.extractor.ExcelExtractor;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class Poi4 {
    
public static void main(String[] args) throws Exception {
//创建读取流
InputStream fs = new  FileInputStream("d:\\简单的工作簿.xlsx");
//包装
POIFSFileSystem pfs = new POIFSFileSystem(fs);
//创建一个工作簿
HSSFWorkbook wb = new HSSFWorkbook(pfs);

ExcelExtractor excelExtractor=new ExcelExtractor(wb);
//设置sheet不显示
//excelExtractor.setIncludeSheetNames(false);
System.out.println(excelExtractor.getText());
}
}

效果图