How to use

getContents

method

in

org.pentaho.di.core.spreadsheet.KCell

private boolean isLineEmpty( KCell[] line ) {
 if ( line.length == 0 ) {
  return true;
 }
 boolean isEmpty = true;
 for ( int i = 0; i < line.length && isEmpty; i++ ) {
  if ( line[i] != null && !Utils.isEmpty( line[i].getContents() ) ) {
   isEmpty = false;
  }
 }
 return isEmpty;
}

 private String cellToStr( KCell cell ) {
  String result = "null";
  if ( cell != null ) {
   result = cell.getContents();
  }
  return result;
 }
}

.getType() == ValueMetaInterface.TYPE_DATE ) ) {
throw new KettleException( BaseMessages.getString( PKG, "ExcelInput.Exception.InvalidTypeDate", cell
 .getContents(), v.getTypeDesc() ) );
|| v.getType() == ValueMetaInterface.TYPE_NUMBER ) {
throw new KettleException( BaseMessages.getString( PKG, "ExcelInput.Exception.InvalidTypeLabel", cell
 .getContents(), v.getTypeDesc() ) );
|| v.getType() == ValueMetaInterface.TYPE_BIGNUMBER || v.getType() == ValueMetaInterface.TYPE_NUMBER ) ) {
throw new KettleException( BaseMessages.getString( PKG, "ExcelInput.Exception.InvalidTypeNumber", cell
 .getContents(), v.getTypeDesc() ) );
.getType().getDescription(), cell.getContents() ) );

KCellType ct = cell.getType();
logDetailed( BaseMessages.getString( PKG, "ExcelInput.Log.UnknownType", ( ( ct != null ) ? ct
 .toString() : "null" ), cell.getContents() ) );

if ( cell.getType() != KCellType.EMPTY ) {
 fieldname = cell.getContents();