一个简单的全部读取excel内容的方法,基本思路是全部非空单元格读取后拼接起来
public static String readExcel(String path){
StringBuffer content = new StringBuffer("");// 文档内容
try {
FileInputStream is = new FileInputStream(new File(path));
HSSFWorkbook wb = new HSSFWorkbook(is);
int sheetNumbers = wb.getNumberOfSheets();
for(int i=0;i<sheetNumbers;i++){
HSSFSheet sheet = wb.getSheetAt(i);
int rows = sheet.getLastRowNum();
for(int j=0;j<=rows;j++){
HSSFRow row = sheet.getRow(j);
if(null!=row){
int cells = row.getLastCellNum();
for(int k=0;k<=cells;k++){
HSSFCell cell = row.getCell(k);
if(cell!=null)
content.append(cell.toString());
}
}
}
}
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return content.toString().trim();
}