<p dir="ltr">Thanks slot that was very helpful </p>
<p dir="ltr">Plse how can one plot a single column by every other column in a matrix? And that on a single screen.<br></p>
<p dir="ltr">Thanks a lot! <br></p>
<div class="gmail_quote">On Nov 8, 2016 1:17 PM, "Dang Ngoc Chan, Christophe" <<a href="mailto:Christophe.Dang@sidel.com">Christophe.Dang@sidel.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
> De : users [mailto:<a href="mailto:users-bounces@lists.scilab.org">users-bounces@lists.<wbr>scilab.org</a>] De la part de Godson Moses<br>
> Envoyé : mardi 8 novembre 2016 07:06<br>
><br>
> Please with a data set in Excel sheet<br>
> how do I export it to Scilab<br>
> and also select the columns and row I want to plot<br>
> neglecting the others.<br>
<br>
The best is to have a look at :<br>
<a href="https://help.scilab.org/docs/6.0.0/en_US/section_c76aa854271b0bbdb796e15512af62cf.html" rel="noreferrer" target="_blank">https://help.scilab.org/docs/<wbr>6.0.0/en_US/section_<wbr>c76aa854271b0bbdb796e15512af62<wbr>cf.html</a><br>
<br>
If you have .xls files, you can use xls_open() and xls_read().<br>
<br>
I personally always export a CSV from Excel, then use csvRead() in Siclab.<br>
But mind that by default, Excel use a semi-colon as separator and not a comma,<br>
therefore I use<br>
<br>
myValues = csvRead(filename, ";", "double");<br>
<br>
In any case, you get a matrix of values.<br>
If you want to plot the nth column vs. the mth column, just use<br>
<br>
X = myValues(:, m);<br>
<br>
Y = myValues(:, n);<br>
<br>
plot(X, Y);<br>
<br>
HTH,<br>
<br>
regards<br>
<br>
--<br>
Christophe Dang Ngoc Chan<br>
Mechanical calculation engineer<br>
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.<br>
______________________________<wbr>_________________<br>
users mailing list<br>
<a href="mailto:users@lists.scilab.org">users@lists.scilab.org</a><br>
<a href="http://lists.scilab.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.scilab.org/<wbr>mailman/listinfo/users</a><br>
</blockquote></div>