Interface NumericCellStringifier

All Superinterfaces:
Serializable
All Known Implementing Classes:
DecimalFormatNumericCellStringifier, JavaToStringNumericCellStringifier

public interface NumericCellStringifier extends Serializable
The function used to convert the value of a numeric cell to a String in the output dataframe (this library outputs strings for all values in an Excel sheet to avoid issues due to inconsistently typed fields).

This function is only applied to numeric cells that do not have date/time formatting.

  • Method Details

    • defaultNumericCellStringifier

      static NumericCellStringifier defaultNumericCellStringifier()
      Use DecimalFormat with a format string of "0.#############", which will keep data up to thirteen decimal places.
    • getNumericCellValueAsString

      String getNumericCellValueAsString(org.apache.poi.ss.usermodel.Cell cell)
      Convert the value of a Cell that is known to contain a numeric value without date/time formatting to a String. This function is applied both to Cell objects that contain a "raw" numeric value and those that contain a formula whose formula result is numeric.
      See Also: