readmatrix for single Excel cells
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Abdolkarim Mohammadi
am 26 Dez. 2019
Kommentiert: dpb
am 1 Jun. 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?
2 Kommentare
dpb
am 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...
Akzeptierte Antwort
dpb
am 26 Dez. 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 Kommentare
ziyue zhong
am 1 Jun. 2020
Then how to deal with that if I use write,and I wanna write a single value in a single cell
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!