How to read out the strings from this Excel file?
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
KSSV
2020 年 12 月 3 日
Read the documentation, there are options to keep the data as it is unchanged while reading.
回答 (1 件)
Swetha Polemoni
2020 年 12 月 5 日
Hi Leon,
You can try using the following line of code.
[~,~,T] = xlsread ('test.xlsx');
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!