5 ms·
I’m a huge fan of spreadsheets as config files due to their ability to compute values from formulae. I currently do this in F# using ExcelProvider, which allow
by jlturner 6y ago
I’m a huge fan of spreadsheets as config files due to their ability to compute values from formulae.
I currently do this in F# using ExcelProvider, which allows you to access computed values and types at design/compile time.
This is much handier than using json/yaml/xml etc., again due to formulae, but also the use of Excel/LibreOffice as a config editor. Additionally being able to have multiple spreadsheets within a workbook is a nice way of organizing your configuration data. Beats the pants off other serialized data formats (depending on your use case) and I find it to be preferable to using ‘code as configuration’, especially because non-developer users can edit it.
EDIT: Link to ExcelProvider http://fsprojects.github.io/ExcelProvider/ http://fsprojects.github.io/ExcelProvider/