readmatrix for single Excel cells

5 次查看（过去 30 天）
Abdolkarim Mohammadi
评论： dpb 2020-6-1
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 个评论
Vit Krcal
Vit Krcal 2020-5-19
I have the same issue, have you found out any new solution or reasoning?
dpb
dpb 2020-5-19
It's a bug; the workarounds are simple enough, but never hurts to submit additional bug report to prod TMW along in fixing stuff...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2019-12-26
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 个评论
ziyue zhong
ziyue zhong 2020-6-1
Then how to deal with that if I use write,and I wanna write a single value in a single cell
dpb
dpb 2020-6-1
With what, specifically? If there's only one value, doesn't it work correctly?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by