- XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(
- filename));
- private String getValueFromCell(XSSFCell cell) {
- String cellvalue;
- switch(cell.getCellType()){
- // Cell的Type为NUMERIC
- case HSSFCell.CELL_TYPE_NUMERIC: {
- // 判断当前的cell是否为Date
- if (HSSFDateUtil.isCellDateFormatted(cell)) {
- // 如果是Date类型则,取得该Cell的Date值
- Date date = cell.getDateCellValue();
- // 把Date转换成本地格式的字符串
- cellvalue = cell.getDateCellValue().toLocaleString();
- } else { // 如果是纯数字
- // 取得当前Cell的数值,强制转换为int
- Integer num = new Integer(
- (int) cell.getNumericCellValue());
- cellvalue = String.valueOf(num);
- }
- break;
- }
- // Cell的Type为STRING
- case HSSFCell.CELL_TYPE_STRING:
- // 取得当前的Cell字符串
- cellvalue = cell.getStringCellValue().replaceAll("'", "''");
- break;
- // 默认的Cell值
- default:
- cellvalue = " ";
- }
- return cellvalue;
- }
- //该片段来自于http://www.codesnippet.cn/detail/0809201615050.html
来源: http://www.codesnippet.cn/detail/0809201615050.html