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 views (last 30 days)
Show older comments
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 Comments
dpb
on 28 Jun 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...?
Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!