XlsxReader.Styles (xlsx_reader v0.8.12)

Utility functions and types to deal with cell styles

Summary

Matches the text representation of a cell value

custom_formats()

Knwon cell styles for which type conversion is supported

style_type()

Cell styles for which type conversion is supported

style_types()

Guesses the type of a cell based on its style.

@type custom_format_matcher() :: String.t() | Regex.t()

Matches the text representation of a cell value

@type custom_formats() :: %{optional(String.t()) => String.t()}

@type known_style_type() ::
  :string | :number | :percentage | :date | :time | :date_time | :unsupported

Knwon cell styles for which type conversion is supported

@type style_type() :: known_style_type() | String.t()

Cell styles for which type conversion is supported

@type style_types() :: XlsxReader.Array.t(style_type())

@type supported_custom_formats() :: [{custom_format_matcher(), known_style_type()}]

@spec get_style_type(String.t(), custom_formats(), supported_custom_formats()) ::
  style_type() | nil

Guesses the type of a cell based on its style.

The type is:

If no type could be guessed, returns nil.