Reference
Absolute coordinate
Description
Convert a coordinate to an absolute coordinate string (B12 -> $B$12)
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
absolute_coordinate(coord_string, ...)
Arguments
coord_string |
coord_string |
... |
Additional arguments, i.e. kwargs. |
AbsoluteAnchor
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.spreadsheet_drawing.html
Usage
AbsoluteAnchor(pos = NULL, ext = NULL, ...)
Arguments
pos |
pos |
ext |
ext |
... |
Additional arguments, i.e. kwargs. |
Active
Description
Get the currently active sheet or NULL.
Usage
active(py_obj)
Arguments
py_obj |
py_obj |
Details
:type: :class:'openpyxl.worksheet.worksheet.Worksheet'
Add chart
Description
Optionally provide a cell for the top-left anchor
Usage
add_chart(py_obj, chart, anchor = NULL, ...)
Arguments
py_obj |
py_obj |
chart |
chart |
anchor |
anchor |
... |
Additional arguments, i.e. kwargs. |
Details
Add data
Description
The default is to treat each column as a data series.
Usage
add_data(py_obj, data, from_rows = FALSE, titles_from_data = FALSE)
Arguments
py_obj |
py_obj |
data |
data |
from_rows |
from_rows |
titles_from_data |
titles_from_data |
Add table
Description
Check for duplicate name in definedNames and other worksheet tables before adding table.
Usage
add_table(py_obj, table)
Arguments
py_obj |
py_obj |
table |
table |
AdjPoint2D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
AdjPoint2D(x = NULL, y = NULL, ...)
Arguments
x |
x |
y |
y |
... |
Additional arguments, i.e. kwargs. |
AdjustHandleList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
AdjustHandleList(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
Alignment
Description
Alignment options for use in styles.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.alignment.html
Usage
Alignment(
horizontal = NULL,
vertical = NULL,
textRotation = 0L,
wrapText = NULL,
shrinkToFit = NULL,
indent = 0L,
relativeIndent = 0L,
justifyLastLine = NULL,
readingOrder = 0L,
text_rotation = NULL,
wrap_text = NULL,
shrink_to_fit = NULL,
mergeCell = NULL,
...
)
Arguments
horizontal |
horizontal |
vertical |
vertical |
textRotation |
textRotation |
wrapText |
wrapText |
shrinkToFit |
shrinkToFit |
indent |
indent |
relativeIndent |
relativeIndent |
justifyLastLine |
justifyLastLine |
readingOrder |
readingOrder |
text_rotation |
text_rotation |
wrap_text |
wrap_text |
shrink_to_fit |
shrink_to_fit |
mergeCell |
mergeCell |
... |
Additional arguments, i.e. kwargs. |
AlphaBiLevelEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaBiLevelEffect(thresh = NULL, ...)
Arguments
thresh |
thresh |
... |
Additional arguments, i.e. kwargs. |
AlphaCeilingEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaCeilingEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
AlphaFloorEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaFloorEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
AlphaInverseEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaInverseEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
AlphaModulateEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaModulateEffect(cont = NULL, ...)
Arguments
cont |
cont |
... |
Additional arguments, i.e. kwargs. |
AlphaModulateFixedEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaModulateFixedEffect(amt = NULL, ...)
Arguments
amt |
amt |
... |
Additional arguments, i.e. kwargs. |
AlphaReplaceEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
AlphaReplaceEffect(a = NULL, ...)
Arguments
a |
a |
... |
Additional arguments, i.e. kwargs. |
AnchorClientData
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.spreadsheet_drawing.html
Usage
AnchorClientData(fLocksWithSheet = NULL, fPrintsWithSheet = NULL, ...)
Arguments
fLocksWithSheet |
fLocksWithSheet |
fPrintsWithSheet |
fPrintsWithSheet |
... |
Additional arguments, i.e. kwargs. |
AnchorMarker
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.spreadsheet_drawing.html
Usage
AnchorMarker(col = 0L, colOff = 0L, row = 0L, rowOff = 0L, ...)
Arguments
col |
col |
colOff |
colOff |
row |
row |
rowOff |
rowOff |
... |
Additional arguments, i.e. kwargs. |
Angle to degrees
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
angle_to_degrees(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Apply stylesheet
Description
Add styles to workbook if present
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.stylesheet.html
Usage
apply_stylesheet(archive, wb, ...)
Arguments
archive |
archive |
wb |
wb |
... |
Additional arguments, i.e. kwargs. |
AreaChart
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.area_chart.html
Usage
AreaChart(axId = NULL, extLst = NULL, ...)
Arguments
axId |
axId |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
AreaChart3D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.area_chart.html
Usage
AreaChart3D(gapDepth = NULL, ...)
Arguments
gapDepth |
gapDepth |
... |
Additional arguments, i.e. kwargs. |
ArrayDescriptor
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.cell_style.html
Usage
ArrayDescriptor(key, ...)
Arguments
key |
key |
... |
Additional arguments, i.e. kwargs. |
ArrayFormula
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.formula.html
Usage
ArrayFormula(ref, text = NULL, ...)
Arguments
ref |
ref |
text |
text |
... |
Additional arguments, i.e. kwargs. |
AuthorList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.comments.author.html
Usage
AuthorList(author = list(), ...)
Arguments
author |
author |
... |
Additional arguments, i.e. kwargs. |
AutoFilter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
AutoFilter(
ref = NULL,
filterColumn = list(),
sortState = NULL,
extLst = NULL,
...
)
Arguments
ref |
ref |
filterColumn |
filterColumn |
sortState |
sortState |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
AutonumberBullet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.text.html
Usage
AutonumberBullet(type = NULL, startAt = NULL, ...)
Arguments
type |
type |
startAt |
startAt |
... |
Additional arguments, i.e. kwargs. |
Avoid duplicate name
Description
Naive check to see whether name already exists.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.child.html
Usage
avoid_duplicate_name(names, value, ...)
Arguments
names |
names |
value |
value |
... |
Additional arguments, i.e. kwargs. |
Details
If name does exist suggest a name using an incrementer Duplicates are case insensitive
AxDataSource
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.data_source.html
Usage
AxDataSource(
numRef = NULL,
numLit = NULL,
strRef = NULL,
strLit = NULL,
multiLvlStrRef = NULL,
...
)
Arguments
numRef |
numRef |
numLit |
numLit |
strRef |
strRef |
strLit |
strLit |
multiLvlStrRef |
multiLvlStrRef |
... |
Additional arguments, i.e. kwargs. |
Backdrop
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
Backdrop(anchor = NULL, norm = NULL, up = NULL, extLst = NULL, ...)
Arguments
anchor |
anchor |
norm |
norm |
up |
up |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
BandFormat
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.surface_chart.html
Usage
BandFormat(idx = 0L, spPr = NULL, ...)
Arguments
idx |
idx |
spPr |
spPr |
... |
Additional arguments, i.e. kwargs. |
BandFormatList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.surface_chart.html
Usage
BandFormatList(bandFmt = list(), ...)
Arguments
bandFmt |
bandFmt |
... |
Additional arguments, i.e. kwargs. |
BarChart
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.bar_chart.html
Usage
BarChart(gapWidth = 150L, overlap = NULL, serLines = NULL, extLst = NULL, ...)
Arguments
gapWidth |
gapWidth |
overlap |
overlap |
serLines |
serLines |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
BarChart3D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.bar_chart.html
Usage
BarChart3D(
gapWidth = 150L,
gapDepth = 150L,
shape = NULL,
serLines = NULL,
extLst = NULL,
...
)
Arguments
gapWidth |
gapWidth |
gapDepth |
gapDepth |
shape |
shape |
serLines |
serLines |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Bevel
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
Bevel(w = NULL, h = NULL, prst = NULL, ...)
Arguments
w |
w |
h |
h |
prst |
prst |
... |
Additional arguments, i.e. kwargs. |
BiLevelEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
BiLevelEffect(thresh = NULL, ...)
Arguments
thresh |
thresh |
... |
Additional arguments, i.e. kwargs. |
Blip
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.fill.html
Usage
Blip(
cstate = NULL,
embed = NULL,
link = NULL,
noGrp = NULL,
noSelect = NULL,
noRot = NULL,
noChangeAspect = NULL,
noMove = NULL,
noResize = NULL,
noEditPoints = NULL,
noAdjustHandles = NULL,
noChangeArrowheads = NULL,
noChangeShapeType = NULL,
extLst = NULL,
alphaBiLevel = NULL,
alphaCeiling = NULL,
alphaFloor = NULL,
alphaInv = NULL,
alphaMod = NULL,
alphaModFix = NULL,
alphaRepl = NULL,
biLevel = NULL,
blur = NULL,
clrChange = NULL,
clrRepl = NULL,
duotone = NULL,
fillOverlay = NULL,
grayscl = NULL,
hsl = NULL,
lum = NULL,
tint = NULL,
...
)
Arguments
cstate |
cstate |
embed |
embed |
link |
link |
noGrp |
noGrp |
noSelect |
noSelect |
noRot |
noRot |
noChangeAspect |
noChangeAspect |
noMove |
noMove |
noResize |
noResize |
noEditPoints |
noEditPoints |
noAdjustHandles |
noAdjustHandles |
noChangeArrowheads |
noChangeArrowheads |
noChangeShapeType |
noChangeShapeType |
extLst |
extLst |
alphaBiLevel |
alphaBiLevel |
alphaCeiling |
alphaCeiling |
alphaFloor |
alphaFloor |
alphaInv |
alphaInv |
alphaMod |
alphaMod |
alphaModFix |
alphaModFix |
alphaRepl |
alphaRepl |
biLevel |
biLevel |
blur |
blur |
clrChange |
clrChange |
clrRepl |
clrRepl |
duotone |
duotone |
fillOverlay |
fillOverlay |
grayscl |
grayscl |
hsl |
hsl |
lum |
lum |
tint |
tint |
... |
Additional arguments, i.e. kwargs. |
BlipFillProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.fill.html
Usage
BlipFillProperties(
dpi = NULL,
rotWithShape = NULL,
blip = NULL,
tile = NULL,
srcRect = NULL,
...
)
Arguments
dpi |
dpi |
rotWithShape |
rotWithShape |
blip |
blip |
tile |
tile |
srcRect |
srcRect |
... |
Additional arguments, i.e. kwargs. |
BlurEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
BlurEffect(rad = NULL, grow = NULL, ...)
Arguments
rad |
rad |
grow |
grow |
... |
Additional arguments, i.e. kwargs. |
BookView
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.views.html
Usage
BookView(
visibility = "visible",
minimized = FALSE,
showHorizontalScroll = TRUE,
showVerticalScroll = TRUE,
showSheetTabs = TRUE,
xWindow = NULL,
yWindow = NULL,
windowWidth = NULL,
windowHeight = NULL,
tabRatio = 600L,
firstSheet = 0L,
activeTab = 0L,
autoFilterDateGrouping = TRUE,
extLst = NULL,
...
)
Arguments
visibility |
visibility |
minimized |
minimized |
showHorizontalScroll |
showHorizontalScroll |
showVerticalScroll |
showVerticalScroll |
showSheetTabs |
showSheetTabs |
xWindow |
xWindow |
yWindow |
yWindow |
windowWidth |
windowWidth |
windowHeight |
windowHeight |
tabRatio |
tabRatio |
firstSheet |
firstSheet |
activeTab |
activeTab |
autoFilterDateGrouping |
autoFilterDateGrouping |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Border
Description
Border positioning for use in styles.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.borders.html
Usage
Border(
left = NULL,
right = NULL,
top = NULL,
bottom = NULL,
diagonal = NULL,
diagonal_direction = NULL,
vertical = NULL,
horizontal = NULL,
diagonalUp = FALSE,
diagonalDown = FALSE,
outline = TRUE,
start = NULL,
end = NULL,
...
)
Arguments
left |
left |
right |
right |
top |
top |
bottom |
bottom |
diagonal |
diagonal |
diagonal_direction |
diagonal_direction |
vertical |
vertical |
horizontal |
horizontal |
diagonalUp |
diagonalUp |
diagonalDown |
diagonalDown |
outline |
outline |
start |
start |
end |
end |
... |
Additional arguments, i.e. kwargs. |
Break
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.pagebreak.html
Usage
Break(id = 0L, min = 0L, max = 16383L, man = TRUE, pt = NULL, ...)
Arguments
id |
id |
min |
min |
max |
max |
man |
man |
pt |
pt |
... |
Additional arguments, i.e. kwargs. |
BubbleChart
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.bubble_chart.html
Usage
BubbleChart(
varyColors = NULL,
ser = list(),
dLbls = NULL,
bubble3D = NULL,
bubbleScale = NULL,
showNegBubbles = NULL,
sizeRepresents = NULL,
extLst = NULL,
...
)
Arguments
varyColors |
varyColors |
ser |
ser |
dLbls |
dLbls |
bubble3D |
bubble3D |
bubbleScale |
bubbleScale |
showNegBubbles |
showNegBubbles |
sizeRepresents |
sizeRepresents |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Builtin format code
Description
Return one of the standard format codes by index.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
builtin_format_code(index, ...)
Arguments
index |
index |
... |
Additional arguments, i.e. kwargs. |
Builtin format id
Description
Return the id of a standard style.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
builtin_format_id(fmt, ...)
Arguments
fmt |
fmt |
... |
Additional arguments, i.e. kwargs. |
CalcProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.properties.html
Usage
CalcProperties(
calcId = 124519L,
calcMode = NULL,
fullCalcOnLoad = TRUE,
refMode = NULL,
iterate = NULL,
iterateCount = NULL,
iterateDelta = NULL,
fullPrecision = NULL,
calcCompleted = NULL,
calcOnSave = NULL,
concurrentCalc = NULL,
concurrentManualCount = NULL,
forceFullCalc = NULL,
...
)
Arguments
calcId |
calcId |
calcMode |
calcMode |
fullCalcOnLoad |
fullCalcOnLoad |
refMode |
refMode |
iterate |
iterate |
iterateCount |
iterateCount |
iterateDelta |
iterateDelta |
fullPrecision |
fullPrecision |
calcCompleted |
calcCompleted |
calcOnSave |
calcOnSave |
concurrentCalc |
concurrentCalc |
concurrentManualCount |
concurrentManualCount |
forceFullCalc |
forceFullCalc |
... |
Additional arguments, i.e. kwargs. |
Camera
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
Camera(prst = NULL, fov = NULL, zoom = NULL, rot = NULL, ...)
Arguments
prst |
prst |
fov |
fov |
zoom |
zoom |
rot |
rot |
... |
Additional arguments, i.e. kwargs. |
Cast numeric
Description
Explicitly convert a string to a numeric value
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.inference.html
Usage
cast_numeric(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Cast percentage
Description
Explicitly convert a string to numeric value and format as a percentage
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.inference.html
Usage
cast_percentage(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Cast time
Description
Explicitly convert a string to a number and format as datetime or time
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.inference.html
Usage
cast_time(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Cell
Description
Describes cell associated properties.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.cell.html
Usage
Cell(
worksheet,
row = NULL,
column = NULL,
value = NULL,
style_array = NULL,
...
)
Arguments
worksheet |
worksheet |
row |
row |
column |
column |
value |
value |
style_array |
style_array |
... |
Additional arguments, i.e. kwargs. |
Details
Properties of interest include style, type, value, and address.
CellIsRule
Description
Conditional formatting rule based on cell contents.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
CellIsRule(
operator = NULL,
formula = NULL,
stopIfTrue = NULL,
font = NULL,
border = NULL,
fill = NULL,
...
)
Arguments
operator |
operator |
formula |
formula |
stopIfTrue |
stopIfTrue |
font |
font |
border |
border |
fill |
fill |
... |
Additional arguments, i.e. kwargs. |
CellRange
Description
Represents a range in a sheet: title and coordinates.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.cell_range.html
Usage
CellRange(
range_string = NULL,
min_col = NULL,
min_row = NULL,
max_col = NULL,
max_row = NULL,
title = NULL,
...
)
Arguments
range_string |
range_string |
min_col |
min_col |
min_row |
min_row |
max_col |
max_col |
max_row |
max_row |
title |
title |
... |
Additional arguments, i.e. kwargs. |
Details
This object is used to perform operations on ranges, like: - shift, expand or shrink - union/intersection with another sheet range, We can check whether a range is: - equal or not equal to another, - disjoint of another, - contained in another. We can get: - the size of a range. - the range bounds (vertices) - the coordinates, - the string representation,
CellSmartTag
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.smart_tag.html
Usage
CellSmartTag(
cellSmartTagPr = list(),
type = NULL,
deleted = FALSE,
xmlBased = FALSE,
...
)
Arguments
cellSmartTagPr |
cellSmartTagPr |
type |
type |
deleted |
deleted |
xmlBased |
xmlBased |
... |
Additional arguments, i.e. kwargs. |
CellSmartTagPr
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.smart_tag.html
Usage
CellSmartTagPr(key = NULL, val = NULL, ...)
Arguments
key |
key |
val |
val |
... |
Additional arguments, i.e. kwargs. |
CellSmartTags
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.smart_tag.html
Usage
CellSmartTags(cellSmartTag = list(), r = NULL, ...)
Arguments
cellSmartTag |
cellSmartTag |
r |
r |
... |
Additional arguments, i.e. kwargs. |
CellStyle
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.cell_style.html
Usage
CellStyle(
numFmtId = 0L,
fontId = 0L,
fillId = 0L,
borderId = 0L,
xfId = NULL,
quotePrefix = NULL,
pivotButton = NULL,
applyNumberFormat = NULL,
applyFont = NULL,
applyFill = NULL,
applyBorder = NULL,
applyAlignment = NULL,
applyProtection = NULL,
alignment = NULL,
protection = NULL,
extLst = NULL,
...
)
Arguments
numFmtId |
numFmtId |
fontId |
fontId |
fillId |
fillId |
borderId |
borderId |
xfId |
xfId |
quotePrefix |
quotePrefix |
pivotButton |
pivotButton |
applyNumberFormat |
applyNumberFormat |
applyFont |
applyFont |
applyFill |
applyFill |
applyBorder |
applyBorder |
applyAlignment |
applyAlignment |
applyProtection |
applyProtection |
alignment |
alignment |
protection |
protection |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
CellStyleList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.cell_style.html
Usage
CellStyleList(count = NULL, xf = list(), ...)
Arguments
count |
count |
xf |
xf |
... |
Additional arguments, i.e. kwargs. |
CellWatch
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.cell_watch.html
Usage
CellWatch(r = NULL, ...)
Arguments
r |
r |
... |
Additional arguments, i.e. kwargs. |
CellWatches
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.cell_watch.html
Usage
CellWatches(cellWatch = list(), ...)
Arguments
cellWatch |
cellWatch |
... |
Additional arguments, i.e. kwargs. |
CharacterProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.text.html
Usage
CharacterProperties(
kumimoji = NULL,
lang = NULL,
altLang = NULL,
sz = NULL,
b = NULL,
i = NULL,
u = NULL,
strike = NULL,
kern = NULL,
cap = NULL,
spc = NULL,
normalizeH = NULL,
baseline = NULL,
noProof = NULL,
dirty = NULL,
err = NULL,
smtClean = NULL,
smtId = NULL,
bmk = NULL,
ln = NULL,
highlight = NULL,
latin = NULL,
ea = NULL,
cs = NULL,
sym = NULL,
hlinkClick = NULL,
hlinkMouseOver = NULL,
rtl = NULL,
extLst = NULL,
noFill = NULL,
solidFill = NULL,
gradFill = NULL,
blipFill = NULL,
pattFill = NULL,
grpFill = NULL,
effectLst = NULL,
effectDag = NULL,
uLnTx = NULL,
uLn = NULL,
uFillTx = NULL,
uFill = NULL,
...
)
Arguments
kumimoji |
kumimoji |
lang |
lang |
altLang |
altLang |
sz |
sz |
b |
b |
i |
i |
u |
u |
strike |
strike |
kern |
kern |
cap |
cap |
spc |
spc |
normalizeH |
normalizeH |
baseline |
baseline |
noProof |
noProof |
dirty |
dirty |
err |
err |
smtClean |
smtClean |
smtId |
smtId |
bmk |
bmk |
ln |
ln |
highlight |
highlight |
latin |
latin |
ea |
ea |
cs |
cs |
sym |
sym |
hlinkClick |
hlinkClick |
hlinkMouseOver |
hlinkMouseOver |
rtl |
rtl |
extLst |
extLst |
noFill |
noFill |
solidFill |
solidFill |
gradFill |
gradFill |
blipFill |
blipFill |
pattFill |
pattFill |
grpFill |
grpFill |
effectLst |
effectLst |
effectDag |
effectDag |
uLnTx |
uLnTx |
uLn |
uLn |
uFillTx |
uFillTx |
uFill |
uFill |
... |
Additional arguments, i.e. kwargs. |
ChartContainer
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.chartspace.html
Usage
ChartContainer(
title = NULL,
autoTitleDeleted = NULL,
pivotFmts = list(),
view3D = NULL,
floor = NULL,
sideWall = NULL,
backWall = NULL,
plotArea = NULL,
legend = NULL,
plotVisOnly = TRUE,
dispBlanksAs = "gap",
showDLblsOverMax = NULL,
extLst = NULL,
...
)
Arguments
title |
title |
autoTitleDeleted |
autoTitleDeleted |
pivotFmts |
pivotFmts |
view3D |
view3D |
floor |
floor |
sideWall |
sideWall |
backWall |
backWall |
plotArea |
plotArea |
legend |
legend |
plotVisOnly |
plotVisOnly |
dispBlanksAs |
dispBlanksAs |
showDLblsOverMax |
showDLblsOverMax |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ChartLines
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.axis.html
Usage
ChartLines(spPr = NULL, ...)
Arguments
spPr |
spPr |
... |
Additional arguments, i.e. kwargs. |
ChartRelation
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.relation.html
Usage
ChartRelation(id, ...)
Arguments
id |
id |
... |
Additional arguments, i.e. kwargs. |
Chartsheet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.chartsheet.html
Usage
Chartsheet(
sheetPr = NULL,
sheetViews = NULL,
sheetProtection = NULL,
customSheetViews = NULL,
pageMargins = NULL,
pageSetup = NULL,
headerFooter = NULL,
drawing = NULL,
drawingHF = NULL,
picture = NULL,
webPublishItems = NULL,
extLst = NULL,
parent = NULL,
title = "",
sheet_state = "visible",
...
)
Arguments
sheetPr |
sheetPr |
sheetViews |
sheetViews |
sheetProtection |
sheetProtection |
customSheetViews |
customSheetViews |
pageMargins |
pageMargins |
pageSetup |
pageSetup |
headerFooter |
headerFooter |
drawing |
drawing |
drawingHF |
drawingHF |
picture |
picture |
webPublishItems |
webPublishItems |
extLst |
extLst |
parent |
parent |
title |
title |
sheet_state |
sheet_state |
... |
Additional arguments, i.e. kwargs. |
ChartsheetProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.properties.html
Usage
ChartsheetProperties(published = NULL, codeName = NULL, tabColor = NULL, ...)
Arguments
published |
published |
codeName |
codeName |
tabColor |
tabColor |
... |
Additional arguments, i.e. kwargs. |
ChartsheetProtection
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.protection.html
Usage
ChartsheetProtection(
content = NULL,
objects = NULL,
hashValue = NULL,
spinCount = NULL,
saltValue = NULL,
algorithmName = NULL,
password = NULL,
...
)
Arguments
content |
content |
objects |
objects |
hashValue |
hashValue |
spinCount |
spinCount |
saltValue |
saltValue |
algorithmName |
algorithmName |
password |
password |
... |
Additional arguments, i.e. kwargs. |
ChartsheetView
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.views.html
Usage
ChartsheetView(
tabSelected = NULL,
zoomScale = NULL,
workbookViewId = 0L,
zoomToFit = TRUE,
extLst = NULL,
...
)
Arguments
tabSelected |
tabSelected |
zoomScale |
zoomScale |
workbookViewId |
workbookViewId |
zoomToFit |
zoomToFit |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ChartsheetViewList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.views.html
Usage
ChartsheetViewList(sheetView = NULL, extLst = NULL, ...)
Arguments
sheetView |
sheetView |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ChartSpace
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.chartspace.html
Usage
ChartSpace(
date1904 = NULL,
lang = NULL,
roundedCorners = NULL,
style = NULL,
clrMapOvr = NULL,
pivotSource = NULL,
protection = NULL,
chart = NULL,
spPr = NULL,
txPr = NULL,
externalData = NULL,
printSettings = NULL,
userShapes = NULL,
extLst = NULL,
...
)
Arguments
date1904 |
date1904 |
lang |
lang |
roundedCorners |
roundedCorners |
style |
style |
clrMapOvr |
clrMapOvr |
pivotSource |
pivotSource |
protection |
protection |
chart |
chart |
spPr |
spPr |
txPr |
txPr |
externalData |
externalData |
printSettings |
printSettings |
userShapes |
userShapes |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Cm to dxa
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
cm_to_dxa(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Cm to EMU
Description
1 cm = 360000 EMUs
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
cm_to_EMU(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
ColBreak
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.pagebreak.html
Usage
ColBreak(count = NULL, manualBreakCount = NULL, brk = list(), ...)
Arguments
count |
count |
manualBreakCount |
manualBreakCount |
brk |
brk |
... |
Additional arguments, i.e. kwargs. |
Collapse cell addresses
Description
Collapse a collection of cell co-ordinates down into an optimal
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.datavalidation.html
Usage
collapse_cell_addresses(cells, input_ranges = list(), ...)
Arguments
cells |
cells |
input_ranges |
input_ranges |
... |
Additional arguments, i.e. kwargs. |
Details
range or collection of ranges. E.g. Cells A1, A2, A3, B1, B2 and B3 should have the data-validation object applied, attempt to collapse down to a single range, A1:B3. Currently only collapsing contiguous vertical ranges (i.e. above example results in A1:A3 B1:B3).
Color
Description
Named colors for use in styles.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.colors.html
Usage
Color(
rgb = "00000000",
indexed = NULL,
auto = NULL,
theme = NULL,
tint = 0,
index = NULL,
type = "rgb",
...
)
Arguments
rgb |
rgb |
indexed |
indexed |
auto |
auto |
theme |
theme |
tint |
tint |
index |
index |
type |
type |
... |
Additional arguments, i.e. kwargs. |
ColorChangeEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
ColorChangeEffect(useA = NULL, clrFrom = NULL, clrTo = NULL, ...)
Arguments
useA |
useA |
clrFrom |
clrFrom |
clrTo |
clrTo |
... |
Additional arguments, i.e. kwargs. |
ColorChoice
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.colors.html
Usage
ColorChoice(
scrgbClr = NULL,
srgbClr = NULL,
hslClr = NULL,
sysClr = NULL,
schemeClr = NULL,
prstClr = NULL,
...
)
Arguments
scrgbClr |
scrgbClr |
srgbClr |
srgbClr |
hslClr |
hslClr |
sysClr |
sysClr |
schemeClr |
schemeClr |
prstClr |
prstClr |
... |
Additional arguments, i.e. kwargs. |
ColorChoiceDescriptor
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.colors.html
Usage
ColorChoiceDescriptor(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
ColorDescriptor
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.colors.html
Usage
ColorDescriptor(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
ColorFilter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
ColorFilter(dxfId = NULL, cellColor = NULL, ...)
Arguments
dxfId |
dxfId |
cellColor |
cellColor |
... |
Additional arguments, i.e. kwargs. |
ColorList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.colors.html
Usage
ColorList(indexedColors = list(), mruColors = list(), ...)
Arguments
indexedColors |
indexedColors |
mruColors |
mruColors |
... |
Additional arguments, i.e. kwargs. |
ColorMapping
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.colors.html
Usage
ColorMapping(
bg1 = "lt1",
tx1 = "dk1",
bg2 = "lt2",
tx2 = "dk2",
accent1 = "accent1",
accent2 = "accent2",
accent3 = "accent3",
accent4 = "accent4",
accent5 = "accent5",
accent6 = "accent6",
hlink = "hlink",
folHlink = "folHlink",
extLst = NULL,
...
)
Arguments
bg1 |
bg1 |
tx1 |
tx1 |
bg2 |
bg2 |
tx2 |
tx2 |
accent1 |
accent1 |
accent2 |
accent2 |
accent3 |
accent3 |
accent4 |
accent4 |
accent5 |
accent5 |
accent6 |
accent6 |
hlink |
hlink |
folHlink |
folHlink |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ColorReplaceEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
ColorReplaceEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
ColorScale
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
ColorScale(cfvo = NULL, color = NULL, ...)
Arguments
cfvo |
cfvo |
color |
color |
... |
Additional arguments, i.e. kwargs. |
ColorScaleRule
Description
Backwards compatibility
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
ColorScaleRule(
start_type = NULL,
start_value = NULL,
start_color = NULL,
mid_type = NULL,
mid_value = NULL,
mid_color = NULL,
end_type = NULL,
end_value = NULL,
end_color = NULL,
...
)
Arguments
start_type |
start_type |
start_value |
start_value |
start_color |
start_color |
mid_type |
mid_type |
mid_value |
mid_value |
mid_color |
mid_color |
end_type |
end_type |
end_value |
end_value |
end_color |
end_color |
... |
Additional arguments, i.e. kwargs. |
ColRange
Description
Represent a range of at least one column
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.print_settings.html
Usage
ColRange(range_string = NULL, min_col = NULL, max_col = NULL, ...)
Arguments
range_string |
range_string |
min_col |
min_col |
max_col |
max_col |
... |
Additional arguments, i.e. kwargs. |
Cols from range
Description
Get individual addresses for every cell in a range.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
cols_from_range(range_string, ...)
Arguments
range_string |
range_string |
... |
Additional arguments, i.e. kwargs. |
Details
Yields one row at a time.
Column index from string
Description
Convert a column name into a numerical index
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
column_index_from_string(str_col, ...)
Arguments
str_col |
str_col |
... |
Additional arguments, i.e. kwargs. |
Details
('A' -> 1)
ColumnDimension
Description
Information about the display properties of a column.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.dimensions.html
Usage
ColumnDimension(
worksheet,
index = "A",
width = 13L,
bestFit = FALSE,
hidden = FALSE,
outlineLevel = 0L,
outline_level = NULL,
collapsed = FALSE,
style = NULL,
min = NULL,
max = NULL,
customWidth = FALSE,
visible = NULL,
auto_size = NULL,
...
)
Arguments
worksheet |
worksheet |
index |
index |
width |
width |
bestFit |
bestFit |
hidden |
|
outlineLevel |
outlineLevel |
outline_level |
outline_level |
collapsed |
collapsed |
style |
style |
min |
min |
max |
max |
customWidth |
customWidth |
visible |
visible |
auto_size |
auto_size |
... |
Additional arguments, i.e. kwargs. |
Comment
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.comments.comments.html
Usage
Comment(text, author, height = 79L, width = 144L, ...)
Arguments
text |
text |
author |
author |
height |
height |
width |
width |
... |
Additional arguments, i.e. kwargs. |
CommentRecord
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.comments.comment_sheet.html
Usage
CommentRecord(
ref = "",
authorId = 0L,
guid = NULL,
shapeId = 0L,
text = NULL,
commentPr = NULL,
author = NULL,
height = 79L,
width = 144L,
...
)
Arguments
ref |
ref |
authorId |
authorId |
guid |
guid |
shapeId |
shapeId |
text |
text |
commentPr |
commentPr |
author |
author |
height |
height |
width |
width |
... |
Additional arguments, i.e. kwargs. |
CommentSheet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.comments.comment_sheet.html
Usage
CommentSheet(authors = NULL, commentList = NULL, extLst = NULL, ...)
Arguments
authors |
authors |
commentList |
commentList |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ConditionalFormatting
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.formatting.html
Usage
ConditionalFormatting(
sqref = list(),
pivot = NULL,
cfRule = list(),
extLst = NULL,
...
)
Arguments
sqref |
sqref |
pivot |
pivot |
cfRule |
cfRule |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ConditionalFormattingList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.formatting.html
Usage
ConditionalFormattingList(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
Connection
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.connector.html
Usage
Connection(id = NULL, idx = NULL, ...)
Arguments
id |
id |
idx |
idx |
... |
Additional arguments, i.e. kwargs. |
ConnectionSite
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
ConnectionSite(ang = NULL, pos = NULL, ...)
Arguments
ang |
ang |
pos |
pos |
... |
Additional arguments, i.e. kwargs. |
ConnectionSiteList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
ConnectionSiteList(cxn = NULL, ...)
Arguments
cxn |
cxn |
... |
Additional arguments, i.e. kwargs. |
ConnectorLocking
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.connector.html
Usage
ConnectorLocking(extLst = NULL, ...)
Arguments
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ConnectorNonVisual
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.connector.html
Usage
ConnectorNonVisual(cNvPr = NULL, cNvCxnSpPr = NULL, ...)
Arguments
cNvPr |
cNvPr |
cNvCxnSpPr |
cNvCxnSpPr |
... |
Additional arguments, i.e. kwargs. |
ConnectorShape
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.connector.html
Usage
ConnectorShape(
nvCxnSpPr = NULL,
spPr = NULL,
style = NULL,
macro = NULL,
fPublished = NULL,
...
)
Arguments
nvCxnSpPr |
nvCxnSpPr |
spPr |
spPr |
style |
style |
macro |
macro |
fPublished |
fPublished |
... |
Additional arguments, i.e. kwargs. |
Control
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.controls.html
Usage
Control(controlPr = NULL, shapeId = NULL, name = NULL, ...)
Arguments
controlPr |
controlPr |
shapeId |
shapeId |
name |
name |
... |
Additional arguments, i.e. kwargs. |
ControlProperty
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.controls.html
Usage
ControlProperty(
anchor = NULL,
locked = TRUE,
defaultSize = TRUE,
print = TRUE,
disabled = FALSE,
recalcAlways = FALSE,
uiObject = FALSE,
autoFill = TRUE,
autoLine = TRUE,
autoPict = TRUE,
macro = NULL,
altText = NULL,
linkedCell = NULL,
listFillRange = NULL,
cf = "pict",
id = NULL,
...
)
Arguments
anchor |
anchor |
locked |
locked |
defaultSize |
defaultSize |
print |
_print |
disabled |
disabled |
recalcAlways |
recalcAlways |
uiObject |
uiObject |
autoFill |
autoFill |
autoLine |
autoLine |
autoPict |
autoPict |
macro |
macro |
altText |
altText |
linkedCell |
linkedCell |
listFillRange |
listFillRange |
cf |
cf |
id |
id |
... |
Additional arguments, i.e. kwargs. |
Controls
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.controls.html
Usage
Controls(control = list(), ...)
Arguments
control |
control |
... |
Additional arguments, i.e. kwargs. |
Coordinate from string
Description
Convert a coordinate string like 'B12' to a list ('B', 12)
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
coordinate_from_string(coord_string, ...)
Arguments
coord_string |
coord_string |
... |
Additional arguments, i.e. kwargs. |
Coordinate to tuple
Description
Convert an Excel style coordinate to (row, column) list
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
coordinate_to_tuple(coordinate, ...)
Arguments
coordinate |
coordinate |
... |
Additional arguments, i.e. kwargs. |
Copy worksheet
Description
Copy an existing worksheet in the current workbook
Usage
copy_worksheet(py_obj, from_worksheet)
Arguments
py_obj |
py_obj |
from_worksheet |
from_worksheet |
Details
.. warning:: This function cannot copy worksheets between workbooks. worksheets can only be copied within the workbook that they belong :param from_worksheet: the worksheet to be copied from :return: copy of the initial worksheet
Create chartsheet
Description
create_chartsheet
Usage
create_chartsheet(py_obj, title = NULL, index = NULL)
Arguments
py_obj |
py_obj |
title |
title |
index |
index |
Create sheet
Description
Create a worksheet (at an optional index).
Usage
create_sheet(py_obj, title = NULL, index = NULL)
Arguments
py_obj |
py_obj |
title |
title |
index |
index |
Details
:param title: optional title of the sheet :type title: str :param index: optional position at which the sheet will be inserted :type index: int
CustomChartsheetView
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.custom.html
Usage
CustomChartsheetView(
guid = NULL,
scale = NULL,
state = "visible",
zoomToFit = NULL,
pageMargins = NULL,
pageSetup = NULL,
headerFooter = NULL,
...
)
Arguments
guid |
guid |
scale |
scale |
state |
state |
zoomToFit |
zoomToFit |
pageMargins |
pageMargins |
pageSetup |
pageSetup |
headerFooter |
headerFooter |
... |
Additional arguments, i.e. kwargs. |
CustomChartsheetViews
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.custom.html
Usage
CustomChartsheetViews(customSheetView = NULL, ...)
Arguments
customSheetView |
customSheetView |
... |
Additional arguments, i.e. kwargs. |
CustomFilter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
CustomFilter(operator = NULL, val = NULL, ...)
Arguments
operator |
operator |
val |
val |
... |
Additional arguments, i.e. kwargs. |
CustomFilters
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
CustomFilters(and = FALSE, customFilter = list(), ...)
Arguments
and |
_and |
customFilter |
customFilter |
... |
Additional arguments, i.e. kwargs. |
CustomGeometry2D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
CustomGeometry2D(
avLst = NULL,
gdLst = NULL,
ahLst = NULL,
cxnLst = NULL,
rect = NULL,
pathLst = NULL,
...
)
Arguments
avLst |
avLst |
gdLst |
gdLst |
ahLst |
ahLst |
cxnLst |
cxnLst |
rect |
rect |
pathLst |
pathLst |
... |
Additional arguments, i.e. kwargs. |
CustomProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.custom.html
Usage
CustomProperties(customPr = list(), ...)
Arguments
customPr |
customPr |
... |
Additional arguments, i.e. kwargs. |
CustomProperty
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.custom.html
Usage
CustomProperty(name = NULL, ...)
Arguments
name |
name |
... |
Additional arguments, i.e. kwargs. |
CustomSplit
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.pie_chart.html
Usage
CustomSplit(secondPiePt = list(), ...)
Arguments
secondPiePt |
secondPiePt |
... |
Additional arguments, i.e. kwargs. |
CustomWorkbookView
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.views.html
Usage
CustomWorkbookView(
name = NULL,
guid = NULL,
autoUpdate = NULL,
mergeInterval = NULL,
changesSavedWin = NULL,
onlySync = NULL,
personalView = NULL,
includePrintSettings = NULL,
includeHiddenRowCol = NULL,
maximized = NULL,
minimized = NULL,
showHorizontalScroll = NULL,
showVerticalScroll = NULL,
showSheetTabs = NULL,
xWindow = NULL,
yWindow = NULL,
windowWidth = NULL,
windowHeight = NULL,
tabRatio = NULL,
activeSheetId = NULL,
showFormulaBar = NULL,
showStatusbar = NULL,
showComments = "commIndicator",
showObjects = "all",
extLst = NULL,
...
)
Arguments
name |
name |
guid |
guid |
autoUpdate |
autoUpdate |
mergeInterval |
mergeInterval |
changesSavedWin |
changesSavedWin |
onlySync |
onlySync |
personalView |
personalView |
includePrintSettings |
includePrintSettings |
includeHiddenRowCol |
includeHiddenRowCol |
maximized |
maximized |
minimized |
minimized |
showHorizontalScroll |
showHorizontalScroll |
showVerticalScroll |
showVerticalScroll |
showSheetTabs |
showSheetTabs |
xWindow |
xWindow |
yWindow |
yWindow |
windowWidth |
windowWidth |
windowHeight |
windowHeight |
tabRatio |
tabRatio |
activeSheetId |
activeSheetId |
showFormulaBar |
showFormulaBar |
showStatusbar |
showStatusbar |
showComments |
showComments |
showObjects |
showObjects |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
DashStop
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.line.html
Usage
DashStop(d = 0L, sp = 0L, ...)
Arguments
d |
d |
sp |
sp |
... |
Additional arguments, i.e. kwargs. |
DashStopList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.line.html
Usage
DashStopList(ds = NULL, ...)
Arguments
ds |
ds |
... |
Additional arguments, i.e. kwargs. |
DataBar
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
DataBar(
minLength = NULL,
maxLength = NULL,
showValue = NULL,
cfvo = NULL,
color = NULL,
...
)
Arguments
minLength |
minLength |
maxLength |
maxLength |
showValue |
showValue |
cfvo |
cfvo |
color |
color |
... |
Additional arguments, i.e. kwargs. |
DataBarRule
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
DataBarRule(
start_type = NULL,
start_value = NULL,
end_type = NULL,
end_value = NULL,
color = NULL,
showValue = NULL,
minLength = NULL,
maxLength = NULL,
...
)
Arguments
start_type |
start_type |
start_value |
start_value |
end_type |
end_type |
end_value |
end_value |
color |
color |
showValue |
showValue |
minLength |
minLength |
maxLength |
maxLength |
... |
Additional arguments, i.e. kwargs |
DataLabel
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.label.html
Usage
DataLabel(idx = 0L, ...)
Arguments
idx |
idx |
... |
Additional arguments, i.e. kwargs. |
DataLabelList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.label.html
Usage
DataLabelList(dLbl = list(), delete = NULL, ...)
Arguments
dLbl |
dLbl |
delete |
delete |
... |
Additional arguments, i.e. kwargs. |
DataPoint
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.marker.html
Usage
DataPoint(
idx = NULL,
invertIfNegative = NULL,
marker = NULL,
bubble3D = NULL,
explosion = NULL,
spPr = NULL,
pictureOptions = NULL,
extLst = NULL,
...
)
Arguments
idx |
idx |
invertIfNegative |
invertIfNegative |
marker |
marker |
bubble3D |
bubble3D |
explosion |
explosion |
spPr |
spPr |
pictureOptions |
pictureOptions |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
DataTable
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.plotarea.html
Usage
DataTable(
showHorzBorder = NULL,
showVertBorder = NULL,
showOutline = NULL,
showKeys = NULL,
spPr = NULL,
txPr = NULL,
extLst = NULL,
...
)
Arguments
showHorzBorder |
showHorzBorder |
showVertBorder |
showVertBorder |
showOutline |
showOutline |
showKeys |
showKeys |
spPr |
spPr |
txPr |
txPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
DataTableFormula
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.formula.html
Usage
DataTableFormula(
ref,
ca = FALSE,
dt2D = FALSE,
dtr = FALSE,
r1 = NULL,
r2 = NULL,
del1 = FALSE,
del2 = FALSE,
...
)
Arguments
ref |
ref |
ca |
ca |
dt2D |
dt2D |
dtr |
dtr |
r1 |
r1 |
r2 |
r2 |
del1 |
del1 |
del2 |
del2 |
... |
Additional arguments, i.e. kwargs. |
DataValidation
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.datavalidation.html
Usage
DataValidation(
type = NULL,
formula1 = NULL,
formula2 = NULL,
showErrorMessage = FALSE,
showInputMessage = FALSE,
showDropDown = FALSE,
allowBlank = FALSE,
sqref = list(),
promptTitle = NULL,
errorStyle = NULL,
error = NULL,
prompt = NULL,
errorTitle = NULL,
imeMode = NULL,
operator = NULL,
allow_blank = FALSE,
...
)
Arguments
type |
type |
formula1 |
formula1 |
formula2 |
formula2 |
showErrorMessage |
showErrorMessage |
showInputMessage |
showInputMessage |
showDropDown |
showDropDown |
allowBlank |
allowBlank |
sqref |
sqref |
promptTitle |
promptTitle |
errorStyle |
errorStyle |
error |
error |
prompt |
prompt |
errorTitle |
errorTitle |
imeMode |
imeMode |
operator |
operator |
allow_blank |
allow_blank |
... |
Additional arguments, i.e. kwargs. |
DataValidationList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.datavalidation.html
Usage
DataValidationList(
disablePrompts = NULL,
xWindow = NULL,
yWindow = NULL,
count = NULL,
dataValidation = list(),
...
)
Arguments
disablePrompts |
disablePrompts |
xWindow |
xWindow |
yWindow |
yWindow |
count |
count |
dataValidation |
dataValidation |
... |
Additional arguments, i.e. kwargs. |
DateAxis
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.axis.html
Usage
DateAxis(
auto = NULL,
lblOffset = NULL,
baseTimeUnit = NULL,
majorUnit = NULL,
majorTimeUnit = NULL,
minorUnit = NULL,
minorTimeUnit = NULL,
extLst = NULL,
...
)
Arguments
auto |
auto |
lblOffset |
lblOffset |
baseTimeUnit |
baseTimeUnit |
majorUnit |
majorUnit |
majorTimeUnit |
majorTimeUnit |
minorUnit |
minorUnit |
minorTimeUnit |
minorTimeUnit |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
DateGroupItem
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
DateGroupItem(
year = NULL,
month = NULL,
day = NULL,
hour = NULL,
minute = NULL,
second = NULL,
dateTimeGrouping = NULL,
...
)
Arguments
year |
year |
month |
month |
day |
day |
hour |
hour |
minute |
minute |
second |
second |
dateTimeGrouping |
dateTimeGrouping |
... |
Additional arguments, i.e. kwargs. |
Days to time
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.datetime.html
Usage
days_to_time(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Deepcopy
Description
https://docs.python.org/3/library/copy.html
Usage
deepcopy(x, memo = NULL, nil = c())
Arguments
x |
x |
memo |
memo |
nil |
_nil |
DefinedName
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.defined_name.html
Usage
DefinedName(
name = NULL,
comment = NULL,
customMenu = NULL,
description = NULL,
help = NULL,
statusBar = NULL,
localSheetId = NULL,
hidden = NULL,
vbProcedure = NULL,
xlm = NULL,
functionGroupId = NULL,
shortcutKey = NULL,
publishToServer = NULL,
workbookParameter = NULL,
attr_text = NULL,
...
)
Arguments
name |
name |
comment |
comment |
customMenu |
customMenu |
description |
description |
help |
help |
statusBar |
statusBar |
localSheetId |
localSheetId |
hidden |
|
vbProcedure |
vbProcedure |
xlm |
xlm |
functionGroupId |
functionGroupId |
shortcutKey |
shortcutKey |
publishToServer |
publishToServer |
workbookParameter |
workbookParameter |
attr_text |
attr_text |
... |
Additional arguments, i.e. kwargs. |
DefinedNameList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.defined_name.html
Usage
DefinedNameList(definedName = list(), ...)
Arguments
definedName |
definedName |
... |
Additional arguments, i.e. kwargs. |
Degrees to angle
Description
1 degree = 60000 angles
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
degrees_to_angle(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
DifferentialStyle
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.differential.html
Usage
DifferentialStyle(
font = NULL,
numFmt = NULL,
fill = NULL,
alignment = NULL,
border = NULL,
protection = NULL,
extLst = NULL,
...
)
Arguments
font |
font |
numFmt |
numFmt |
fill |
fill |
alignment |
alignment |
border |
border |
protection |
protection |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
DifferentialStyleList
Description
Dedupable container for differential styles.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.differential.html
Usage
DifferentialStyleList(dxf = list(), count = NULL, ...)
Arguments
dxf |
dxf |
count |
count |
... |
Additional arguments, i.e. kwargs. |
Dimension
Description
Information about the display properties of a row or column.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.dimensions.html
Usage
Dimension(
index,
hidden,
outlineLevel,
collapsed,
worksheet,
visible = TRUE,
style = NULL,
...
)
Arguments
index |
index |
hidden |
|
outlineLevel |
outlineLevel |
collapsed |
collapsed |
worksheet |
worksheet |
visible |
visible |
style |
style |
... |
Additional arguments, i.e. kwargs. |
DimensionHolder
Description
Allow columns to be grouped
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.dimensions.html
Usage
DimensionHolder(worksheet, reference = "index", default_factory = NULL, ...)
Arguments
worksheet |
worksheet |
reference |
reference |
default_factory |
default_factory |
... |
Additional arguments, i.e. kwargs. |
DisplayUnitsLabel
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.axis.html
Usage
DisplayUnitsLabel(layout = NULL, tx = NULL, spPr = NULL, txPr = NULL, ...)
Arguments
layout |
layout |
tx |
tx |
spPr |
spPr |
txPr |
txPr |
... |
Additional arguments, i.e. kwargs. |
DisplayUnitsLabelList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.axis.html
Usage
DisplayUnitsLabelList(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
DocumentProperties
Description
High-level properties of the document.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.packaging.core.html
Usage
DocumentProperties(
category = NULL,
contentStatus = NULL,
keywords = NULL,
lastModifiedBy = NULL,
lastPrinted = NULL,
revision = NULL,
version = NULL,
created = NULL,
creator = "openpyxl",
description = NULL,
identifier = NULL,
language = NULL,
modified = NULL,
subject = NULL,
title = NULL,
...
)
Arguments
category |
category |
contentStatus |
contentStatus |
keywords |
keywords |
lastModifiedBy |
lastModifiedBy |
lastPrinted |
lastPrinted |
revision |
revision |
version |
version |
created |
created |
creator |
creator |
description |
description |
identifier |
identifier |
language |
language |
modified |
modified |
subject |
subject |
title |
title |
... |
Additional arguments, i.e. kwargs. |
Details
Defined in ECMA-376 Par2 Annex D
DocumentSecurity
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.protection.html
Usage
DocumentSecurity(
workbookPassword = NULL,
workbookPasswordCharacterSet = NULL,
revisionsPassword = NULL,
revisionsPasswordCharacterSet = NULL,
lockStructure = NULL,
lockWindows = NULL,
lockRevision = NULL,
revisionsAlgorithmName = NULL,
revisionsHashValue = NULL,
revisionsSaltValue = NULL,
revisionsSpinCount = NULL,
workbookAlgorithmName = NULL,
workbookHashValue = NULL,
workbookSaltValue = NULL,
workbookSpinCount = NULL,
...
)
Arguments
workbookPassword |
workbookPassword |
workbookPasswordCharacterSet |
workbookPasswordCharacterSet |
revisionsPassword |
revisionsPassword |
revisionsPasswordCharacterSet |
revisionsPasswordCharacterSet |
lockStructure |
lockStructure |
lockWindows |
lockWindows |
lockRevision |
lockRevision |
revisionsAlgorithmName |
revisionsAlgorithmName |
revisionsHashValue |
revisionsHashValue |
revisionsSaltValue |
revisionsSaltValue |
revisionsSpinCount |
revisionsSpinCount |
workbookAlgorithmName |
workbookAlgorithmName |
workbookHashValue |
workbookHashValue |
workbookSaltValue |
workbookSaltValue |
workbookSpinCount |
workbookSpinCount |
... |
Additional arguments, i.e. kwargs. |
DoughnutChart
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.pie_chart.html
Usage
DoughnutChart(firstSliceAng = 0L, holeSize = 10L, extLst = NULL, ...)
Arguments
firstSliceAng |
firstSliceAng |
holeSize |
holeSize |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Drawing
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.drawing.html
Usage
Drawing(id = NULL, ...)
Arguments
id |
id |
... |
Additional arguments, i.e. kwargs. |
DrawingHF
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chartsheet.relation.html
Usage
DrawingHF(
id = NULL,
lho = NULL,
lhe = NULL,
lhf = NULL,
cho = NULL,
che = NULL,
chf = NULL,
rho = NULL,
rhe = NULL,
rhf = NULL,
lfo = NULL,
lfe = NULL,
lff = NULL,
cfo = NULL,
cfe = NULL,
cff = NULL,
rfo = NULL,
rfe = NULL,
rff = NULL,
...
)
Arguments
id |
id |
lho |
lho |
lhe |
lhe |
lhf |
lhf |
cho |
cho |
che |
che |
chf |
chf |
rho |
rho |
rhe |
rhe |
rhf |
rhf |
lfo |
lfo |
lfe |
lfe |
lff |
lff |
cfo |
cfo |
cfe |
cfe |
cff |
cff |
rfo |
rfo |
rfe |
rfe |
rff |
rff |
... |
Additional arguments, i.e. kwargs. |
DummyWorksheet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.reference.html
Usage
DummyWorksheet(title, ...)
Arguments
title |
title |
... |
Additional arguments, i.e. kwargs. |
DuotoneEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
DuotoneEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
Dxa to cm
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
dxa_to_cm(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
DynamicFilter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
DynamicFilter(
type = NULL,
val = NULL,
valIso = NULL,
maxVal = NULL,
maxValIso = NULL,
...
)
Arguments
type |
type |
val |
val |
valIso |
valIso |
maxVal |
maxVal |
maxValIso |
maxValIso |
... |
Additional arguments, i.e. kwargs. |
EffectContainer
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
EffectContainer(type = NULL, name = NULL, ...)
Arguments
type |
type |
name |
name |
... |
Additional arguments, i.e. kwargs. |
EffectList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
EffectList(
blur = NULL,
fillOverlay = NULL,
glow = NULL,
innerShdw = NULL,
outerShdw = NULL,
prstShdw = NULL,
reflection = NULL,
softEdge = NULL,
...
)
Arguments
blur |
blur |
fillOverlay |
fillOverlay |
glow |
glow |
innerShdw |
innerShdw |
outerShdw |
outerShdw |
prstShdw |
prstShdw |
reflection |
reflection |
softEdge |
softEdge |
... |
Additional arguments, i.e. kwargs. |
EmbeddedWAVAudioFile
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.text.html
Usage
EmbeddedWAVAudioFile(name = NULL, ...)
Arguments
name |
name |
... |
Additional arguments, i.e. kwargs. |
EmptyCell
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.read_only.html
Usage
EmptyCell(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
EMU to cm
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
EMU_to_cm(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
EMU to inch
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
EMU_to_inch(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
EMU to pixels
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
EMU_to_pixels(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
ErrorBars
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.error_bar.html
Usage
ErrorBars(
errDir = NULL,
errBarType = "both",
errValType = "fixedVal",
noEndCap = NULL,
plus = NULL,
minus = NULL,
val = NULL,
spPr = NULL,
extLst = NULL,
...
)
Arguments
errDir |
errDir |
errBarType |
errBarType |
errValType |
errValType |
noEndCap |
noEndCap |
plus |
plus |
minus |
minus |
val |
val |
spPr |
spPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ExcelReader
Description
Read an Excel package and dispatch the contents to the relevant modules
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html
Usage
ExcelReader(
fn,
read_only = FALSE,
keep_vba = FALSE,
data_only = FALSE,
keep_links = TRUE,
rich_text = FALSE,
...
)
Arguments
fn |
fn |
read_only |
read_only |
keep_vba |
keep_vba |
data_only |
data_only |
keep_links |
keep_links |
rich_text |
rich_text |
... |
Additional arguments, i.e. kwargs. |
ExcelWriter
Description
Write a workbook object to an Excel file.
https://openpyxl.readthedocs.io/en/latest/api/openpyxl.writer.excel.html
Usage
ExcelWriter(workbook, archive, ...)
Arguments
workbook |
workbook |
archive |
archive |
... |
Additional arguments, i.e. kwargs. |
Expand cell ranges
Description
Expand cell ranges to a sequence of addresses.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.datavalidation.html
Usage
expand_cell_ranges(range_string, ...)
Arguments
range_string |
range_string |
... |
Additional arguments, i.e. kwargs. |
Details
Reverse of collapse_cell_addresses Eg. converts "A1:A2 B1:B2" to (A1, A2, B1, B2)
Extension
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.errors.html
Usage
Extension(uri = NULL, ...)
Arguments
uri |
uri |
... |
Additional arguments, i.e. kwargs. |
ExtensionList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.errors.html
Usage
ExtensionList(ext = list(), ...)
Arguments
ext |
ext |
... |
Additional arguments, i.e. kwargs. |
ExternalBook
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalBook(
sheetNames = NULL,
definedNames = list(),
sheetDataSet = NULL,
id = NULL,
...
)
Arguments
sheetNames |
sheetNames |
definedNames |
definedNames |
sheetDataSet |
sheetDataSet |
id |
id |
... |
Additional arguments, i.e. kwargs. |
ExternalCell
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalCell(r = NULL, t = NULL, vm = NULL, v = NULL, ...)
Arguments
r |
r |
t |
t |
vm |
vm |
v |
v |
... |
Additional arguments, i.e. kwargs. |
ExternalData
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.chartspace.html
Usage
ExternalData(autoUpdate = NULL, id = NULL, ...)
Arguments
autoUpdate |
autoUpdate |
id |
id |
... |
Additional arguments, i.e. kwargs. |
ExternalDefinedName
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalDefinedName(name = NULL, refersTo = NULL, sheetId = NULL, ...)
Arguments
name |
name |
refersTo |
refersTo |
sheetId |
sheetId |
... |
Additional arguments, i.e. kwargs. |
ExternalLink
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalLink(
externalBook = NULL,
ddeLink = NULL,
oleLink = NULL,
extLst = NULL,
...
)
Arguments
externalBook |
externalBook |
ddeLink |
ddeLink |
oleLink |
oleLink |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ExternalReference
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_reference.html
Usage
ExternalReference(id, ...)
Arguments
id |
id |
... |
Additional arguments, i.e. kwargs. |
ExternalRow
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalRow(r = list(), cell = NULL, ...)
Arguments
r |
r |
cell |
cell |
... |
Additional arguments, i.e. kwargs. |
ExternalSheetData
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalSheetData(sheetId = NULL, refreshError = NULL, row = list(), ...)
Arguments
sheetId |
sheetId |
refreshError |
refreshError |
row |
row |
... |
Additional arguments, i.e. kwargs. |
ExternalSheetDataSet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalSheetDataSet(sheetData = NULL, ...)
Arguments
sheetData |
sheetData |
... |
Additional arguments, i.e. kwargs. |
ExternalSheetNames
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.external_link.external.html
Usage
ExternalSheetNames(sheetName = list(), ...)
Arguments
sheetName |
sheetName |
... |
Additional arguments, i.e. kwargs. |
FileSharing
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.protection.html
Usage
FileSharing(
readOnlyRecommended = NULL,
userName = NULL,
reservationPassword = NULL,
algorithmName = NULL,
hashValue = NULL,
saltValue = NULL,
spinCount = NULL,
...
)
Arguments
readOnlyRecommended |
readOnlyRecommended |
userName |
userName |
reservationPassword |
reservationPassword |
algorithmName |
algorithmName |
hashValue |
hashValue |
saltValue |
saltValue |
spinCount |
spinCount |
... |
Additional arguments, i.e. kwargs. |
FileVersion
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.properties.html
Usage
FileVersion(
appName = NULL,
lastEdited = NULL,
lowestEdited = NULL,
rupBuild = NULL,
codeName = NULL,
...
)
Arguments
appName |
appName |
lastEdited |
lastEdited |
lowestEdited |
lowestEdited |
rupBuild |
rupBuild |
codeName |
codeName |
... |
Additional arguments, i.e. kwargs. |
Fill
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.fills.html
Usage
Fill(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
FillOverlayEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
FillOverlayEffect(blend = NULL, ...)
Arguments
blend |
blend |
... |
Additional arguments, i.e. kwargs. |
FilterColumn
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
FilterColumn(
colId = NULL,
hiddenButton = FALSE,
showButton = TRUE,
filters = NULL,
top10 = NULL,
customFilters = NULL,
dynamicFilter = NULL,
colorFilter = NULL,
iconFilter = NULL,
extLst = NULL,
blank = NULL,
vals = NULL,
...
)
Arguments
colId |
colId |
hiddenButton |
|
showButton |
showButton |
filters |
filters |
top10 |
top10 |
customFilters |
customFilters |
dynamicFilter |
dynamicFilter |
colorFilter |
colorFilter |
iconFilter |
iconFilter |
extLst |
extLst |
blank |
blank |
vals |
vals |
... |
Additional arguments, i.e. kwargs. |
Filters
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
Filters(
blank = NULL,
calendarType = NULL,
filter = list(),
dateGroupItem = list(),
...
)
Arguments
blank |
blank |
calendarType |
calendarType |
filter |
filter |
dateGroupItem |
dateGroupItem |
... |
Additional arguments, i.e. kwargs. |
Find images
Description
Given the path to a drawing file extract charts and images
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.drawings.html
Usage
find_images(archive, path, ...)
Arguments
archive |
archive |
path |
path |
... |
Additional arguments, i.e. kwargs. |
Details
Ignore errors due to unsupported parts of DrawingML
Font
Description
Font options used in styles.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.fills.html
Usage
Font(
name = NULL,
sz = NULL,
b = NULL,
i = NULL,
charset = NULL,
u = NULL,
strike = NULL,
color = NULL,
scheme = NULL,
family = NULL,
size = NULL,
bold = NULL,
italic = NULL,
strikethrough = NULL,
underline = NULL,
vertAlign = NULL,
outline = NULL,
shadow = NULL,
condense = NULL,
extend = NULL,
...
)
Arguments
name |
name |
sz |
sz |
b |
b |
i |
i |
charset |
charset |
u |
u |
strike |
strike |
color |
color |
scheme |
scheme |
family |
family |
size |
size |
bold |
bold |
italic |
italic |
strikethrough |
strikethrough |
underline |
underline |
vertAlign |
vertAlign |
outline |
outline |
shadow |
shadow |
condense |
condense |
extend |
extend |
... |
Additional arguments, i.e. kwargs. |
FontReference
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
FontReference(idx = NULL, ...)
Arguments
idx |
idx |
... |
Additional arguments, i.e. kwargs. |
FormatObject
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
FormatObject(type, val = NULL, gte = NULL, extLst = NULL, ...)
Arguments
type |
type |
val |
val |
gte |
gte |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs |
FormulaRule
Description
Conditional formatting with custom differential style
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
FormulaRule(
formula = NULL,
stopIfTrue = NULL,
font = NULL,
border = NULL,
fill = NULL,
...
)
Arguments
formula |
formula |
stopIfTrue |
stopIfTrue |
font |
font |
border |
border |
fill |
fill |
... |
Additional arguments, i.e. kwargs. |
From ISO8601
Description
Convert from a timestamp string to a datetime object.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.datetime.html
Usage
from_ISO8601(formatted_string, ...)
Arguments
formatted_string |
formatted_string |
... |
Additional arguments, i.e. kwargs. |
Details
According to 18.17.4 in the specification the following ISO 8601 formats are supported. Dates B.1.1 and B.2.1 Times B.1.2 and B.2.2 Datetimes B.1.3 and B.2.3 There is no concept of timedeltas in the specification, but Excel writes them (in strict OOXML mode), so these are also understood.
FunctionGroup
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.function_group.html
Usage
FunctionGroup(name = NULL, ...)
Arguments
name |
name |
... |
Additional arguments, i.e. kwargs. |
FunctionGroupList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.workbook.function_group.html
Usage
FunctionGroupList(builtInGroupCount = 16L, functionGroup = list(), ...)
Arguments
builtInGroupCount |
builtInGroupCount |
functionGroup |
functionGroup |
... |
Additional arguments, i.e. kwargs. |
GeomGuide
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
GeomGuide(name = NULL, fmla = NULL, ...)
Arguments
name |
name |
fmla |
fmla |
... |
Additional arguments, i.e. kwargs. |
GeomGuideList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
GeomGuideList(gd = NULL, ...)
Arguments
gd |
gd |
... |
Additional arguments, i.e. kwargs. |
GeomRect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
GeomRect(l = NULL, t = NULL, r = NULL, b = NULL, ...)
Arguments
l |
l |
t |
t |
r |
r |
b |
b |
... |
Additional arguments, i.e. kwargs. |
Get column interval
Description
Given the start and end columns, return all the columns in the series.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
get_column_interval(start, end, ...)
Arguments
start |
start |
end |
end |
... |
Additional arguments, i.e. kwargs. |
Details
The start and end columns can be either column letters or 1-based indexes.
Get column letter
Description
Convert a column index into a column letter
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.cell.html
Usage
get_column_letter(idx, ...)
Arguments
idx |
idx |
... |
Additional arguments, i.e. kwargs. |
Details
(3 -> 'C')
Get time format
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.cell.html
Usage
get_time_format(t, ...)
Arguments
t |
t |
... |
Additional arguments, i.e. kwargs. |
Get type
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.cell.html
Usage
get_type(t, value, ...)
Arguments
t |
t |
value |
value |
... |
Additional arguments, i.e. kwargs. |
GlowEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
GlowEffect(rad = NULL, ...)
Arguments
rad |
rad |
... |
Additional arguments, i.e. kwargs. |
GradientFill
Description
Fill areas with gradient
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.fills.html
Usage
GradientFill(
type = "linear",
degree = 0L,
left = 0L,
right = 0L,
top = 0L,
bottom = 0L,
stop = list(),
...
)
Arguments
type |
type |
degree |
degree |
left |
left |
right |
right |
top |
top |
bottom |
bottom |
stop |
stop |
... |
Additional arguments, i.e. kwargs. |
Details
Two types of gradient fill are supported: - A type='linear' gradient interpolates colours between a set of specified Stops, across the length of an area. The gradient is left-to-right by default, but this orientation can be modified with the degree attribute. A list of Colors can be provided instead and they will be positioned with equal distance between them. - A type='path' gradient applies a linear gradient from each edge of the area. Attributes top, right, bottom, left specify the extent of fill from the respective borders. Thus top="0.2" will fill the top 20
GradientFillProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.fill.html
Usage
GradientFillProperties(
flip = NULL,
rotWithShape = NULL,
gsLst = list(),
lin = NULL,
path = NULL,
tileRect = NULL,
...
)
Arguments
flip |
flip |
rotWithShape |
rotWithShape |
gsLst |
gsLst |
lin |
lin |
path |
path |
tileRect |
tileRect |
... |
Additional arguments, i.e. kwargs. |
GradientStop
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.fill.html
Usage
GradientStop(
pos = NULL,
scrgbClr = NULL,
srgbClr = NULL,
hslClr = NULL,
sysClr = NULL,
schemeClr = NULL,
prstClr = NULL,
...
)
Arguments
pos |
pos |
scrgbClr |
scrgbClr |
srgbClr |
srgbClr |
hslClr |
hslClr |
sysClr |
sysClr |
schemeClr |
schemeClr |
prstClr |
prstClr |
... |
Additional arguments, i.e. kwargs. |
GraphicalProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.shapes.html
Usage
GraphicalProperties(
bwMode = NULL,
xfrm = NULL,
noFill = NULL,
solidFill = NULL,
gradFill = NULL,
pattFill = NULL,
ln = NULL,
scene3d = NULL,
custGeom = NULL,
prstGeom = NULL,
sp3d = NULL,
extLst = NULL,
...
)
Arguments
bwMode |
bwMode |
xfrm |
xfrm |
noFill |
noFill |
solidFill |
solidFill |
gradFill |
gradFill |
pattFill |
pattFill |
ln |
ln |
scene3d |
scene3d |
custGeom |
custGeom |
prstGeom |
prstGeom |
sp3d |
sp3d |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Details
This element specifies the formatting for the parent chart element. The custGeom, prstGeom, scene3d, and xfrm elements are not supported. The bwMode attribute is not supported. This doesn't leave much. And the element is used in different places.
GraphicData
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.graphic.html
Usage
GraphicData(
uri = "http://schemas.openxmlformats.org/drawingml/2006/chart",
chart = NULL,
...
)
Arguments
uri |
uri |
chart |
chart |
... |
Additional arguments, i.e. kwargs. |
GraphicFrame
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.graphic.html
Usage
GraphicFrame(
nvGraphicFramePr = NULL,
xfrm = NULL,
graphic = NULL,
macro = NULL,
fPublished = NULL,
...
)
Arguments
nvGraphicFramePr |
nvGraphicFramePr |
xfrm |
xfrm |
graphic |
graphic |
macro |
macro |
fPublished |
fPublished |
... |
Additional arguments, i.e. kwargs. |
GraphicFrameLocking
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.graphic.html
Usage
GraphicFrameLocking(
noGrp = NULL,
noDrilldown = NULL,
noSelect = NULL,
noChangeAspect = NULL,
noMove = NULL,
noResize = NULL,
extLst = NULL,
...
)
Arguments
noGrp |
noGrp |
noDrilldown |
noDrilldown |
noSelect |
noSelect |
noChangeAspect |
noChangeAspect |
noMove |
noMove |
noResize |
noResize |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
GraphicObject
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.graphic.html
Usage
GraphicObject(graphicData = NULL, ...)
Arguments
graphicData |
graphicData |
... |
Additional arguments, i.e. kwargs. |
GrayscaleEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
GrayscaleEffect(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
GroupLocking
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.properties.html
Usage
GroupLocking(
noGrp = NULL,
noUngrp = NULL,
noSelect = NULL,
noRot = NULL,
noChangeAspect = NULL,
noChangeArrowheads = NULL,
noMove = NULL,
noResize = NULL,
noEditPoints = NULL,
noAdjustHandles = NULL,
noChangeShapeType = NULL,
extLst = NULL,
...
)
Arguments
noGrp |
noGrp |
noUngrp |
noUngrp |
noSelect |
noSelect |
noRot |
noRot |
noChangeAspect |
noChangeAspect |
noChangeArrowheads |
noChangeArrowheads |
noMove |
noMove |
noResize |
noResize |
noEditPoints |
noEditPoints |
noAdjustHandles |
noAdjustHandles |
noChangeShapeType |
noChangeShapeType |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
GroupShape
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.graphic.html
Usage
GroupShape(nvGrpSpPr = NULL, grpSpPr = NULL, pic = NULL, ...)
Arguments
nvGrpSpPr |
nvGrpSpPr |
grpSpPr |
grpSpPr |
pic |
pic |
... |
Additional arguments, i.e. kwargs. |
GroupShapeProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.properties.html
Usage
GroupShapeProperties(
bwMode = NULL,
xfrm = NULL,
scene3d = NULL,
extLst = NULL,
...
)
Arguments
bwMode |
bwMode |
xfrm |
xfrm |
scene3d |
scene3d |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
GroupTransform2D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
GroupTransform2D(
rot = 0L,
flipH = NULL,
flipV = NULL,
off = NULL,
ext = NULL,
chOff = NULL,
chExt = NULL,
...
)
Arguments
rot |
rot |
flipH |
flipH |
flipV |
flipV |
off |
off |
ext |
ext |
chOff |
chOff |
chExt |
chExt |
... |
Additional arguments, i.e. kwargs. |
Hash password
Description
Create a password hash from a given string for protecting a worksheet
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.protection.html
Usage
hash_password(plaintext_password = "", ...)
Arguments
plaintext_password |
plaintext_password |
... |
Additional arguments, i.e. kwargs. |
Details
only. This will not work for encrypting a workbook. This method is based on the algorithm provided by Daniel Rentz of OpenOffice and the PEAR package Spreadsheet_Excel_Writer by Xavier Noguer <[email protected]>. See also http://blogs.msdn.com/b/ericwhite/archive/2008/02/23/the-legacy-hashing-algorithm-in-open-xml.aspx
HeaderFooter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.header_footer.html
Usage
HeaderFooter(
differentOddEven = NULL,
differentFirst = NULL,
scaleWithDoc = NULL,
alignWithMargins = NULL,
oddHeader = NULL,
oddFooter = NULL,
evenHeader = NULL,
evenFooter = NULL,
firstHeader = NULL,
firstFooter = NULL,
...
)
Arguments
differentOddEven |
differentOddEven |
differentFirst |
differentFirst |
scaleWithDoc |
scaleWithDoc |
alignWithMargins |
alignWithMargins |
oddHeader |
oddHeader |
oddFooter |
oddFooter |
evenHeader |
evenHeader |
evenFooter |
evenFooter |
firstHeader |
firstHeader |
firstFooter |
firstFooter |
... |
Additional arguments, i.e. kwargs. |
HeaderFooterItem
Description
Header or footer item
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.header_footer.html
Usage
HeaderFooterItem(left = NULL, right = NULL, center = NULL, ...)
Arguments
left |
left |
right |
right |
center |
center |
... |
Additional arguments, i.e. kwargs. |
HSLColor
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.colors.html
Usage
HSLColor(hue = NULL, sat = NULL, lum = NULL, ...)
Arguments
hue |
hue |
sat |
sat |
lum |
lum |
... |
Additional arguments, i.e. kwargs. |
HSLEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
HSLEffect(hue = NULL, sat = NULL, lum = NULL, ...)
Arguments
hue |
hue |
sat |
sat |
lum |
lum |
... |
Additional arguments, i.e. kwargs. |
Hyperlink
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.hyperlink.html
Usage
Hyperlink(
ref = NULL,
location = NULL,
tooltip = NULL,
display = NULL,
id = NULL,
target = NULL,
...
)
Arguments
ref |
ref |
location |
location |
tooltip |
tooltip |
display |
display |
id |
id |
target |
target |
... |
Additional arguments, i.e. kwargs. |
HyperlinkList
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.hyperlink.html
Usage
HyperlinkList(hyperlink = list(), ...)
Arguments
hyperlink |
hyperlink |
... |
Additional arguments, i.e. kwargs. |
Iadd
Description
https://docs.python.org/3/library/operator.html#in-place-operators
Usage
iadd(a, b)
Arguments
a |
a |
b |
b |
IconFilter
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.filters.html
Usage
IconFilter(iconSet = NULL, iconId = NULL, ...)
Arguments
iconSet |
iconSet |
iconId |
iconId |
... |
Additional arguments, i.e. kwargs. |
IconSet
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
IconSet(
iconSet = NULL,
showValue = NULL,
percent = NULL,
reverse = NULL,
cfvo = NULL,
...
)
Arguments
iconSet |
iconSet |
showValue |
showValue |
percent |
percent |
reverse |
reverse |
cfvo |
cfvo |
... |
Additional arguments, i.e. kwargs |
IconSetRule
Description
Convenience function for creating icon set rules
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
IconSetRule(
icon_style = NULL,
type = NULL,
values = NULL,
showValue = NULL,
percent = NULL,
reverse = NULL,
...
)
Arguments
icon_style |
icon_style |
type |
type |
values |
values |
showValue |
showValue |
percent |
percent |
reverse |
reverse |
... |
Additional arguments, i.e. kwargs |
IgnoredError
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.errors.html
Usage
IgnoredError(
sqref = NULL,
evalError = FALSE,
twoDigitTextYear = FALSE,
numberStoredAsText = FALSE,
formula = FALSE,
formulaRange = FALSE,
unlockedFormula = FALSE,
emptyCellReference = FALSE,
listDataValidation = FALSE,
calculatedColumn = FALSE,
...
)
Arguments
sqref |
sqref |
evalError |
evalError |
twoDigitTextYear |
twoDigitTextYear |
numberStoredAsText |
numberStoredAsText |
formula |
formula |
formulaRange |
formulaRange |
unlockedFormula |
unlockedFormula |
emptyCellReference |
emptyCellReference |
listDataValidation |
listDataValidation |
calculatedColumn |
calculatedColumn |
... |
Additional arguments, i.e. kwargs. |
IgnoredErrors
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.errors.html
Usage
IgnoredErrors(ignoredError = list(), extLst = NULL, ...)
Arguments
ignoredError |
ignoredError |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Image
Description
Image in a spreadsheet
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.image.html
Usage
Image(img, ...)
Arguments
img |
img |
... |
Additional arguments, i.e. kwargs. |
Inch to dxa
Description
1 inch = 72 * 20 dxa
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
inch_to_dxa(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
Inch to EMU
Description
1 inch = 914400 EMUs
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.utils.units.html
Usage
inch_to_EMU(value, ...)
Arguments
value |
value |
... |
Additional arguments, i.e. kwargs. |
InlineFont
Description
Font for inline text because, yes what you need are different objects with the same elements but different constraints.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.text.html
Usage
InlineFont(
rFont = NULL,
charset = NULL,
family = NULL,
b = NULL,
i = NULL,
strike = NULL,
outline = NULL,
shadow = NULL,
condense = NULL,
extend = NULL,
color = NULL,
sz = NULL,
u = NULL,
vertAlign = NULL,
scheme = NULL,
...
)
Arguments
rFont |
rFont |
charset |
charset |
family |
family |
b |
b |
i |
i |
strike |
strike |
outline |
outline |
shadow |
shadow |
condense |
condense |
extend |
extend |
color |
color |
sz |
sz |
u |
u |
vertAlign |
vertAlign |
scheme |
scheme |
... |
Additional arguments, i.e. kwargs. |
InnerShadowEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
InnerShadowEffect(blurRad = NULL, dist = NULL, dir = NULL, ...)
Arguments
blurRad |
blurRad |
dist |
dist |
dir |
dir |
... |
Additional arguments, i.e. kwargs. |
InputCells
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.scenario.html
Usage
InputCells(
r = NULL,
deleted = FALSE,
undone = FALSE,
val = NULL,
numFmtId = NULL,
...
)
Arguments
r |
r |
deleted |
deleted |
undone |
undone |
val |
val |
numFmtId |
numFmtId |
... |
Additional arguments, i.e. kwargs. |
Insert cols
Description
Insert column or columns before col idx
Usage
insert_cols(py_obj, idx, amount = 1L)
Arguments
py_obj |
py_obj |
idx |
idx |
amount |
amount |
Insert rows
Description
Insert row or rows before row idx
Usage
insert_rows(py_obj, idx, amount = 1L)
Arguments
py_obj |
py_obj |
idx |
idx |
amount |
amount |
Install openpyxl
Description
Install openpyxl Python module
Usage
install_openpyxl(method = "auto", conda = "auto")
Arguments
method |
method |
conda |
conda |
Install pillow
Description
Module needed include images in an openpylx file.
Usage
install_pillow(method = "auto", conda = "auto")
Arguments
method |
method |
conda |
conda |
Is builtin
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
is_builtin(fmt, ...)
Arguments
fmt |
fmt |
... |
Additional arguments, i.e. kwargs. |
Is date format
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
is_date_format(fmt, ...)
Arguments
fmt |
fmt |
... |
Additional arguments, i.e. kwargs. |
Is datetime
Description
Return date, time or datetime
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
is_datetime(fmt, ...)
Arguments
fmt |
fmt |
... |
Additional arguments, i.e. kwargs. |
Is timedelta format
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.numbers.html
Usage
is_timedelta_format(fmt, ...)
Arguments
fmt |
fmt |
... |
Additional arguments, i.e. kwargs. |
Isgenerator
Description
Return true if the object is a generator.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.worksheet.html
Usage
isgenerator(object, ...)
Arguments
object |
object |
... |
Additional arguments, i.e. kwargs. |
Details
Generator objects provide these attributes: __iter__ defined to support iteration over container close raises a new GeneratorExit exception inside the generator to terminate the iteration gi_code code object gi_frame frame object or possibly NULL once the generator has been exhausted gi_running set to 1 when generator is executing, 0 otherwise next return the next item from the container send resumes the generator and "sends" a value that becomes the result of the current yield-expression throw used to raise an exception inside the generator
Layout
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.layout.html
Usage
Layout(manualLayout = NULL, extLst = NULL, ...)
Arguments
manualLayout |
manualLayout |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Legend
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.legend.html
Usage
Legend(
legendPos = "r",
legendEntry = list(),
layout = NULL,
overlay = NULL,
spPr = NULL,
txPr = NULL,
extLst = NULL,
...
)
Arguments
legendPos |
legendPos |
legendEntry |
legendEntry |
layout |
layout |
overlay |
overlay |
spPr |
spPr |
txPr |
txPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
LegendEntry
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.legend.html
Usage
LegendEntry(idx = 0, delete = NULL, txPr = NULL, extLst = NULL, ...)
Arguments
idx |
idx |
delete |
delete |
txPr |
txPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Level
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.data_source.html
Usage
Level(pt = list(), ...)
Arguments
pt |
pt |
... |
Additional arguments, i.e. kwargs. |
LightRig
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.geometry.html
Usage
LightRig(rig = NULL, dir = NULL, rot = NULL, ...)
Arguments
rig |
rig |
dir |
dir |
rot |
rot |
... |
Additional arguments, i.e. kwargs. |
LinearShadeProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.fill.html
Usage
LinearShadeProperties(ang = NULL, scaled = NULL, ...)
Arguments
ang |
ang |
scaled |
scaled |
... |
Additional arguments, i.e. kwargs. |
LineBreak
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.text.html
Usage
LineBreak(rPr = NULL, ...)
Arguments
rPr |
rPr |
... |
Additional arguments, i.e. kwargs. |
LineChart
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.line_chart.html
Usage
LineChart(
hiLowLines = NULL,
upDownBars = NULL,
marker = NULL,
smooth = NULL,
extLst = NULL,
...
)
Arguments
hiLowLines |
hiLowLines |
upDownBars |
upDownBars |
marker |
marker |
smooth |
smooth |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
LineChart3D
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.line_chart.html
Usage
LineChart3D(
gapDepth = NULL,
hiLowLines = NULL,
upDownBars = NULL,
marker = NULL,
smooth = NULL,
...
)
Arguments
gapDepth |
gapDepth |
hiLowLines |
hiLowLines |
upDownBars |
upDownBars |
marker |
marker |
smooth |
smooth |
... |
Additional arguments, i.e. kwargs. |
LineEndProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.line.html
Usage
LineEndProperties(type = NULL, w = NULL, len = NULL, ...)
Arguments
type |
type |
w |
w |
len |
len |
... |
Additional arguments, i.e. kwargs. |
LineProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.line.html
Usage
LineProperties(
w = NULL,
cap = NULL,
cmpd = NULL,
algn = NULL,
noFill = NULL,
solidFill = NULL,
gradFill = NULL,
pattFill = NULL,
prstDash = NULL,
custDash = NULL,
round = NULL,
bevel = NULL,
miter = NULL,
headEnd = NULL,
tailEnd = NULL,
extLst = NULL,
...
)
Arguments
w |
w |
cap |
cap |
cmpd |
cmpd |
algn |
algn |
noFill |
noFill |
solidFill |
solidFill |
gradFill |
gradFill |
pattFill |
pattFill |
prstDash |
prstDash |
custDash |
custDash |
round |
round |
bevel |
bevel |
miter |
miter |
headEnd |
headEnd |
tailEnd |
tailEnd |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
ListStyle
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.text.html
Usage
ListStyle(
defPPr = NULL,
lvl1pPr = NULL,
lvl2pPr = NULL,
lvl3pPr = NULL,
lvl4pPr = NULL,
lvl5pPr = NULL,
lvl6pPr = NULL,
lvl7pPr = NULL,
lvl8pPr = NULL,
lvl9pPr = NULL,
extLst = NULL,
...
)
Arguments
defPPr |
defPPr |
lvl1pPr |
lvl1pPr |
lvl2pPr |
lvl2pPr |
lvl3pPr |
lvl3pPr |
lvl4pPr |
lvl4pPr |
lvl5pPr |
lvl5pPr |
lvl6pPr |
lvl6pPr |
lvl7pPr |
lvl7pPr |
lvl8pPr |
lvl8pPr |
lvl9pPr |
lvl9pPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Load workbook
Description
Open the given filename and return the workbook
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.reader.excel.html
Usage
load_workbook(
filename,
read_only = FALSE,
keep_vba = FALSE,
data_only = FALSE,
keep_links = TRUE,
rich_text = FALSE,
...
)
Arguments
filename |
filename string or a file-like object open in binary mode c.f., :class:'zipfile.ZipFile' :param read_only: optimised for reading, content cannot be edited |
read_only |
read_only bool |
keep_vba |
keep_vba preserve vba content (this does NOT mean you can use it) |
data_only |
data_only bool |
keep_links |
keep_links whether links to external workbooks should be preserved. The default is TRUE |
rich_text |
rich_text bool :rtype: :class:'openpyxl.workbook.Workbook' .. note:: When using lazy load, all worksheets will be :class:'openpyxl.worksheet.iter_worksheet.IterableWorksheet' and the returned workbook will be read-only. |
... |
Additional arguments, i.e. kwargs. |
LuminanceEffect
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.effect.html
Usage
LuminanceEffect(bright = 0L, contrast = 0L, ...)
Arguments
bright |
bright |
contrast |
contrast |
... |
Additional arguments, i.e. kwargs. |
ManualLayout
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.layout.html
Usage
ManualLayout(
layoutTarget = NULL,
xMode = NULL,
yMode = NULL,
wMode = "factor",
hMode = "factor",
x = NULL,
y = NULL,
w = NULL,
h = NULL,
extLst = NULL,
...
)
Arguments
layoutTarget |
layoutTarget |
xMode |
xMode |
yMode |
yMode |
wMode |
wMode |
hMode |
hMode |
x |
x |
y |
y |
w |
w |
h |
h |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
Marker
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.marker.html
Usage
Marker(symbol = NULL, size = NULL, spPr = NULL, extLst = NULL, ...)
Arguments
symbol |
symbol |
size |
size |
spPr |
spPr |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
MergeCell
Description
Represents a range in a sheet: title and coordinates.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.merge.html
Usage
MergeCell(ref = NULL, ...)
Arguments
ref |
ref |
... |
Additional arguments, i.e. kwargs. |
Details
This object is used to perform operations on ranges, like: - shift, expand or shrink - union/intersection with another sheet range, We can check whether a range is: - equal or not equal to another, - disjoint of another, - contained in another. We can get: - the size of a range. - the range bounds (vertices) - the coordinates, - the string representation,
MergeCells
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.merge.html
Usage
MergeCells(count = NULL, mergeCell = list(), ...)
Arguments
count |
count |
mergeCell |
mergeCell |
... |
Additional arguments, i.e. kwargs. |
MergedCell
Description
Describes the properties of a cell in a merged cell and helps to display the borders of the merged cell.
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.cell.html
Usage
MergedCell(worksheet, row = NULL, column = NULL, ...)
Arguments
worksheet |
worksheet |
row |
row |
column |
column |
... |
Additional arguments, i.e. kwargs. |
Details
The value of a MergedCell is always NULL.
MergedCellRange
Description
MergedCellRange stores the border information of a merged cell in the top
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.merge.html
Usage
MergedCellRange(worksheet, coord, ...)
Arguments
worksheet |
worksheet |
coord |
coord |
... |
Additional arguments, i.e. kwargs. |
Details
left cell of the merged cell. The remaining cells in the merged cell are stored as MergedCell objects and get their border information from the upper left cell.
Move sheet
Description
Move a sheet or sheetname
Usage
move_sheet(py_obj, sheet, offset = 0L)
Arguments
py_obj |
py_obj |
sheet |
sheet |
offset |
offset |
MultiCellRange
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.cell_range.html
Usage
MultiCellRange(ranges = list(), ...)
Arguments
ranges |
ranges |
... |
Additional arguments, i.e. kwargs. |
MultiLevelStrData
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.data_source.html
Usage
MultiLevelStrData(ptCount = NULL, lvl = list(), extLst = NULL, ...)
Arguments
ptCount |
ptCount |
lvl |
lvl |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
MultiLevelStrRef
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.data_source.html
Usage
MultiLevelStrRef(f = NULL, multiLvlStrCache = NULL, extLst = NULL, ...)
Arguments
f |
f |
multiLvlStrCache |
multiLvlStrCache |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
NamedStyle
Description
Named and editable styles
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.named_styles.html
Usage
NamedStyle(
name = "Normal",
font = NULL,
fill = NULL,
border = NULL,
alignment = NULL,
number_format = NULL,
protection = NULL,
builtinId = NULL,
hidden = FALSE,
xfId = NULL,
...
)
Arguments
name |
name |
font |
font |
fill |
fill |
border |
border |
alignment |
alignment |
number_format |
number_format |
protection |
protection |
builtinId |
builtinId |
hidden |
|
xfId |
xfId |
... |
Additional arguments, i.e. kwargs. |
NamedStyleList
Description
Named styles are editable and can be applied to multiple objects
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.styles.named_styles.html
Usage
NamedStyleList(iterable = list(), ...)
Arguments
iterable |
iterable |
... |
Additional arguments, i.e. kwargs. |
Details
As only the index is stored in referencing objects the order mus be preserved.
NestedGapAmount
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.descriptors.html
Usage
NestedGapAmount(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
NestedOverlap
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.chart.descriptors.html
Usage
NestedOverlap(...)
Arguments
... |
Additional arguments, i.e. kwargs. |
NonVisualConnectorProperties
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.connector.html
Usage
NonVisualConnectorProperties(
cxnSpLocks = NULL,
stCxn = NULL,
endCxn = NULL,
extLst = NULL,
...
)
Arguments
cxnSpLocks |
cxnSpLocks |
stCxn |
stCxn |
endCxn |
endCxn |
extLst |
extLst |
... |
Additional arguments, i.e. kwargs. |
NonVisualDrawingProps
Description
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.drawing.properties.html
Usage
NonVisualDrawingProps(
id = NULL,
name = NULL,
descr = NULL,
hidden = NULL,
title = NULL,
hlinkClick = NULL,
hlinkHover = NULL,
extLst = NULL,
...
)
Arguments
id |
id |
name |
name |
descr |
descr |
hidden |
|
title |
title |
hlinkClick |
hlinkCli |