django_auxilium.utils.range module¶

class django_auxilium.utils.range.AlphabeticNumbers[source]¶

Bases: object

Utility class for dealing with numbers in alphabetical form. Useful for converting Excel column notation into numbers and vise verse.

static int_from_str(string)[source]¶

Convert alphabetical number into actual integer.

Parameters:	string (str) – Number in alphabetical form (e.g. AB = 28)
Returns:	number – Converted integer value
Return type:	int

static str_from_int(number)[source]¶

Convert integer into its alphabetical representation.

Parameters:	number (int) – Number to be converted
Returns:	string – The alphabetical representation of the number
Return type:	str
Raises:	`ValueError` – If the input number is not valid

class django_auxilium.utils.range.Range[source]¶

Bases: django_auxilium.utils.range.rangenamedtuple

Helper data-structure for storing excel-type ranges.

Also has some useful range-related properties

columns¶

Gets the number of columns in a given range.

Returns:	columns – The number of columns
Return type:	int

rows¶

Gets the number of columns in a given range.

Returns:	columns – The number of columns
Return type:	int