Reading data from Microsoft Excel

3 次查看（过去 30 天）
Kelechi Nwosu
Kelechi Nwosu 2024-8-19
编辑： Cris LaPierre 2024-9-6
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
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
Hi @Kelechi Nwosu,
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:
https://www.mathworks.com/help/matlab/ref/xlsread.html
https://www.mathworks.com/help/matlab/ref/readmatrix.html
  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
编辑：Cris LaPierre 2024-9-6
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!

Translated by