readmatrix for single Excel cells

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?

[Vit Krcal]

I have the same issue, have you found out any new solution or reasoning?

[dpb]

It's a bug; the workarounds are simple enough, but never hurts to submit additional bug report to prod TMW along in fixing stuff...

Answer 1

[dpb]

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:

1. Just follow above with MFOA=MFOA(1); to throw away everything but first element, or
2. Use venerable xlsread to read the single cell cases (I'd use 1. btw).

[ziyue zhong]

Then how to deal with that if I use write,and I wanna write a single value in a single cell

[dpb]

With what, specifically? If there's only one value, doesn't it work correctly?