How to read out the strings from this Excel file?

2 views (last 30 days)
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.
  1 Comment
KSSV
KSSV on 3 Dec 2020
Read the documentation, there are options to keep the data as it is unchanged while reading.

Sign in to comment.

Answers (1)

Swetha Polemoni
Swetha Polemoni on 5 Dec 2020
Hi Leon,
You can try using the following line of code.
[~,~,T] = xlsread ('test.xlsx');

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!