reading data from excel text not displayed
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
abdul rehman
el 19 de Dic. de 2021
Comentada: Siddharth Bhutiya
el 3 de En. de 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 comentarios
Respuesta aceptada
Voss
el 19 de Dic. de 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 comentario
Siddharth Bhutiya
el 3 de En. de 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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!