Importing rows with empty cels from EXCEL
显示 更早的评论
Dear all, I am trying to export rows with empty cells in several first elements. For instance a row in excel is [ _ _ 4 5 6]; first 2 cells being empty, Matlab reads this a=[4 5 6], it does not insert NaN's, and makes size 3, instead of 5. Is there a way to fix this?
Best regards, Can Sever University of Maryland
回答（1 个）
dpb
2016-5-9
With xlsread alone the only way is to specify the range and return the raw data cell array. There may be a way with the COM/DDE/ActiveX but that's more of an Excel question than Matlab as far as communication protocols/methods.
Example; made a one-row spreadsheet as you described--
>> [x,t,r]=xlsread('book1.xls','A1:E3')
x =
1 2 3
t =
{}
r =
[NaN] [NaN] [ 1] [ 2] [ 3]
[NaN] [NaN] [NaN] [NaN] [NaN]
[NaN] [NaN] [NaN] [NaN] [NaN]
>>
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
