How to convert my xlsread function to readmatrix function

2 次查看（过去 30 天）

显示更早的评论

Hong Wei Tang 2021-6-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/862175-how-to-convert-my-xlsread-function-to-readmatrix-function

评论： Cris LaPierre 2021-6-22

Greetings,

I have a question about the input from Excel to MATLAB.

Here is my original code:

A = xlsread("Weather.xlsx", "WeatherData", "B2");

This function can actually help me to input a single cell value from Excel. However, I discovered that readmatrix was encouraged to be used, so that I plan to switch to it.

I amended the new code afterwards. Here is it:

A = readmatrix("Weather.xlsx", "sheet", "WeatherData", "Range", "B2");

but it displayed error in the end.

Therefore, I tried again to amende the code to be:

A = readmatrix("Weather.xlsx", "sheet", "WeatherData", "Range", "B2:B2");

But it takes me extremely long time to load. And I decided to stop it in the end.

I am here to ask that is the last coding correct? Otherwise do we have any function to express the same input?

Thanks. Have a great day!

2 个评论
显示无隐藏无

Scott MacKenzie 2021-6-22

在 MATLAB Online 中打开

This

A = readmatrix("Weather.xlsx", "sheet", "WeatherData", "Range", "B2");

looks fine. What's the exact and complete error you are seeing?

Cris LaPierre 2021-6-22

What type of data does Column B contain?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Get Started with MATLAB

在 Help Center 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息

产品

MATLAB

版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by