Integers are used in zero-indexed sheet positions (chart sheets do not count as a sheet position). Lists of strings/integers are used to request multiple sheets.

See also ExcelFile.parse Parse a sheet into a DataFrame. read_excel Read an Excel file into a pandas DataFrame. If you know the sheet names, it may be easier to specify them directly to …

Parse specified sheet (s) into a DataFrame. Equivalent to read_excel (ExcelFile, …) See the read_excel docstring for more info on accepted parameters. Returns: DataFrame or dict of …

Supports xls, xlsx, xlsm, xlsb, odf, ods and odt file extensions read from a local filesystem or URL. Supports an option to read a single sheet or a list of sheets.

>>> pd.read_excel('tmp.xlsx', dtype={'Name':str, 'Value':float}) Name Value 0 string1 1.0 1 string2 2.0 2 string3 3.0

Supports xls, xlsx, xlsm, xlsb, odf, ods and odt file extensions read from a local filesystem or URL. Supports an option to read a single sheet or a list of sheets.

To write a single object to an Excel .xlsx file it is only necessary to specify a target file name. To write to multiple sheets it is necessary to create an ExcelWriter object with a target file name, …

Here, the if_sheet_exists parameter can be set to replace a sheet if it already exists:

Class for parsing tabular Excel sheets into DataFrame objects. See read_excel for more documentation. Parameters: path_or_bufferstr, bytes, path object (pathlib.Path or …

pandas.read_excel ¶ pandas.read_excel(io, sheetname=0, header=0, skiprows=None, skip_footer=0, index_col=None, names=None, parse_cols=None, parse_dates=False, …