User Guide
Reference
Changelog
API
/
Workbook.__getitem__()
API Index
Classes
Workbook
cell.Cell
cell.MergedCell
cell.ReadOnlyCell
chart.AreaChart
chart.AreaChart3D
chart.BarChart
chart.BarChart3D
chart.BubbleChart
chart.DoughnutChart
chart.LineChart
chart.LineChart3D
chart.PieChart
chart.PieChart3D
chart.ProjectedPieChart
chart.RadarChart
chart.Reference
chart.ScatterChart
chart.StockChart
chart.SurfaceChart
chart.SurfaceChart3D
chartsheet.Chartsheet
comments.Comment
drawing.Drawing
formatting.Rule
formula.Tokenizer
styles.Alignment
styles.Border
styles.Color
styles.Fill
styles.Font
styles.GradientFill
styles.NamedStyle
styles.NumberFormatDescriptor
styles.PatternFill
styles.Protection
styles.Side
typed_serialisable.ElementList
typed_serialisable.Extension
typed_serialisable.ExtensionList
typed_serialisable.MetaSerialisable
typed_serialisable.NestedValInt
typed_serialisable.Serialisable
Dataclasses
typed_serialisable.FieldInfo
Workbook Methods
Workbook.create_sheet()
Workbook.move_sheet()
Workbook.remove()
Workbook.remove_sheet()
Workbook.create_chartsheet()
Workbook.get_sheet_by_name()
Workbook.__contains__()
Workbook.index()
Workbook.get_index()
Workbook.__getitem__()
Workbook.__delitem__()
Workbook.__iter__()
Workbook.get_sheet_names()
Workbook.create_named_range()
Workbook.add_named_style()
Workbook.save()
Workbook.materialize_pending_style_components()
Workbook.copy_worksheet()
Workbook.close()
Functions
cell.WriteOnlyCell()
chart.Series()
compat.deprecated
compat.safe_string()
load_workbook()
open()
styles.is_builtin()
styles.is_date_format()
styles.is_timedelta_format()
typed_serialisable.AliasField()
typed_serialisable.explicit_none_element()
xml.defusedxml_available()
xml.defusedxml_env_set()
xml.lxml_available()
xml.lxml_env_set()
Constants
compat.NUMERIC_TYPES
styles.DEFAULT_FONT
typed_serialisable.Field
xml.DEFUSEDXML
xml.LXML
Other
packaging
pivot
reader
workbook.Workbook
worksheet
writer
On this page
Parameters
Workbook.__getitem__()
Returns a worksheet by its name.
Usage
Source
Workbook
.
__getitem__
(
key
)
Parameters
name
:
string
the name of the worksheet to look for