atomica.excel

Miscellaneous utility functions for Excel files

This module implements utility functions for Excel functionality that is common to different kinds of spreadsheets used in Atomica (e.g. Databooks and Program Books). For example, Excel formatting, and time-varying data entry tables, are implemented here.

Functions

apply_widths	Set column widths
cell_get_number	Return numeric value from cell
cell_get_string	Return string value from cell
copy_sheet	Copy a sheet into a Workbook
read_dataframes	Read dataframes from sheet
read_tables	Read tables from sheet
standard_formats	Add standard formatting to a workbook
transfer_comments	Copy comments between spreadsheets
update_widths	Keep track of required width for a column
validate_category	Check Atomica workbook type

Classes

TimeDependentConnections	Structure for reading/writing interactions
TimeDependentValuesEntry	Table for time-dependent data entry