How to read out the strings from this Excel file?

3 次查看（过去 30 天）

Leon 2020-12-3

回答： Swetha Polemoni 2020-12-5

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 2020-12-3

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

Swetha Polemoni 2020-12-5

Hi Leon,

You can try using the following line of code.

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

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

R2020b

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by