Help ! Excel import to Matlab

how i suppose to do, if want to a value range, this works only if you know the cells (xlRange) for example i have a excel file : 01.01.1994 5000 02.01.1994 6000 - - - - - 01.01.1996 -

i want now from 01.01.1994 to 31.10.1994 values, so that i give to matlab a range 01.01.1994-31.10.1994 (not cell range)and it gives me the values from the second sheet on time 01.01.1994-31.10.1994. How i do that?

Answer 1

[dpb]

That's an Excel question (or at least approach to the question) rather than Matlab. You'd have to use a lookup function in Excel and have it return the range in question; then read that range. Undoubtedly doable, but the hard way to go at it...

In Matlab, just read the data and then select that which you want from it; don't worry about only retrieving bits 'n pieces...