title: Python - save different sheets of an excel file as individual excel files
body: <p>Newbie : I have an Excel file, which has more than 100 different Sheets. Each sheet contains several tables and charts.</p>
  
  <p>I wish to save every sheet as a new Excel file. </p>
  
  <p>I tried many python codes, but none of them worked.</p>
  
  <p>Kindly help in this. Thanks!</p>
  
  <p>Edit 1 : In reponse to comments, this is what I tried:</p>
  
  <pre><code>import pandas as pd
  import xlrd
  
  inputFile = 'D:\Excel\Complete_data.xlsx'
  
  #getting sheet names
  xls = xlrd.open_workbook(inputFile, on_demand=True)
  sheet_names = xls.sheet_names()
  
  path = "D:/Excel/All Files/"
  
  #create a new excel file for every sheet
  for name in sheet_names:
          parsing = pd.ExcelFile(inputFile).parse(sheetname = name)
  
          #writing data to the new excel file
          parsing.to_excel(path+str(name)+".xlsx", index=False)
  </code></pre>
  
  <p>To be precise, the problem is coming in copying tables and charts.</p>