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