readmatrix for single Excel cells
22 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Abdolkarim Mohammadi
el 26 de Dic. de 2019
Comentada: dpb
el 1 de Jun. de 2020
My data is stored on a single Excel file, where each sheet containts several numeric matrixes. I imported all the variables successfully to MATLAB using readmatrix. However, 1x1 matrices are imported incorrectly. I use the following syntax:
MFOA = readmatrix (Path, 'Sheet', Sheet, 'Range', 'H142:H142');
Instead of loading only the cell H142, readmatrix loads a column vector starting from H142 down to the last row of the rectangular portion of the spreadsheet. How can I get the correct results?
Respuesta aceptada
dpb
el 26 de Dic. de 2019
Don't have recent-enough version here to test to confirm, but if is so and reproducible on latest release, that would appear to be a bug. Report to TMW.
Workarounds:
- Just follow above with MFOA=MFOA(1); to throw away everything but first element, or
- Use venerable xlsread to read the single cell cases (I'd use 1. btw).
2 comentarios
ziyue zhong
el 1 de Jun. de 2020
Then how to deal with that if I use write,and I wanna write a single value in a single cell
dpb
el 1 de Jun. de 2020
With what, specifically? If there's only one value, doesn't it work correctly?
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!