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

2 次查看（过去 30 天）

Gagan Bansal 2019-1-30

评论： Gagan Bansal 2019-1-30

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

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?

KSSV 2019-1-30

[num,txt,raw] = xlsread(youfile);

T = readtable(yourfile) ;

Gagan Bansal 2019-1-30

Thanks for the answer.

I also want to remove the 'ms', 'kA' & 'V' from the matrix. Consider order or the matrix from the question.

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

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

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

Translated by