Reading execel file with string.(giving NaN for data values like 10kA)

1 view (last 30 days)
I want to read a excel file in matlab.
my file is:
1ms 1kA 10V
2ms 2.2kA 3V
3ms 3.6kA 5.4V
using xls read it is giving
NaN NaN NaN
NaN NaN NaN
NaN NaN NaN
When I remove 'ms', 'kA' & 'V' fromthe excel. then xls can only read. How to solve this problem? How MATLAB can read it as a string?

Accepted Answer

KSSV
KSSV on 30 Jan 2019
[num,txt,raw] = xlsread(youfile);
OR
T = readtable(yourfile) ;
  1 Comment
Gagan Bansal
Gagan Bansal on 30 Jan 2019
Thanks for the answer.
I also want to remove the 'ms', 'kA' & 'V' from the matrix. Consider order or the matrix from the question.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!