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 ExchangeSpreadsheets についてさらに検索

製品


リリース

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by