Same dimension for num and txt in xlsread
2 次查看(过去 30 天)
显示 更早的评论
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
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');
回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!