readmatrix for single Excel cells

18 Ansichten (letzte 30 Tage)
Abdolkarim Mohammadi
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
Vit Krcal
Vit Krcal am 19 Mai 2020
I have the same issue, have you found out any new solution or reasoning?
dpb
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...

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

dpb
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:
  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).
  2 Kommentare
ziyue zhong
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
dpb
dpb am 1 Jun. 2020
With what, specifically? If there's only one value, doesn't it work correctly?

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Produkte


Version

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by