Given is an Excel spreadsheet which has some columns that contain both numeric and string values. When using function 'readtable', then by default the rows that contain the string values are ignored and only the rows that contain the numeric values for the particular column are imported.
When using function 'setvartype' to specify the type of the variables in a column as string, then all the numeric values are ignored instead, which is undesirable. It is desirable to have all the values including the numeric values imported as text.
Why does function 'readtable' ignore string values on cells that appears in the same column as numeric values?