reading data from excel text not displayed
4 ビュー (過去 30 日間)
古いコメントを表示
I want to read everything only but following code is showing 3 tables: number, text and everything. If i use only xlsread it does not read the text column. please tell me a way to read colplete excel sheet without skipping text.
filename = ' final.xlsx';
[numbers, TEXT, everything] = xlsread(filename,1)
0 件のコメント
採用された回答
Voss
2021 年 12 月 19 日
I believe that the variable 'everything' should have everything.
If you don't need the numeric-only and text-only outputs from xlsread, you can avoid storing them in variables, like this:
[~,~,everything] = xlsread(filename,1)
1 件のコメント
Siddharth Bhutiya
2022 年 1 月 3 日
Avoid using xlsread. Instead use more modern functions like readtable or readmatrix. These are being continuously improved to make your life a lot easier.
その他の回答 (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!