if ( cell.getValue() != null ) { if ( cell.getValue() instanceof Number ) { cellInfo.setRawNumber( (Number) cell.getValue() ); final Object value = cell.getValue(); if ( value == null || value.equals( "null" ) ) { cellValue = ""; try { DecimalFormat myFormatter = new DecimalFormat( "#,###.###" ); String output = myFormatter.format( cell.getValue() ); cellValue = output; } catch ( Exception e ) {
private void emitCell(SaxWriter writer, Cell cell) throws OlapException { ++cellOrdinal; Util.discard(cellOrdinal); // Ignore empty cells. final Object cellValue = cell.getValue(); if (cellValue == null) { return; } writer.startElement("row"); for (ColumnHandler columnHandler : columnHandlers) { columnHandler.write(writer, cell, members); } writer.endElement(); } }
public void write( SaxWriter writer, Cell cell, Member[] members) { if (cell.isNull()) { return; } Object value = cell.getValue(); final String dataType = (String) cell.getPropertyValue(StandardCellProperty.DATATYPE); final ValueInfo vi = new ValueInfo(dataType, value); final String valueType = vi.valueType; value = vi.value; boolean isDecimal = vi.isDecimal; String valueString = value.toString(); writer.startElement( encodedName, "xsi:type", valueType); if (isDecimal) { valueString = XmlaUtil.normalizeNumericString(valueString); } writer.characters(valueString); writer.endElement(); } }
@Override public List<?> next() throws TranslatorException { if (!rowPositionIterator.hasNext()) { return null; } Position rowPosition = rowPositionIterator.next(); Object[] result = new Object[colWidth]; int i = 0; // add in rows axis List<Member> members = rowPosition.getMembers(); for (Member member:members) { String columnName = member.getName(); result[i++] = columnName; } // add col axis for (Position colPos : columnsAxis) { Cell cell = cellSet.getCell(colPos, rowPosition); result[i++] = cell.getValue(); } if (returnsArray) { ArrayList<Object[]> results = new ArrayList<Object[]>(1); results.add(result); return results; } return Arrays.asList(result); }
logger.trace("Non-numeric cell value : {}", cell.getValue());