<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19258"></HEAD>
<BODY>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012>Bonjour,</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=419532309-31072012>Je cherche à faire
ceci:</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=419532309-31072012> -
importer des données d'une feuille Excel dans Scilab</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=419532309-31072012> -
puis renvoyer les données modifiées sur la même feuille
Excel.</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=419532309-31072012></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=419532309-31072012>J'ai essayé
avec ceci:</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN class=419532309-31072012> </DIV>
<DIV class=programlisting>
<TABLE border=0 width="100%">
<TBODY>
<TR>
<TD width="98%">
<DIV align=left><PRE class=scilabcode><SPAN class=scilabid>Sheets</SPAN> <SPAN class=scilaboperator>=</SPAN> <SPAN class=scilabmacro>readxls</SPAN><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabstring>'SCI/modules/spreadsheet/demos/xls/t1.xls'</SPAN><SPAN class=scilabopenclose>)</SPAN>
<SPAN class=scilabcomment>// some basic operations on Sheets</SPAN>
<A class=scilabmacro href="outbind://3/typeof.html">typeof</A><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabid>Sheets</SPAN><SPAN class=scilabopenclose>)</SPAN>
<SPAN class=scilabid>s1</SPAN><SPAN class=scilaboperator>=</SPAN><SPAN class=scilabid>Sheets</SPAN><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabnumber>1</SPAN><SPAN class=scilabopenclose>)</SPAN> <SPAN class=scilabcomment>//get the first sheet</SPAN>
<A class=scilabmacro href="outbind://3/typeof.html">typeof</A><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabid>s1</SPAN><SPAN class=scilabopenclose>)</SPAN>
<SPAN class=scilabid>s1</SPAN><SPAN class=scilaboperator>.</SPAN><SPAN class=scilabfield>value</SPAN> <SPAN class=scilabcomment>//get the first sheet value field</SPAN>
<SPAN class=scilabid>s1</SPAN><SPAN class=scilaboperator>.</SPAN><SPAN class=scilabfield>text</SPAN> <SPAN class=scilabcomment>//get the first sheet text field</SPAN>
<SPAN class=scilabid>s1</SPAN><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabnumber>2</SPAN><SPAN class=scilabdefault>,</SPAN><SPAN class=scilabspecial>:</SPAN><SPAN class=scilabopenclose>)</SPAN> <SPAN class=scilabcomment>//get the 2 row of the sheet</SPAN>
<A class=scilabmacro href="outbind://3/typeof.html">typeof</A><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabid>s1</SPAN><SPAN class=scilabopenclose>(</SPAN><SPAN class=scilabnumber>2</SPAN><SPAN class=scilabdefault>,</SPAN><SPAN class=scilabspecial>:</SPAN><SPAN class=scilabopenclose>))</SPAN></PRE></DIV></TD></TR></TBODY></TABLE></DIV></SPAN></FONT><SPAN
style="COLOR: rgb(74,85,219)"></SPAN><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000>Mais quand je veux envoyer les nouvelles données vers la page Excel, il me dit que le fichier est en lecture seul.</FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000>J'ai aussi essayé avec:</FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="FONT-STYLE: italic; COLOR: rgb(1,168,1)">//Decode ole file, extract and open Excel stream</SPAN>
<SPAN style="COLOR: rgb(74,85,219)">[</SPAN><SPAN style="COLOR: rgb(0,0,0)">fd</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(0,0,0)">SST</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(0,0,0)">Sheetnames</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(0,0,0)">Sheetpos</SPAN><SPAN style="COLOR: rgb(74,85,219)">]</SPAN> <SPAN style="COLOR: rgb(92,92,92)">=</SPAN> <SPAN style="COLOR: rgb(50,185,185)">xls_open</SPAN><SPAN style="COLOR: rgb(74,85,219)">(</SPAN><SPAN style="COLOR: rgb(0,0,0)">PATH</SPAN> <SPAN style="COLOR: rgb(92,92,92)">+</SPAN> <SPAN style="COLOR: rgb(188,143,143)">'</SPAN><SPAN style="COLOR: rgb(188,143,143)">/troe.xls</SPAN><SPAN style="COLOR: rgb(188,143,143)">'</SPAN><SPAN style="COLOR: rgb(74,85,219)">)</SPAN>
<SPAN style="FONT-STYLE: italic; COLOR: rgb(1,168,1)">//Read first data sheet</SPAN>
<SPAN style="COLOR: rgb(74,85,219)">[</SPAN><SPAN style="COLOR: rgb(0,0,0)">Value</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(0,0,0)">INPUT</SPAN><SPAN style="COLOR: rgb(74,85,219)">]</SPAN> <SPAN style="COLOR: rgb(92,92,92)">=</SPAN> <SPAN style="COLOR: rgb(50,185,185)">xls_read</SPAN><SPAN style="COLOR: rgb(74,85,219)">(</SPAN><SPAN style="COLOR: rgb(0,0,0)">fd</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(0,0,0)">Sheetpos</SPAN><SPAN style="COLOR: rgb(74,85,219)">(</SPAN><SPAN style="COLOR: rgb(188,143,143)">1</SPAN><SPAN style="COLOR: rgb(74,85,219)">)</SPAN><SPAN style="COLOR: rgb(0,0,0)">,</SPAN><SPAN style="COLOR: rgb(188,143,143)">'</SPAN><SPAN style="COLOR: rgb(188,143,143)">.</SPAN><SPAN style="COLOR: rgb(188,143,143)">'</SPAN><SPAN style="COLOR: rgb(74,85,219)">)</SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"></SPAN> </PRE></FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000>Mais les nombres décimaux après la virgule ne sont pas lus. </FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000>Comment puis je résoudre mon problème ?</FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000>Je vous remercie pour votre temps et votre considération,</FONT></SPAN></SPAN></PRE><PRE style="FONT-STYLE: normal; FONT-FAMILY: Monospaced; FONT-SIZE: 14px"><SPAN style="COLOR: rgb(74,85,219)"><SPAN class=419532309-31072012><FONT color=#000000 size=2 face=Arial>Cordialement,</FONT></SPAN></SPAN></PRE></BODY></HTML>
<pre>--------------------------------------------------------------------------------
Le présent mail et ses pièces jointes sont confidentiels et destinés à la personne ou aux personnes visée(s) ci-dessus. Si vous avez reçu cet e-mail par erreur, veuillez contacter immédiatement l'expéditeur et effacer le message de votre système. Toute divulgation, copie ou distribution de cet e-mail est strictement interdite.
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please contact the sender and delete the email from your system. If you are not the named addressee you should not disseminate, distribute or copy this email.