read in excel spreadsheet

[aineniamh]

read the file in as an excel file- do some checking select the barcode,sample find the negative and positive check there aren't duplicates

qc

• strip off invisibles that excel will add in
• trim whitespace from start and end of every field
• if a field is in quotes,

write the file out to the temp folder make sure to write out all columns to this file (use csv.DictWriter and just write out the fieldnames of the DictReader when parsing the file?). ALso remember to handle line termination. Perhaps we can allow tsv or csv.

Prepopulated template be able to parse that format

[aineniamh]

populate the field first via this spreadsheet- if it's empty, or they want to edit it afterwards they can do that too