How to convert my xlsread function to readmatrix function

1 visualización (últimos 30 días)
Hong Wei Tang
Hong Wei Tang el 22 de Jun. de 2021
Comentada: Cris LaPierre el 22 de Jun. de 2021
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 comentarios
Scott MacKenzie
Scott MacKenzie el 22 de Jun. de 2021
This
A = readmatrix("Weather.xlsx", "sheet", "WeatherData", "Range", "B2");
looks fine. What's the exact and complete error you are seeing?
Cris LaPierre
Cris LaPierre el 22 de Jun. de 2021
What type of data does Column B contain?

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Get Started with MATLAB en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by