Reading data from Microsoft Excel
17 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Walter Roberson
2024 年 9 月 5 日 20:45
What shows up if you use
[status, sheets] = xlsinfo('amat.xlsx')
採用された回答
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')
0 件のコメント
その他の回答 (1 件)
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:
- Make sure the file is in the current directory or provide the full path to the file.
- Use the correct worksheet name and check for spelling and case sensitivity.
- 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 件のコメント
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 Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!