이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

How to work on multiple excel sheets at the same time?

조회 수: 1 (최근 30일)
avantika . 2013년 10월 25일
마감: MATLAB Answer Bot . 2021년 8월 20일
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
Jamie 2013년 10월 25일
편집: Jamie 님. 2013년 10월 25일
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!
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)

답변 (0개)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by