Importing rows with empty cels from EXCEL

2 次查看（过去 30 天）
Can Sever
Can Sever 2016-5-9
回答： dpb 2016-5-9
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 个评论
Can Sever
Can Sever 2016-5-9
Since I have thousans of column with unbalanced data, this is a big problem for me. Thanks in advance!

请先登录，再进行评论。

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

回答（1 个）

dpb
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]
>>

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by