How do i read an excel file with differnt sheets in an easy way?

I need to structure up some execl files containing 4 diffrent sheets and i wondet how I in the most effective way does this.

 채택된 답변

Walter Roberson
Walter Roberson 2016년 6월 2일

1 개 추천

xlsinfo can be used to find the name of the sheets or the number of sheets. After that you loop reading one sheet at a time.
Or if you already know the names of the sheets, just make four xlsread() calls passing in the appropriate sheet information.

추가 답변 (0개)

카테고리

질문:

2016년 6월 2일

댓글:

2016년 6월 2일

Community Treasure Hunt

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

Start Hunting!

Translated by