How to work with certain excel sheets?
3 views (last 30 days)
Show older comments
So I have an excel file with over 20 excel sheets, is there a way I can use matlab to target a certain sheet so that there wont be a difficult syntax to code.
For example I have a file with sheets labeled 1 - 20, and I want to read in sheet4, how would I use xlsread to readin in sheet4 and not sheet1?
0 Comments
Answers (1)
David O'Brien
on 3 Sep 2015
Here you go. Specify which sheet by replacing sheet with the sheet name. Read the help doc for more info.
num = xlsread(filename,sheet)
0 Comments
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!