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 24 of file openpyxl_util.py.

◆ COLOR_BLUE

str COLOR_BLUE = "0000FF"

Definition at line 25 of file openpyxl_util.py.

◆ COLOR_BROWN

str COLOR_BROWN = "A52A2A"

Definition at line 26 of file openpyxl_util.py.

◆ COLOR_GREEN

str COLOR_GREEN = "00FF00"

Definition at line 28 of file openpyxl_util.py.

◆ COLOR_GREY

str COLOR_GREY = "BEBEBE"

Definition at line 27 of file openpyxl_util.py.

◆ COLOR_ORANGE

str COLOR_ORANGE = "FFA500"

Definition at line 29 of file openpyxl_util.py.

◆ COLOR_RED

str COLOR_RED = "FF0000"

Definition at line 30 of file openpyxl_util.py.

◆ COLOR_VIOLET

str COLOR_VIOLET = "EE82EE"

Definition at line 31 of file openpyxl_util.py.

◆ COLOR_WHITE

str COLOR_WHITE = "FFFFFF"

Definition at line 32 of file openpyxl_util.py.

◆ COLOR_YELLOW

str COLOR_YELLOW = "FFFF00"

Definition at line 33 of file openpyxl_util.py.

◆ FONT_NAME

str FONT_NAME = "Calibri"

Definition at line 19 of file openpyxl_util.py.

◆ FONT_SIZE

int FONT_SIZE = 11

Definition at line 18 of file openpyxl_util.py.

◆ MAX_COLUMN_WIDTH

int MAX_COLUMN_WIDTH = 30

Definition at line 20 of file openpyxl_util.py.

◆ MAX_ROW_HEIGHT

float MAX_ROW_HEIGHT = 1.3

Definition at line 21 of file openpyxl_util.py.

◆ NUMBER_FORMAT_CURRENCY

str NUMBER_FORMAT_CURRENCY = "#,##0.00"

Definition at line 40 of file openpyxl_util.py.

◆ NUMBER_FORMAT_DATETIME

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

Definition at line 43 of file openpyxl_util.py.

◆ NUMBER_FORMAT_EUR

str NUMBER_FORMAT_EUR = "#,##0.00 €"

Definition at line 41 of file openpyxl_util.py.

◆ NUMBER_FORMAT_PERCENT

str NUMBER_FORMAT_PERCENT = "0%"

Definition at line 42 of file openpyxl_util.py.

◆ NUMBER_FORMAT_TIME

str NUMBER_FORMAT_TIME = "hh:mm"

Definition at line 44 of file openpyxl_util.py.

◆ PAGE_MARGIN_FACTOR

int PAGE_MARGIN_FACTOR = 1 / 2.54

Definition at line 46 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 35 of file openpyxl_util.py.

Classes

Variables