Shulou(Shulou.com)06/03 Report--

Study notes in excel text mode area

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

/ / text reading

Public class Demo2 {

Public static void main (String [] args) throws Exception {

InputStream is = new FileInputStream ("E:\\ data.xls")

POIFSFileSystem fs = new POIFSFileSystem (is)

HSSFWorkbook wb = new HSSFWorkbook (fs); / / create a new workbook

/ / text reading

ExcelExtractor excelExtractor = new ExcelExtractor (wb)

ExcelExtractor.setIncludeSheetNames (false); / / No shell title is required

System.out.println (excelExtractor.getText ()); / / text reading

}

}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.