ReadExcelUtils帮助类


对一些常用的格式做了处理,替换了换行和一些空格

package com.concom.imports.utils;

import java.text.DecimalFormat;
import java.util.regex.Pattern;

import org.apache.poi.ss.usermodel.Cell;

/**
* @author Cao Zhili
* @date 2015年5月20日
*/
public class ReadExcelUtils {

private final static Pattern pattern = Pattern.compile("\\s*|\t|\r|\n");

private final static DecimalFormat df = new DecimalFormat("#.0000");

/**
* 获取单元格的值
*
* @param cell
* @return
*/
public static String getCellValue(Cell cell) {
String val = "";
if (cell == null)
return val;

switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
val = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BOOLEAN:
val = String.valueOf(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
//val = cell.getCellFormula();
try {
double doubleVal = cell.getNumericCellValue();
val = df.format(doubleVal);
} catch (IllegalStateException e) {
val = String.valueOf(cell.getRichStringCellValue());
}
break;
case Cell.CELL_TYPE_NUMERIC:
val = String.valueOf(cell.getNumericCellValue());
break;
case Cell.CELL_TYPE_BLANK:
val = "";
break;
case Cell.CELL_TYPE_ERROR:
val = "";
break;
default:
break;
}
if(!"".equals(val)){
val = pattern.matcher(val).replaceAll("");
val = val.replaceAll("_x000D_", "");
}
return val;
}

public static String getCellValueTrim(Cell cell) {
String val = "";
if (cell == null)
return val;

switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
val = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BOOLEAN:
val = String.valueOf(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
//val = cell.getCellFormula();
try {
double doubleVal = cell.getNumericCellValue();
val = df.format(doubleVal);
} catch (IllegalStateException e) {
val = String.valueOf(cell.getRichStringCellValue());
}
break;
case Cell.CELL_TYPE_NUMERIC:
val = String.valueOf(cell.getNumericCellValue());
break;
case Cell.CELL_TYPE_BLANK:
val = "";
break;
case Cell.CELL_TYPE_ERROR:
val = "";
break;
default:
break;
}
if(!"".equals(val)){
val = val.trim();
val = val.replaceAll("_x000D_", "");
}
return val;
}

public static boolean isBlank(String str) {
int strLen;
if (str == null || (strLen = str.length()) == 0) {
return true;
}
for (int i = 0; i < strLen; i++) {
if ((Character.isWhitespace(str.charAt(i)) == false)) {
return false;
}
}
return true;
}
}

本站声明
本文转载自:http://czltx224.iteye.com/blog/2246806     作者:czltx224     发布日期:2015-09-29     本站转载的文章为个人学习借鉴使用,本站对版权不负任何法律责任。如果侵犯了您的隐私权益,请联系我们删除。


 
© 2014-2016 ITdaan.com 粤ICP备14056181号