Source.Util.openpyxl_util Namespace Reference

Classes
class	XLSCreator
	XLS file creator. More...

Variables
str	COLOR_BLACK = "000000"
str	COLOR_BLUE = "0000FF"
str	COLOR_BROWN = "A52A2A"
str	COLOR_GREEN = "00FF00"
str	COLOR_GREY = "BEBEBE"
str	COLOR_ORANGE = "FFA500"
str	COLOR_RED = "FF0000"
str	COLOR_VIOLET = "EE82EE"
str	COLOR_WHITE = "FFFFFF"
str	COLOR_YELLOW = "FFFF00"
str	FONT_NAME = "Calibri"
int	FONT_SIZE = 11
int	MAX_COLUMN_WIDTH = 30
float	MAX_ROW_HEIGHT = 1.3
str	NUMBER_FORMAT_CURRENCY = "#,##0.00"
str	NUMBER_FORMAT_DATETIME = "YYYY-MM-DD HH:MM:SS"
str	NUMBER_FORMAT_EUR = "#,##0.00 €"
str	NUMBER_FORMAT_PERCENT = "0%"
str	NUMBER_FORMAT_TIME = "hh:mm"
int	PAGE_MARGIN_FACTOR = 1 / 2.54
	THIN_BORDER

Detailed Description

---

Variable Documentation

COLOR_BLACK

str COLOR_BLACK = "000000"

Definition at line 23 of file openpyxl_util.py.

COLOR_BLUE

str COLOR_BLUE = "0000FF"

Definition at line 24 of file openpyxl_util.py.

COLOR_BROWN

str COLOR_BROWN = "A52A2A"

Definition at line 25 of file openpyxl_util.py.

COLOR_GREEN

str COLOR_GREEN = "00FF00"

Definition at line 27 of file openpyxl_util.py.

COLOR_GREY

str COLOR_GREY = "BEBEBE"

Definition at line 26 of file openpyxl_util.py.

COLOR_ORANGE

str COLOR_ORANGE = "FFA500"

Definition at line 28 of file openpyxl_util.py.

COLOR_RED

str COLOR_RED = "FF0000"

Definition at line 29 of file openpyxl_util.py.

COLOR_VIOLET

str COLOR_VIOLET = "EE82EE"

Definition at line 30 of file openpyxl_util.py.

COLOR_WHITE

str COLOR_WHITE = "FFFFFF"

Definition at line 31 of file openpyxl_util.py.

COLOR_YELLOW

str COLOR_YELLOW = "FFFF00"

Definition at line 32 of file openpyxl_util.py.

FONT_NAME

str FONT_NAME = "Calibri"

Definition at line 18 of file openpyxl_util.py.

FONT_SIZE

int FONT_SIZE = 11

Definition at line 17 of file openpyxl_util.py.

MAX_COLUMN_WIDTH

int MAX_COLUMN_WIDTH = 30

Definition at line 19 of file openpyxl_util.py.

MAX_ROW_HEIGHT

float MAX_ROW_HEIGHT = 1.3

Definition at line 20 of file openpyxl_util.py.

NUMBER_FORMAT_CURRENCY

str NUMBER_FORMAT_CURRENCY = "#,##0.00"

Definition at line 39 of file openpyxl_util.py.

NUMBER_FORMAT_DATETIME

str NUMBER_FORMAT_DATETIME = "YYYY-MM-DD HH:MM:SS"

Definition at line 42 of file openpyxl_util.py.

NUMBER_FORMAT_EUR

str NUMBER_FORMAT_EUR = "#,##0.00 €"

Definition at line 40 of file openpyxl_util.py.

NUMBER_FORMAT_PERCENT

str NUMBER_FORMAT_PERCENT = "0%"

Definition at line 41 of file openpyxl_util.py.

NUMBER_FORMAT_TIME

str NUMBER_FORMAT_TIME = "hh:mm"

Definition at line 43 of file openpyxl_util.py.

PAGE_MARGIN_FACTOR

int PAGE_MARGIN_FACTOR = 1 / 2.54

Definition at line 45 of file openpyxl_util.py.

THIN_BORDER

THIN_BORDER

Initial value:

=  Border(left=Side(style="thin"),
                     right=Side(style="thin"),
                     top=Side(style="thin"),
                     bottom=Side(style="thin"))

Definition at line 34 of file openpyxl_util.py.