Extract data from specific cells across multiple Excel sheets
14 views (last 30 days)
Show older comments
Hi, I have a xlsx file and am looking to extract data from multiple specific cells across multiple spreadsheets in order to then run some stats on it.
What I want to do:
- Read the same specific cells containing numetrical data across multiple sheets (i.e A1,B1,C1 in sheet 1, A1,B1,C1 in sheet 2)
- Assign this data to a new variable (i.e all A1 cells = var1, all B1 cells = B2 etc.)
- Each line of the array to be assigned an ID
- Export this to a new excel spreadsheet
There are also some specific text cells where that ideally I would like to read in text also, but this isn't essential.
If anyone could assist in helping with this I would be really grateful
Thanks
0 Comments
Answers (1)
See Also
Categories
Find more on Spreadsheets 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!