读出数据!
先记录一下,等有空了再好好整理
package com.***.util;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.shiro.SecurityUtils;
public class POIUtils {
public static Workbook getWorkbook(InputStream inStr,String fileName) throws Exception{
Workbook wb = null;
String fileType = fileName.substring(fileName.lastIndexOf("."));
if(fileName.endsWith("xls")){
wb = new HSSFWorkbook(inStr); //2003-
}else if(fileName.endsWith("xlsx")){
wb = new XSSFWorkbook(inStr); //2007+
}
else{
throw new Exception("解析的文件格式有误!");
}
return wb;
}
public static void ReadExcel(File file) {
try {
// 创建输入流,读取Excel
InputStream inStr = new FileInputStream(file.getAbsolutePath());
// jxl提供的Workbook类
Workbook wb = getWorkbook(inStr,"58简历.xls");
// Excel的页签数量
int sheet_size = wb.getNumberOfSheets();
for (int index = 0; index < sheet_size; index++) {
// 每个页签创建一个Sheet对象
Sheet sheet = wb.getSheetAt(index);
// sheet.getRows()返回该页的总行数
for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) {
// sheet.getColumns()返回该页的总列数
Row row = sheet.getRow(i);
// for(Cell cell:row){
// System.out.println(getCellValue(cell));
//
// }
}
}
} catch (Exception e) {
e.printStackTrace();
}
}}