search

esqLABS / shinyScenarioEditor

0 stars 0 forks source link

Specify data types for all excel files #8

Closed Felixmil closed 7 months ago

Felixmil commented 11 months ago

readxl function assumes that empty columns are logical with NA values. This makes {datamods} crash when editing value because logical cannot be NA. To solve this, all columns are read as characters.

However, for making the editing UI more convenient to the users, the data should be correctly typed.

Felixmil commented 11 months ago

Excel sheets could be read all as characters by default and datatype transformation could be applied afterward. This would require the app to know how to translate each column and thus force us to include hardcoded variable <-> type correspondence table.

How to store this ? in data_structure ?

@hannaei Any idea ?