Package excel file version differs from package to package

iGEM-Engineering / iGEM-distribution

Repository for collective design of an iGEM DNA distribution

https://igem-distribution.readthedocs.io

Other

42 stars 20 forks source link

Package excel file version differs from package to package #205

Open nickdelkis opened 2 years ago

nickdelkis commented 2 years ago

I noticed that older packages, e.g. CRISPR-Cas, have a previous version of the excel file, where some features are missing (e.g. local sequence file option in Data Source Prefix).

All we'd need to do is copy and paste everything into a new excel file from package_template.xlsx or should there be a more automated way for this?

jakebeal commented 2 years ago

Right now, copy & paste is the right way to go.

I had an automated update mechanism, but automated update loses the data validations, due to Excel extensions not being supported in any python/Excel library currently (see: https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1745)