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

1 次查看（过去 30 天）

显示更早的评论

Gali Musa 2018-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399964-how-to-read-header-text-data-of-100000-rows-18-columns-from-data-in-excel-into-matlab-using-differ

评论： Walter Roberson 2018-5-13

采纳的回答： Fangjun Jiang

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

采纳的回答

Fangjun Jiang 2018-5-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/399964-how-to-read-header-text-data-of-100000-rows-18-columns-from-data-in-excel-into-matlab-using-differ#answer_319465

在 MATLAB Online 中打开

Not sure what do you mean by "using different directory", but did you try?

[Num, Txt, Raw]=xlsread('C:\MyDirectory\MyExcel.xls');

19 个评论
显示 17更早的评论隐藏 17更早的评论

Gali Musa 2018-5-13

Thank you so much for the useful information, however, xlsread() is faster

Walter Roberson 2018-5-13

在 MATLAB Online 中打开

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);