MATLAB Answers

How to read out the strings from this Excel file?

26 views (last 30 days)
Leon
Leon on 3 Dec 2020
Answered: Swetha Polemoni on 5 Dec 2020
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');

  0 Comments

Sign in to comment.

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!