How to Import excel document with alot of sheets that does not ignore date in first column

5 次查看（过去 30 天）
Kristian Opsahl
Kristian Opsahl 2018-9-12
评论： Kristian Opsahl 2018-9-12
Hi,
I need to import an excel doc that has a lot sheets (individual stocks on each sheet).
I manage to import with the code underneath, but it skips column A on every sheet that is the date. The date are formatted in excel as this : 1/3/2017 etc. If I manually change them to be numbers in excel it works, but that takes too much time in the long-run so I want that MATLAB solves that for me. Any suggestions/help?
[~,sheet_name] = xlsfinfo('filename.xlsx');
for k= 1:numel(sheet_name)
data{k} = xlsread('filename.xlsx', sheet_name{k});
end

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2018-9-12
fn = 'Path_to_your_file\MachineLearning.xlsx';
[~,sheet_name] = xlsfinfo(fn);
sheet_name = strrep(sheet_name,' ','_');
S = struct();
for ii = 1:numel(sheet_name)
[d,t] = xlsread(fn,ii);
if ii == 1
vn = t(5,2:end);
vn{13} = strrep(vn{13},'%','PR');
end
t(6,1) = t(1,2);
RTime = datetime(t(6:end,1),'f','dd.MM.uuuu');
S.(sheet_name{ii}) = array2timetable(d,'Rowtimes',RTime,'v',vn);
end

更多回答（1 个）

KSSV
KSSV 2018-9-12
I suggest you to use readtable.
With xlsread:
[num,txt,raw] = xlsread(myfile) ;

类别

在 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