How to work with certain excel sheets?

2 ビュー (過去 30 日間)
Rodriguez Pham
Rodriguez Pham 2015 年 9 月 3 日
回答済み: David O'Brien 2015 年 9 月 3 日
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?

サインインしてこの質問に回答する。

回答 (1 件)

David O'Brien
David O'Brien 2015 年 9 月 3 日
Here you go. Specify which sheet by replacing sheet with the sheet name. Read the help doc for more info.
num = xlsread(filename,sheet)
Source: http://www.mathworks.com/help/matlab/ref/xlsread.html

カテゴリ

Help Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by