フィルターのクリア

Reading data from Microsoft Excel

17 ビュー (過去 30 日間)
Kelechi Nwosu
Kelechi Nwosu 2024 年 8 月 19 日
編集済み: Cris LaPierre 2024 年 9 月 6 日 17:46
What is the syntax for reading data from Microsoft Excel sheets? I tried the following and it returned error messages.
A = xlsread('amat.xlsx','sheet1','a1:a10')
I even changed the case of S in sheet to capital and the error persisted. Anyone with an idea?
  2 件のコメント
Cris LaPierre
Cris LaPierre 2024 年 8 月 19 日
What is the full error message? Please share all the red text.
Walter Roberson
Walter Roberson 2024 年 9 月 5 日 20:45
What shows up if you use
[status, sheets] = xlsinfo('amat.xlsx')

サインインしてコメントする。

採用された回答

Cris LaPierre
Cris LaPierre 2024 年 8 月 19 日
編集済み: Cris LaPierre 2024 年 8 月 20 日
Note that xlsread is not recommended. Assuming you are just importing a matrix of numbers, I would use readmatrix.
A = readmatrix('amat.xlsx','Sheet','sheet1','Range','a1:a10')

その他の回答 (1 件)

Jatin
Jatin 2024 年 8 月 20 日
There can be few reasons for getting errors while using the “xlsread” function.
Kindly follow these troubleshooting steps to make sure the function work correctly:
  1. Make sure the file is in the current directory or provide the full path to the file.
  2. Use the correct worksheet name and check for spelling and case sensitivity.
  3. Ensure that the range is specified properly, incorrect range may throw errors.
From R2019a, “xlsread” is not recommended as stated in the official documentation. You can switch to using “readtable”,readmatrix” and “readcell instead.
You can refer to the following MathWorks documentations for more information:
  2 件のコメント
Kelechi Nwosu
Kelechi Nwosu 2024 年 8 月 30 日
Thanks a lot. I did all the suggested and still I was getting errors. I guess I shall have to switch to readmatrix as it is the function that gives the same set of results as xlsread.
Cris LaPierre
Cris LaPierre 2024 年 9 月 5 日 19:52
編集済み: Cris LaPierre 2024 年 9 月 6 日 17:46
Consider attaching your file to your post using the paperclip icon. Please share the full error message (all the red text)

サインインしてコメントする。

カテゴリ

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