macpie.Dataset.to_excel

Dataset.to_excel(excel_writer, sheet_name=None, na_rep='', float_format=None, columns=None, header=True, index=False, index_label=None, startrow=0, startcol=0, engine=None, inf_rep='inf', merge_cells=True, freeze_panes=None, storage_options=None, write_excel_dict=True, highlight_duplicates=True, **kwargs) → None

Write Dataset to an Excel sheet.

This is the analog of pandas.DataFrame.to_excel(), so read the documentation for that method for descriptions of available parameters, notes, and examples.

Parameters:

write_excel_dictbool, default True

Whether to write a representation of the Dataset to the Excel file. This is needed if you intend to read the file back into a Dataset object

highlight_duplicatesbool, default True

Whether to highlight any duplicate rows. Only applies to Datasets with a _mp_duplicates column where the row value is True.

**kwargs

All remaining keyword arguments are passed through to the underlying pandas.DataFrame.to_excel() method.

See also

MACPieExcelWriter

Class for writing Dataset objects into Excel sheets.

read_excel

Read an Excel file into a macpie Dataset.

pandas.DataFrame.to_excel

Pandas analog