xlsread is not reading the complete excel table when used in 2009b

1 回表示 (過去 30 日間)
jenny
jenny 2023 年 6 月 30 日
回答済み: Cris LaPierre 2023 年 6 月 30 日
Hello,
Im tried using the readtable in 2009b but it is not compatible. So, used xlsread as below
data = xlsread('TestList.xlsx','C4:AR22');
but it is only reading the last row.
can someome please provide suggestions
thank you

採用された回答

Cris LaPierre
Cris LaPierre 2023 年 6 月 30 日
The syntax you are using only returns numeric data. My first guess, then, is that your spreadsheet only contains numeric data in the last row.
You can test this by calling xlsread with three outputs:
Inspect the raw variable and see if it has the data you are expecting.
If not, please attach your spreadsheet to your post using the paperclip icon.

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by