Excel App
The excel application models the data import from Template files
excel.helpers
excel.helpers module contents
Created on Fri Jul 5 16:30:14 2019
@author: Paolo Cozzi <cozzi@ibba.cnr.it>
-
exception
excel.helpers.ExcelImportError[source]
Bases: Exception
-
class
excel.helpers.ExcelTemplateReader[source]
Bases: uid.helpers.FileDataSourceMixin
A class to read template excel files
-
__init__()[source]
Initialize self. See help(type(self)) for accurate signature.
-
check_accuracies()[source]
Check accuracy specified in table
-
check_columns()[source]
Test for minimal column required for template load
-
check_countries()[source]
Check that all efabis countries are present in database
-
check_sex()[source]
Check that all sex records are present in database
-
check_sheets()[source]
Test for the minimal sheets required to upload data
-
check_species(country)[source]
Check if all species are defined in UID DictSpecies. If not,
create dictionary term
-
check_species_in_animal_sheet()[source]
Check if all animal species are defined in breed sheet
-
get_animal_from_sample(sample)[source]
get an animal record from a sample record
-
get_animal_records()[source]
Iterate among animal records
-
get_breed_from_animal(record)[source]
Get a breed record from an animal record
-
get_breed_records()[source]
Iterate among breeds record
-
get_sample_records()[source]
Iterate among sample records
-
get_sheet_records(sheet_name)[source]
Generic functions to iterate on excel records
-
read_file(filename)[source]
-
excel.helpers.upload_template(submission_obj)[source]