how work with Datastore from two or more file excel sheets

4 views (last 30 days)
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 Comment
Melody Lyu
Melody Lyu on 4 Feb 2020
Hi Juan,
which way did you end up using? I am having the same question too

Sign in to comment.

Accepted Answer

Jalaj Gambhir
Jalaj Gambhir on 15 Nov 2019
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{:});
Hope this helps!
  1 Comment
Juan Carlos Pozuelos Buezo
Thanks i will try.
another solution that i did, is make two data store, and join them after to use gather.

Sign in to comment.

More Answers (0)

Tags

Products

Community Treasure Hunt

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

Start Hunting!

Translated by