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