How to read header (text data of 100000 rows,18 columns) from data in excel into Matlab using different directory

1 次查看（过去 30 天）
Gali Musa
Gali Musa 2018-5-9
评论： Walter Roberson 2018-5-13
How to read header (text data of 100000 rows,18 columns) from data in excel into Matlab using different directory

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2018-5-9
Not sure what do you mean by "using different directory", but did you try?
[Num, Txt, Raw]=xlsread('C:\MyDirectory\MyExcel.xls');
  19 个评论
显示 17更早的评论
Walter Roberson
Walter Roberson 2018-5-13
The magic way to force xlsread() to return a number for excel dates is to use 'basic' mode. If that is too slow for you, then fix your code so that it no longer expects to date to be a column in what is returned from the num output of xlsread.
For example you could change your code to use the raw output of xlsread(), so that you have all of the row numbering that you expect. Sample code:
[~, ~, raw] = xlsread('Test1.xlsx');
raw(1,:) = []; %remove header
if ischar(raw{1,1}) %dates are string
dates = datenum(raw(:,1));
raw(1,:) = num2cell(dates);
end
num = cell2mat(raw);

请先登录，再进行评论。

更多回答（0 个）

类别

在 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