For loop to run code multiple times for different excel sheets
4 views (last 30 days)
Show older comments
I have a code that I wrote for one excel sheet and I need it to run for 5 more excel sheets how can I do this using a for loop?
2 Comments
Geoff Hayes
on 11 May 2020
Fatemah - what does your code look like for the one sheet? Are you just changing the sheet name on each iteration? What should be done with the data that you read?
Answers (1)
Harsha Priya Daggubati
on 14 May 2020
Hi,
If your excel workbook has multiple sheets, then this thread might help you give an idea about how to proceed.
If your data is spread across multiple excel files, then you can get access the excel files using 'dir' command. This thread might help you.
0 Comments
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!