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

1 view (last 30 days)
I need to structure up some execl files containing 4 diffrent sheets and i wondet how I in the most effective way does this.

Accepted Answer

Walter Roberson
Walter Roberson on 2 Jun 2016
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.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!