Info
La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.
How to work on multiple excel sheets at the same time?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Jamie
el 25 de Oct. de 2013
Editada: Jamie
el 25 de Oct. de 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)
Respuestas (0)
La pregunta está cerrada.
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!