1.read_excel用法：
read_excel(io, sheetname=0, header=0, skiprows=None, skip_footer=0, index_col=None,names=None, parse_cols=None, parse_dates=False,date_parser=None,na_values=None,thousands=None, convert_float=True, has_index_names=None, converters=None,dtype=None, true_values=None, false_values=None, engine=None, squeeze=False, **kwds)
io:excel文件地址
sheetname:string, int, mixed list of strings/ints, or None, default 0 返回多表使用sheetname=[0,1],若sheetname=None是返回全表 注意：int/string 返回的是dataframe崖疤，而none和list返回的是dict of dataframe
header: int, list of ints, default 0 指定列名行，默認(rèn)0劫哼，即取第一行叮趴，數(shù)據(jù)為列名行以下的數(shù)據(jù) 若數(shù)據(jù)不含列名，則設(shè)定 header = None
skiprows:省略指定行數(shù)的數(shù)據(jù)
skip_footer:int,默認(rèn)=0权烧，省略從尾數(shù)指定行數(shù)據(jù)
index_col:ints,list of ints,默認(rèn)為空眯亦，指定某一列為索引列咳蔚，也可以使用u"string"
names: array-like, default None, 指定列的名字。
2.to_excel用法：
to_excel(self, excel_writer, sheet_name='Sheet1', na_rep='', float_format=None,columns=None, header=True, index=True, index_label=None,startrow=0, startcol=0, engine=None, merge_cells=True, encoding=None,inf_rep='inf', verbose=True, freeze_panes=None)
excel_writer : string or ExcelWriter object File path or existing ExcelWriter目標(biāo)路徑
sheet_name : string, default ‘Sheet1’ Name of sheet which will contain DataFrame,填充excel的第幾頁
na_rep : string, default ”,Missing data representation 缺失值填充
float_format : string, default None Format string for floating point numbers
columns : sequence, optional搔驼，Columns to write 選擇輸出的的列。
header : boolean or list of string, default True Write out column names. If a list of string is given it is assumed to be aliases for the column names
index : boolean, default True侈询，是否導(dǎo)出索引舌涨，Write row names (index)
index_label : string or sequence, default None， Column label for index column(s) if desired. If None is given, andheader and index are True, then the index names are used. A sequence should be given if the DataFrame uses MultiIndex.
startrow :upper left cell row to dump data frame
startcol :upper left cell column to dump data frame
engine : string, default None 扔字，write engine to use - you can also set this via the options囊嘉，io.excel.xlsx.writer, io.excel.xls.writer, andio.excel.xlsm.writer.
merge_cells : boolean, default True Write MultiIndex and Hierarchical Rows as merged cells.
encoding: string, default None encoding of the resulting excel file. Only necessary for xlwt,other writers support unicode natively.
inf_rep : string, default ‘inf’ Representation for infinity (there is no native representation for infinity in Excel)
freeze_panes : tuple of integer (length 2), default None Specifies the one-based bottommost row
