需要导入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());
}
}
效果图