Bonjour à tous
je suis dans le domaine de la FAO (programmation de centre d'usinage à commande numérique). Un fois mon prog fait sur PC, il en résulte un fichier .CL (coordonnées du parcours outil). Il faudra encore le post-processer afin de le rendre compréhensible par la CN, maintenant il s'agit d'un fichier en langage ISO.
Et c là qu'on en arrive à mon problème. Pendant le post-processing il me faut transmettre au fraiseur différentes infos comme locations des différentes origines, outils utilisés, etc,....
Ainsi, pendant ce post-processing, j'ai le moyen d'ouvrir un fichier externe d'y rechercher du texte et d'en rajouter, et fermer enregistrer les modifs.
Vous verrez dans l'ex. ci-dessous à quoi ressemble mon document à remplir. Donc toutes les valeurs (Zm,90g,Zd,90m,...) devraient être remplacer par d'autres valeurs.
Quelles est la meilleure façon pour procéder?
Quelqu'un s'y connaît dans ce genre de choses?
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="Table_de_Decalage_filelist.xml">
<link rel=Edit-Time-Data href="Table_de_Decalage_editdata.mso">
<link rel=OLE-Object-Data href="Table_de_Decalage_oledata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>krumhptr</o:LastAuthor>
<o:Created>2007-02-28T08:31:58Z</o:Created>
<o:LastSaved>2007-03-02T09:15:55Z</o:LastSaved>
<o:Version>11.8122</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
<o:DoNotOrganizeInFolder/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .79in .98in .79in;
mso-header-margin:.49in;
mso-footer-margin:.49in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding:0px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
background:silver;
mso-pattern:auto none;}
.xl25
{mso-style-parent:style0;
border-top:1.5pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:1.5pt solid windowtext;}
.xl26
{mso-style-parent:style0;
border-top:1.5pt solid windowtext;
border-right:1.5pt solid windowtext;
border-bottom:none;
border-left:none;}
.xl27
{mso-style-parent:style0;
border-top:none;
border-right:none;
border-bottom:none;
border-left:1.5pt solid windowtext;}
.xl28
{mso-style-parent:style0;
border-top:none;
border-right:1.5pt solid windowtext;
border-bottom:none;
border-left:none;}
.xl29
{mso-style-parent:style0;
border-top:none;
border-right:none;
border-bottom:1.5pt solid windowtext;
border-left:1.5pt solid windowtext;}
.xl30
{mso-style-parent:style0;
border-top:none;
border-right:1.5pt solid windowtext;
border-bottom:1.5pt solid windowtext;
border-left:none;}
.xl31
{mso-style-parent:style0;
text-align:left;
border-top:none;
border-right:none;
border-bottom:none;
border-left:1.5pt solid windowtext;}
.xl32
{mso-style-parent:style0;
text-align:center;
border-top:1.5pt solid windowtext;
border-right:1.5pt solid windowtext;
border-bottom:none;
border-left:1.5pt solid windowtext;}
.xl33
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:1.5pt solid windowtext;
border-bottom:none;
border-left:1.5pt solid windowtext;}
.xl34
{mso-style-parent:style0;
text-align:center;}
.xl35
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:1.5pt solid windowtext;
border-bottom:1.5pt solid windowtext;
border-left:1.5pt solid windowtext;}
.xl36
{mso-style-parent:style0;
text-align:right;
border-top:none;
border-right:1.5pt solid windowtext;
border-bottom:none;
border-left:none;}
.xl37
{mso-style-parent:style0;
text-align:center;
vertical-align:middle;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Table_de_Decalage</x:Name>
<x:WorksheetOptions>
<x:DefaultColWidth>10</x:DefaultColWidth>
<x:Zoom>200</x:Zoom>
<x:Selected/>
<x:DoNotDisplayGridlines/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>11</x:ActiveRow>
<x:ActiveCol>1</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>15840</x:WindowHeight>
<x:WindowWidth>23355</x:WindowWidth>
<x:WindowTopX>360</x:WindowTopX>
<x:WindowTopY>300</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=465 style='border-collapse:
collapse;table-layout:fixed;width:349pt'>
<col width=80 style='width:60pt'>
<col width=33 style='mso-width-source:userset;mso-width-alt:1206;width:25pt'>
<col width=80 span=2 style='width:60pt'>
<col width=79 style='mso-width-source:userset;mso-width-alt:2889;width:59pt'>
<col width=33 style='mso-width-source:userset;mso-width-alt:1206;width:25pt'>
<col width=80 style='width:60pt'>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 width=80 style='height:12.75pt;width:60pt'></td>
<td width=33 style='width:25pt'></td>
<td width=80 style='width:60pt'></td>
<td width=80 style='width:60pt'></td>
<td width=79 style='width:59pt'></td>
<td width=33 style='width:25pt'></td>
<td width=80 style='width:60pt'></td>
</tr>
<tr height=45 style='mso-height-source:userset;height:33.75pt'>
<td height=45 colspan=3 style='height:33.75pt;mso-ignore:colspan'></td>
<td class=xl37>180m</td>
<td colspan=3 style='mso-ignore:colspan'></td>
</tr>
<tr height=24 style='mso-height-source:userset;height:18.0pt'>
<td height=24 colspan=2 style='height:18.0pt;mso-ignore:colspan'></td>
<td class=xl37>270g</td>
<td class=xl24> </td>
<td class=xl37>90d</td>
<td colspan=2 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 style='height:13.5pt'></td>
<td class=xl37>180d</td>
<td></td>
<td class=xl32>180°</td>
<td></td>
<td class=xl37>180g</td>
<td></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 colspan=3 style='height:13.5pt;mso-ignore:colspan'></td>
<td class=xl33> </td>
<td colspan=3 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 style='height:13.5pt'></td>
<td class=xl24> </td>
<td class=xl25> </td>
<td class=xl34></td>
<td class=xl26> </td>
<td class=xl24> </td>
<td></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 style='height:12.75pt'></td>
<td class=xl24> </td>
<td class=xl27> </td>
<td class=xl34></td>
<td class=xl28> </td>
<td class=xl24> </td>
<td></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 class=xl37 style='height:12.75pt'>270m</td>
<td class=xl24> </td>
<td class=xl31>270°</td>
<td class=xl34></td>
<td class=xl36>90°</td>
<td class=xl24> </td>
<td class=xl37>90m</td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 style='height:12.75pt'></td>
<td class=xl24> </td>
<td class=xl27> </td>
<td class=xl34></td>
<td class=xl28> </td>
<td class=xl24> </td>
<td></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 style='height:13.5pt'></td>
<td class=xl24> </td>
<td class=xl29> </td>
<td class=xl34></td>
<td class=xl30> </td>
<td class=xl24> </td>
<td></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 colspan=3 style='height:13.5pt;mso-ignore:colspan'></td>
<td class=xl33> </td>
<td colspan=3 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:12.75pt'>
<td height=17 style='height:12.75pt'></td>
<td class=xl37>Zg</td>
<td></td>
<td class=xl33> </td>
<td></td>
<td class=xl37>Zd</td>
<td></td>
</tr>
<tr height=18 style='mso-height-source:userset;height:13.5pt'>
<td height=18 colspan=3 style='height:13.5pt;mso-ignore:colspan'></td>
<td class=xl35>0°</td>
<td colspan=3 style='mso-ignore:colspan'></td>
</tr>
<tr height=24 style='mso-height-source:userset;height:18.0pt'>
<td height=24 colspan=2 style='height:18.0pt;mso-ignore:colspan'></td>
<td class=xl37>270d</td>
<td align=left valign=top><!--[if gte vml 1]><v:shapetype id="_x0000_t68"
coordsize="21600,21600" o:spt="68" adj="5400,5400" path="m0@0l@1@0@1,21600@2,21600@2@0,21600@0,10800,xe">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="val #0"/>
<v:f eqn="val #1"/>
<v:f eqn="sum 21600 0 #1"/>
<v:f eqn="prod #0 #1 10800"/>
<v:f eqn="sum #0 0 @3"/>
</v:formulas>
<v:path o:connecttype="custom" o:connectlocs="10800,0;0,@0;10800,21600;21600,@0"
o:connectangles="270,180,90,0" textboxrect="@1,@4,@2,21600"/>
<v:handles>
<v:h position="#1,#0" xrange="0,10800" yrange="0,21600"/>
</v:handles>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t68" style='position:absolute;
margin-left:27.75pt;margin-top:1.5pt;width:4.5pt;height:16.5pt;z-index:1'
fillcolor="window [65]" strokecolor="windowText [64]" o:insetmode="auto"/><![endif]--><![if !vml]><span
style='mso-ignore:vglayout;position:absolute;z-index:1;margin-left:35px;
margin-top:0px;width:10px;height:25px'><img width=10 height=25
src="Table_de_Decalage_image001.png" v:shapes="_x0000_s1025"></span><![endif]><span
style='mso-ignore:vglayout2'>
<table cellpadding=0 cellspacing=0>
<tr>
<td height=24 class=xl24 width=80 style='height:18.0pt;width:60pt'> </td>
</tr>
</table>
</span></td>
<td class=xl37>90g</td>
<td colspan=2 style='mso-ignore:colspan'></td>
</tr>
<tr height=45 style='mso-height-source:userset;height:33.75pt'>
<td height=45 colspan=3 style='height:33.75pt;mso-ignore:colspan'></td>
<td class=xl37>Zm</td>
<td colspan=3 style='mso-ignore:colspan'></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=80 style='width:60pt'></td>
<td width=33 style='width:25pt'></td>
<td width=80 style='width:60pt'></td>
<td width=80 style='width:60pt'></td>
<td width=79 style='width:59pt'></td>
<td width=33 style='width:25pt'></td>
<td width=80 style='width:60pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
---------------
Merci à tous
