readmatrix for single Excel cells
22 views (last 30 days)
Show older comments
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 Comments
dpb
on 19 May 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...
Accepted Answer
dpb
on 26 Dec 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 Comments
ziyue zhong
on 1 Jun 2020
Then how to deal with that if I use write,and I wanna write a single value in a single cell
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!