import pandas as pd writer = pd.ExcelFile('your_path.xlsx') df1 = pd.DataFrame()df2 = pd.DataFrame() df1.to_excel(writer, sheet_name='df_1')df2.to_excel(writer, sheet_name='df_2') writer.save()

class ExcelFile(object):  """  Class for parsing tabular excel sheets into DataFrame objects.  Uses xlrd. See read_excel for more documentation  Parameters  ----------  io : string, path object (pathlib.Path or py._path.local.LocalPath),    file-like object or xlrd workbook    If a string or path object, expected to be a path to xls or xlsx file  engine: string, default None    If io is not a buffer or path, this must be set to identify io.    Acceptable values are None or xlrd  """