Same dimension for num and txt in xlsread

Question

Christian 2015-12-11

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/259908-same-dimension-for-num-and-txt-in-xlsread

回答： Walter Roberson 2015-12-12

Hi,

when I read in an excel file using xlsread, I'd like to have the outputs 'num' and 'txt' to have the same dimensions. It seems to me that by default, they chop off parts on the fringe that either don't contain numerics or text. It's convenient to have the same dimensions for reference purposes. For example, txt(1,2) should give me cell B1, and num(1,2) should also give me cell B1 in the original excel file.

Thanks, Christian

2 个评论
显示无隐藏无

Kirby Fears 2015-12-11

编辑：Kirby Fears 2015-12-11

在 MATLAB Online 中打开

Have you tried using the raw output of xlsread (output argument 3)? You can extract numerical and text data all from one object if you already know where (cell ranges) to find it.

[num,text,raw] = xlsread('myfile.xlsx');

Christian 2015-12-12

在 MATLAB Online 中打开

Thank you. This works, but I have a very hard time working with 'raw'. The first column of 'raw' looks like this:

NaN
'Identifier'
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
1

and so on. It seems to be a cell. Now, I would like to find the row that has the number 1. That seems to be very tricky to do, not only because other cells might have the number 11 or so, and I only want the cell that has the number 1 and nothing else in there.

请先登录，再进行评论。

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