|
|
Re: How to Select Entire Row From Excel File Uisng Prompt?
Posted:
Nov 19, 2012 10:11 PM
|
|
Sorry to bother you, but I think there is something wrong with your function. At first I thought it may have something to do with the dates. I tried integers and text; nothing worked.
requireDateNumber = 'C';
data = xlsread('C:\Program Files\MATLAB\R2012a\StockSymbols.xls');
rowIndex = (data(:,1) == requiredDateNumber);
if any(rowIndex)
rowData = data(rowIndex,2:end);
else
error('There is no corresponding row.');
end
Here is the error:
Error in Read_Specific_Row (line 34)
rowIndex = (data(:,1) == requiredDateNumber);
'requireDateNumber' must be just a variable. It doesn't have to be a date, or numeric, or anything specific, right.
"Phil Goddard" <phil@goddardconsulting.ca> wrote in message <k8ecid$eop$1@newscl01ah.mathworks.com>...
> You need to do error checking, and I am assuming your file is as per one of your previous posts whether the first column is read in as integer numbers (which can be interpreted as dates):
>
> requireDateNumber = %whatever your user enters
>
> data = xlsread('myfile.xls');
> rowIndex = (data(:,1) == requiredDateNumber);
>
> if any(rowIndex)
> rowData = data(rowIndex,2:end);
> else
> error('There is no corresponding row.');
> end
>
> Phil.
|
|
