how work with Datastore from two or more file excel sheets
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Juan Carlos Pozuelos Buezo
le 11 Nov 2019
Commenté : Melody Lyu
le 4 Fév 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 commentaire
Réponse acceptée
Jalaj Gambhir
le 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!
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!