pandas.Panel.to_excel¶
- Panel.to_excel(path, na_rep='', engine=None, **kwargs)¶
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, and io.excel.xlsm.writer.
Notes
Keyword arguments (and na_rep) are passed to the to_excel method for each DataFrame written.