tally.build.Sheet

class tally.build.Sheet(banner='@', default_dataset=None, name=None, parent=None)

Represents a sheet in an Excel document.

Parameters

• name (string) – Name for the sheet. Will appear in table of contents.

• banner (list) – Variables to display across the top of the sheet.

• default_dataset (tally.DataSet) – The dataset to use for the data. The default is the build dataset, but sheets can have data from other datasets.

• parent (tally.Build) – The build object that owns the sheet.

__init__(banner='@', default_dataset=None, name=None, parent=None)

Methods

__init__([banner, default_dataset, name, parent])
add_banner_border(df)
add_table(stub[, options, dataset])	Add a table to the sheet
apply_base_options(df, option)
apply_table_format_options(df, options)
apply_table_options(df, options)
build_dataframes([build_options])
get_name()
paint_dataframes()
set_format_for_type(df, type, format)	Method to add/alter format json per cell or per question type.
set_row_format(df, format)
show([table])	Return the dataframe or dataframes for a given sheet.
table_count()