See read_excel for more documentation.
a file-like object, xlrd workbook or openpyxl workbook. If a string or path object, expected to be a path to a .xls, .xlsx, .xlsb, .xlsm, .odf, .ods, or .odt file.
If io is not a buffer or path, this must be set to identify io. Supported engines: xlrd
, openpyxl
, odf
, pyxlsb
Engine compatibility :
xlrd
supports old-style Excel files (.xls).
openpyxl
supports newer Excel file formats.
odf
supports OpenDocument file formats (.odf, .ods, .odt).
pyxlsb
supports Binary Excel files.
The engine :None:None:`xlrd <https://xlrd.readthedocs.io/en/latest/>`
now only supports old-style .xls
files. When engine=None
, the following logic will be used to determine the engine:
If path_or_buffer
is an OpenDocument format (.odf, .ods, .odt), then :None:None:`odf <https://pypi.org/project/odfpy/>`
will be used.
Otherwise if path_or_buffer
is an xls format, xlrd
will be used.
Otherwise if path_or_buffer
is in xlsb format, :None:None:`pyxlsb <https://pypi.org/project/pyxlsb/>`
will be used.
.. versionadded:: 1.3.0
Otherwise if :None:None:`openpyxl <https://pypi.org/project/openpyxl/>`
is installed, then openpyxl
will be used.
Otherwise if xlrd >= 2.0
is installed, a ValueError
will be raised.
Otherwise xlrd
will be used and a FutureWarning
will be raised. This case will raise a ValueError
in a future version of pandas.
.. warning:: Please do not report issues when using ``xlrd`` to read ``.xlsx`` files. This is not supported, switch to using ``openpyxl`` instead.
Class for parsing tabular excel sheets into DataFrame objects.
Hover to see nodes names; edges to Self not shown, Caped at 50 nodes.
Using a canvas is more power efficient and can get hundred of nodes ; but does not allow hyperlinks; , arrows or text (beyond on hover)
SVG is more flexible but power hungry; and does not scale well to 50 + nodes.
All aboves nodes referred to, (or are referred from) current nodes; Edges from Self to other have been omitted (or all nodes would be connected to the central node "self" which is not useful). Nodes are colored by the library they belong to, and scaled with the number of references pointing them