reading data from excel text not displayed

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)

 Respuesta aceptada

Voss
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

Avoid using xlsread. Instead use more modern functions like readtable or readmatrix. These are being continuously improved to make your life a lot easier.

Iniciar sesión para comentar.

Más respuestas (0)

Productos

Versión

R2021b

Preguntada:

el 19 de Dic. de 2021

Comentada:

el 3 de En. de 2022

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by