readmatrix for single Excel cells

22 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by