<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
----- Message d'origine ----- <br>
De : Sean Cooper <br>
Date : 21/01/2010 21:45:
<blockquote cite="mid:595840.49324.qm@web37007.mail.mud.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div
style="font-family: verdana,helvetica,sans-serif; font-size: 12pt;">
<div><font face="Times New Roman">.../...</font>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">But when I execute the following in the text
editor</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><o:p><font
face="Times New Roman"> </font></o:p></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">clear;</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">sheets=readxls('C:\Program
Files\scilab-5.2.0\myscilab\IGE.xls')</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">s1=sheets(1)</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">tday=s1(:,1)</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">cls=s1(:,$)</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">mydata=[tday,cls]</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><o:p><font
face="Times New Roman"> </font></o:p></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">I get “mydata=[tday,cls]<span style=""> </span>!—error
144<span style=""> </span>Undefined operation for the given operands.
Check or define function %1_c_1 for overloading.</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><o:p><font
face="Times New Roman"> </font></o:p></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">I get the same error if I execute…</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><o:p><font
face="Times New Roman"> </font></o:p></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">clear;</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">sheets=readxls('C:\Program
Files\scilab-5.2.0\myscilab\IGE.xls')</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">s1=sheets(1)</font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">mydata=[s1(:,1),s1(:,$)] </font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><o:p><font
face="Times New Roman"> </font></o:p></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font
face="Times New Roman">Anybody tell me what I am missing here?</font></p>
</div>
</div>
</blockquote>
sheets is then a "mlist" (see the help readxls page)<br>
To get the corresponding matrix of strings: sheets.text<br>
To get the related matrix of numerical values: sheets.value<br>
To get the 3rd numerical column: sheets.value(:,3) (it should work; or:
c=sheets.value; c(:,3) )<br>
and so on.<br>
<br>
Hope This Help<br>
Samuel<br>
<br>
</body>
</html>