How do i read an excel file with differnt sheets in an easy way?
1 view (last 30 days)
Show older comments
studentdavid
on 2 Jun 2016
Commented: studentdavid
on 2 Jun 2016
I need to structure up some execl files containing 4 diffrent sheets and i wondet how I in the most effective way does this.
0 Comments
Accepted Answer
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)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!