-
Panel.to_excel(path, na_rep='', engine=None, **kwargs)[source] -
Write each DataFrame in Panel to a separate excel sheet
Parameters: path : string or ExcelWriter object
File path or existing ExcelWriter
na_rep : string, default ??
Missing data representation
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.Other Parameters: float_format : string, default None
Format string for floating point numbers
cols : 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
Write row names (index)
index_label : string or sequence, default None
Column label for index column(s) if desired. If None is given, and
headerandindexare 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
Notes
Keyword arguments (and na_rep) are passed to the
to_excelmethod for each DataFrame written.
Panel.to_excel()
2017-01-12 04:51:35
Please login to continue.