0

Below is the line of code

Df= pandas.read_excel('sample.xlsx', sheet_name='mysheet')

It starts reading from sheet1. Any help in this regard, please.

Trenton McKinney
  • 56,955
  • 33
  • 144
  • 158
Kanchan Kauthale
  • 1
  • 5
    Does this answer your question? [Using Pandas to pd.read\_excel() for multiple worksheets of the same workbook](https://stackoverflow.com/questions/26521266/using-pandas-to-pd-read-excel-for-multiple-worksheets-of-the-same-workbook) & [Pandas read_excel() with multiple sheets and specific columns](https://stackoverflow.com/questions/41128526/pandas-read-excel-with-multiple-sheets-and-specific-columns) – Trenton McKinney Jun 17 '20 at 17:18
  • Tried that way. But still it is reading first tab. – Kanchan Kauthale Jun 17 '20 at 17:34
  • That's the only way. Make certain you have the correct tab name. Can you share the file? – Trenton McKinney Jun 17 '20 at 18:27
  • My version of pandas is-0.20.1. they have sheetname param there. For later versions they have sheet_name – Kanchan Kauthale Jun 18 '20 at 04:51
  • That’s pretty old, can’t you update pandas? – Trenton McKinney Jun 18 '20 at 05:11

0 Answers0