how work with Datastore from two or more file excel sheets

Question

Juan Carlos Pozuelos Buezo 2019-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/490520-how-work-with-datastore-from-two-or-more-file-excel-sheets

评论： Melody Lyu 2020-2-4

Hi.

I want to work with many Excel files, and I tried to work with the Data Store. The problem is that I need data from two excel sheets, with different amounts of columns, and that the ds file groups them into a single table. the fixed work of the leaves are the same, only the columns are different.

How should I write the Datastore code to read both sheets and create a single tall array for everything?

Thank you.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Melody Lyu 2020-2-4

Hi Juan,

which way did you end up using? I am having the same question too

请先登录，再进行评论。

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

Answer 1

Jalaj Gambhir 2019-11-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/490520-how-work-with-datastore-from-two-or-more-file-excel-sheets#answer_401661

在 MATLAB Online 中打开

Hi,

I don't think that is possible using Datastore, but one possible workaround could be:

path = 'Source';
files = dir(fullfile(path, '*.xlsx'));
result = table();         
filecontent = readtable(fullfile(path, files(1).name)); 
filecontent2 = readtable(fullfile(path, files(2).name)); 
vars1 = [filecontent.Properties.VariableNames]
vars2 = [filecontent2.Properties.VariableNames]
R = {[vars1 vars2]}
result = array2table([table2array(filecontent) table2array(filecontent2)],'VariableNames',R{:});