how work with Datastore from two or more file excel sheets
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Juan Carlos Pozuelos Buezo
am 11 Nov. 2019
Kommentiert: Melody Lyu
am 4 Feb. 2020
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 Kommentar
Melody Lyu
am 4 Feb. 2020
Hi Juan,
which way did you end up using? I am having the same question too
Akzeptierte Antwort
Jalaj Gambhir
am 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!
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!