How to read out the strings from this Excel file?

Attached is the Excel file.

Here is the code I use to read values out of the Excel file:

T1 = readtable ('test.xlsx');  

Unfortunately, the strings are now stored as NaN in the variable T1.

I have many such files. Sometimes, this column could be all numerical, sometimes, all strings, and sometimes a mix.

Thanks.

[KSSV]

Read the documentation, there are options to keep the data as it is unchanged while reading.

Answer 1

[Swetha Polemoni]

Hi Leon,

You can try using the following line of code.

[~,~,T] = xlsread ('test.xlsx');