reading data from excel text not displayed
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
abdul rehman
il 19 Dic 2021
Commentato: Siddharth Bhutiya
il 3 Gen 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 Commenti
Risposta accettata
Voss
il 19 Dic 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 Commento
Siddharth Bhutiya
il 3 Gen 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.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!