Dear Samuel<br><br><p style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Times New Roman">You may try the following:</font></p><p style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Times New Roman"><br></font></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('test.xls') // test.xls is in the directory path<br></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>
mydata=list(tday,cls) // list is used instead of matrix variable<br><br>Regards,<br>celso<br><br><div class="gmail_quote">On Fri, Jan 22, 2010 at 1:30 PM, Samuel Gougeon <span dir="ltr"><<a href="mailto:Samuel.Gougeon@univ-lemans.fr">Samuel.Gougeon@univ-lemans.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
----- Message d'origine ----- <br>
De : Sean Cooper <br>
Date : 21/01/2010 21:45:
<blockquote type="cite">
<div style="font-family: verdana,helvetica,sans-serif; font-size: 12pt;">
<div><font face="Times New Roman">.../...</font><div class="im">
<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"><font face="Times New Roman"> </font></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"><font face="Times New Roman"> </font></p>
<p style="margin: 0in 0in 0pt;" class="MsoNormal"><font face="Times New Roman">I get “mydata=[tday,cls]<span> </span>!—error
144<span> </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"><font face="Times New Roman"> </font></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"><font face="Times New Roman"> </font></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"><font face="Times New Roman"> </font></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>
</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>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Eng'r Celso B. Co, PhD ECE<br>Assistant Professor<br>Dept. of Electronics, Computer, and Communication Engineering, <br>Loyola Schools of Science and Engineering, Ateneo De Manila<br>