pandas 1.4.2

Parameters

See read_excel for more documentation.

Parameters

path_or_buffer : str, bytes, path object (pathlib.Path or py._path.local.LocalPath),

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.

engine : str, default None

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.

versionchanged

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.

Examples

See :

Local connectivity graph

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


File: /pandas/io/excel/_base.py#1283
type: <class 'type'>
Commit: