0

<code>** excel sheet into an excel file **</code>**Could you help me, I one Excel file with multiple excel sheets. try to create each excel sheet into an excel file. I did try multiple ways but it didn't work **

Sajan
  • 1,247
  • 1
  • 5
  • 13
chaitanya
  • 39
  • 6
  • 1
    For each of the sheet, apply ```read_excel```, as shown here https://stackoverflow.com/questions/26521266/using-pandas-to-pd-read-excel-for-multiple-worksheets-of-the-same-workbook – sushanth May 26 '20 at 12:14
  • `dfs = {sheet : pd.read_excel(file,sheet_name=sheet) for sheet in file.sheet_names}` will create a dictionary of pandas dataframes with the sheet as the dictionary key. – Umar.H May 26 '20 at 12:17

0 Answers0