readmatrix for single Excel cells
22 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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?
2 commentaires
dpb
le 19 Mai 2020
It's a bug; the workarounds are simple enough, but never hurts to submit additional bug report to prod TMW along in fixing stuff...
Réponse acceptée
dpb
le 26 Déc 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 commentaires
ziyue zhong
le 1 Juin 2020
Then how to deal with that if I use write,and I wanna write a single value in a single cell
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!