Select wanted range xlsread

2 Ansichten (letzte 30 Tage)
Christophe
Christophe am 14 Sep. 2011
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

Antworten (1)

Jan
Jan am 14 Sep. 2011
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')
  1 Kommentar
Christophe
Christophe am 14 Sep. 2011
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.

Melden Sie sich an, um zu kommentieren.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by