Hello, so i have 4 XLS files that contain data and every files has the same information but at different locations within that specific file. I want to extract all needed data
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
so all the files start like this: "HAYT" and at the end of HAYT, it contains one number(1-4) so the filenames range from HAYT1-HAYT4. I want all the files to be in one specfic folder where the code would sort through all four files and extract the data needed. how would i go about this? I am currently trying to code it but I am stuggling a bit.
12 commentaires
dpb
le 28 Juin 2021
You can put artificial data (of the same time data types and locations) in a sample file or two that illustrate the format and what data are needed.
It might be that just calling detectImportOptions for each could automagically find where the data are, or you might discover that the internal logic already built into readtable does it without any human intervention.
Have you tried it or just presumed it wouldn't work...?
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!