Enumerations

class numbers_parser.NegativeNumberStyle(*values)[source]

How negative numbers are formatted.

This enum is used in cell data formats and cell custom formats using the negative_style keyword argument.

MINUS = 0

Negative numbers use a simple minus sign.

RED = 1

Negative numbers are red with no minus sign.

PARENTHESES = 2

Negative numbers are in parentheses with no minus sign.

RED_AND_PARENTHESES = 3

Negative numbers are red and in parentheses with no minus sign.

class numbers_parser.FractionAccuracy(*values)[source]

How fractions are formatted.

This enum is used in cell data formats and cell custom formats using the fraction_accuracy keyword argument.

THREE = 4294967293

Fractions are formatted with up to 3 digits in the denominator.

TWO = 4294967294

Fractions are formatted with up to 2 digits in the denominator.

ONE = 4294967295

Fractions are formatted with up to 1 digit in the denominator.

HALVES = 2

Fractions are formatted to the nearest half.

QUARTERS = 4

Fractions are formatted to the nearest quarter.

EIGHTHS = 8

Fractions are formatted to the nearest eighth.

SIXTEENTHS = 16

Fractions are formatted to the nearest sixteenth.

TENTHS = 10

Fractions are formatted to the nearest tenth.

HUNDREDTHS = 100

Fractions are formatted to the nearest hundredth.

class numbers_parser.PaddingType(*values)[source]

How integers and decimals are padded in custom number formats.

NONE = 0

No number padding.

ZEROS = 1

Pad integers with leading zeroes and decimals with trailing zeroes.

SPACES = 2

Pad integers with leading spaces and decimals with trailing spaces.