I am currently trying to import an excel file in Matlab via readtable.
The excel file I am working with has the following struncture:
As the data is not the same along the cells readtable correclty builds a table in the worksapce with the correct variable name (Col1) but the values are all read as strings, resulting in something like this:
As I would like to handle only the numbers (and thus it is ok for me to discard the text such as n.d) how can I specify readtable to read everything as double resulting in a table in the workspace as follows?
Of course a solution could be to use varfun and cast all the data, but is it possbile perform this task by using just readtable?