How to convert my xlsread function to readmatrix function

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!

[Scott MacKenzie]

This

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

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

[Cris LaPierre]

What type of data does Column B contain?