Info
This question is closed. Reopen it to edit or answer.
How to work on multiple excel sheets at the same time?
3 views (last 30 days)
Show older comments
Hi!
I have a folder containing multiple excel sheets . I want to do same following things on each sheet:
1. Add the sheet number (for e.g. 2, 3 , 4 etc..) as participation id in the sheet in separate column.
2. sort the sheets according to rows.
I have a very basic question i.e. how to work on multiple sheets at the same time?
1 Comment
Jamie
on 25 Oct 2013
Edited: Jamie
on 25 Oct 2013
Hi avantika, any reason your doing it in matlab? As you mention you've already got the data in excel I would have thought that was an excel specialty..
In matlab I would take a look at the import data tool. Its excellent. It even generates script/functions for you!
Alternatively
help xlsread
Once its all in a .mat file/s sorting the data should be a very simple task (depending exactly what your sort criteria is)
Answers (0)
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!