Select wanted range xlsread

2 次查看（过去 30 天）

Christophe 2011-9-14

Hello,

Using xlsread(filename,-1), I am able to select and get the data of an excel file.

Is there a way to get the sheet name and the data range where I took the data ? I am using MATLAB 2007b.

Thank you very much in advance

Jan 2011-9-14

Please read "doc xlsread" for your MATLAB version. In 2009a you'd find this:

 6. Get data from a specified region in a named sheet:
    NUMERIC = xlsread('c:\matlab\work\myspreadsheet','NBData','a2:j5')

Christophe 2011-9-14

Yes I know how to get the data.

I want to know how to get the data range and sheet name, when using the -1 parameter which opens an interactive Excel window for selecting data.

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by