reading data from excel text not displayed

4 次查看（过去 30 天）
abdul rehman
abdul rehman 2021-12-19
评论： Siddharth Bhutiya 2022-1-3
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)

请先登录，再回答此问题。

采纳的回答

Voss
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
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 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by