reading data from excel text not displayed
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
abdul rehman
am 19 Dez. 2021
Kommentiert: Siddharth Bhutiya
am 3 Jan. 2022
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 Kommentare
Akzeptierte Antwort
Voss
am 19 Dez. 2021
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 Kommentar
Siddharth Bhutiya
am 3 Jan. 2022
Avoid using xlsread. Instead use more modern functions like readtable or readmatrix. These are being continuously improved to make your life a lot easier.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!