pandas分别写入excel的不同sheet方法

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

class ExcelFile( ):
  \"\"\"
  Class for parsing tabular excel sheets into Data   s.
  Uses xlrd. See read_excel for more documentation
  Parameters
  ----------
  io : string, path   (pathlib.Path or py._path.local.LocalPath),
    file-like   or xlrd workbook
    If a string or path  , 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
  \"\"\"