xl module

WorkBook(file_name[, sheets, ts_prefix, …])	Excel WorkBook helper class
WorkBook.add_condition([worksheet, condition])	Add worksheet conditional format (rule)
WorkBook.add_format([worksheet, column_attr])	Add worksheet column format (rule)
WorkBook.add_sheet([dataframe, sheet_name, …])	Add DataFrame to WorkBook object
WorkBook.add_sql_sheet([sheet_name, sql])	Add worksheet containing SQL statement(s) used
WorkBook.close()	close (save) workbook
WorkBook.get_default_format(df)	For given dataframe, calculate default format.
WorkBook.get_metadata([meta_file])	Get XL metadata
WorkBook.get_range(sheet_name[, …])	Given worksheet & column reference, calculate excel sheet range.
WorkBook.get_styles([file_name])	Retrieve dictionary of styles allowing easy access to styles by name.
WorkBook.get_themes()	Get MS Excel standard themes
WorkBook.show_styles()	Show/List internal styles
WorkBook.show_themes()	Show/List themes

piper.custom.to_julian piper.xl.WorkBook