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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by