Enumerations

enum numbers_parser.NegativeNumberStyle(value)[source]

How negative numbers are formatted.

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

Member Type:

int

Valid values are as follows:

MINUS = <NegativeNumberStyle.MINUS: 0>
RED = <NegativeNumberStyle.RED: 1>
PARENTHESES = <NegativeNumberStyle.PARENTHESES: 2>
RED_AND_PARENTHESES = <NegativeNumberStyle.RED_AND_PARENTHESES: 3>
enum numbers_parser.FractionAccuracy(value)[source]

How fractions are formatted.

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

Member Type:

int

Valid values are as follows:

THREE = <FractionAccuracy.THREE: 4294967293>
TWO = <FractionAccuracy.TWO: 4294967294>
ONE = <FractionAccuracy.ONE: 4294967295>
HALVES = <FractionAccuracy.HALVES: 2>
QUARTERS = <FractionAccuracy.QUARTERS: 4>
EIGTHS = <FractionAccuracy.EIGTHS: 8>
SIXTEENTHS = <FractionAccuracy.SIXTEENTHS: 16>
TENTHS = <FractionAccuracy.TENTHS: 10>
HUNDRETHS = <FractionAccuracy.HUNDRETHS: 100>
enum numbers_parser.PaddingType(value)[source]

How integers and decimals are padded in custom number formats.

Member Type:

int

Valid values are as follows:

NONE = <PaddingType.NONE: 0>
ZEROS = <PaddingType.ZEROS: 1>
SPACES = <PaddingType.SPACES: 2>