java cellvalue_Java Cell.getDateCellValue方法代码示例

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

public final static PartitionMap readDatas(Sheet i_Sheet ,Integer i_BeginRow ,Integer i_EndRow)

{

PartitionMap v_Ret = new TablePartition();

Sheet v_Sheet = i_Sheet;

int v_BeginRow = 0;

int v_EndRow = 0;

if ( i_BeginRow != null )

{

v_BeginRow = i_BeginRow.intValue();

if ( v_BeginRow < 0 )

{

v_BeginRow = 0;

}

}

if ( i_EndRow != null )

{

v_EndRow = i_EndRow.intValue();

}

else

{

v_EndRow = v_Sheet.getPhysicalNumberOfRows();

}

for (int v_RowNo=v_BeginRow; v_RowNo<=v_EndRow; v_RowNo++)

{

Row v_Row = v_Sheet.getRow(v_RowNo);

if ( v_Row == null )

{

continue;

}

short v_CellCount = v_Row.getLastCellNum();

for (int v_ColumnNo=0; v_ColumnNo

{

Cell v_Cell = v_Row.getCell(v_ColumnNo);

if ( v_Cell == null )

{

continue;

}

if ( v_Cell.getCellTypeEnum() == CellType.STRING )

{

String v_Value = v_Cell.getStringCellValue();

if ( !Help.isNull(v_Value) )

{

RCell v_RCell = new RCell(v_RowNo ,v_ColumnNo);

List v_Decimals = StringHelp.getString(v_Cell.getCellStyle().getDataFormatString() ,$Decimal);

if ( !Help.isNull(v_Decimals) )

{

v_RCell.setDecimal(v_Decimals.get(0).split("\\.")[1].length());

}

v_Ret.putRow(v_Value.trim() ,v_RCell);

}

}

else if ( v_Cell.getCellTypeEnum() == CellType.NUMERIC )

{

if ( HSSFDateUtil.isCellDateFormatted(v_Cell) )

{

if ( v_Cell.getDateCellValue() != null )

{

v_Ret.putRow((new Date(v_Cell.getDateCellValue())).getFull() ,new RCell(v_RowNo ,v_ColumnNo));

}

}

else

{

v_Ret.putRow(String.valueOf(v_Cell.getNumericCellValue()) ,new RCell(v_RowNo ,v_ColumnNo));

}

}

}

}

return v_Ret;

}