/**
* 读取xlsx文档列
* */
private String getXSSFCellValue(XSSFCell cell)throws Exception
{
String cellvalue = "";
if (cell!=null) {
switch (cell.getCellType()) {
case XSSFCell.CELL_TYPE_BOOLEAN:
cellvalue = String.valueOf(cell.getBooleanCellValue());
break;
case XSSFCell.CELL_TYPE_NUMERIC:
cellvalue = String.valueOf(cell.getNumericCellValue());
break;
case XSSFCell.CELL_TYPE_STRING:
cellvalue = cell.getStringCellValue();
break;
case XSSFCell.CELL_TYPE_BLANK:
break;
case XSSFCell.CELL_TYPE_ERROR:
break;
case XSSFCell.CELL_TYPE_FORMULA:
break;
}
}
return cellvalue;
}
/**
* 读取xls文档列
* */
private String getHSSFCellValue(HSSFCell cell)throws Exception
{
String cellvalue = "";
if(cell!=null){
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_BOOLEAN:
cellvalue = String.valueOf(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_NUMERIC:
cellvalue = String.valueOf(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
cellvalue = cell.getStringCellValue();
break;
case HSSFCell.CELL_TYPE_BLANK:
break;
case HSSFCell.CELL_TYPE_ERROR:
break;
case HSSFCell.CELL_TYPE_FORMULA:
break;
}
}
return cellvalue;
}
/**
* xlsx文档
* @return 错误提示类型 0-正常 1-存在不能为空的列 2-格式不对 3-空文件
* */
private int readXlsx(List<XXDto> list,InputStream inputstream) throws Exception {
int errType = 0;
XSSFWorkbook hssfworkbook = new XSSFWorkbook(inputstream);
XSSFSheet hssfsheet = hssfworkbook.getSheetAt(0);// 第一个工作表
if (hssfsheet != null) {
int totalrows = hssfsheet.getPhysicalNumberOfRows();// --获取sheet总行数
if (totalrows > 1)// 除了标题外,必须有数据
{
for (int i = 1; i < totalrows; i++) {
XSSFRow hssfrow = hssfsheet.getRow(i);
}
}
else{
//--空excel,或者没有数据行的excel
errType = 3;
}
}
return errType;
}
/**
* xls文档
* @return 错误提示类型 0-正常 1-存在不能为空的列 2-格式不对 3-空文件
* */
private int readXlsKpiYear(List<XXDto> list,InputStream inputstream) throws Exception {
int errType = 0;
HSSFWorkbook hssfworkbook = new HSSFWorkbook(inputstream);
HSSFSheet hssfsheet = hssfworkbook.getSheetAt(0);// 第一个工作表
if (hssfsheet != null) {
int totalrows = hssfsheet.getPhysicalNumberOfRows();// --获取sheet总行数
if (totalrows > 1)// 除了标题外,必须有数据
{
for (int i = 1; i < totalrows; i++) {
HSSFRow hssfrow = hssfsheet.getRow(i);
}
}else{
//--空excel,或者没有数据行的excel
errType = 3;
}
}
return errType;
}
读取xls和xlsx
最新推荐文章于 2024-08-08 08:28:26 发布