Conversion xls > xml - Forum Excel

Conversion xls > xml Conversion .xls en .qif (Résolu) [VBA Excel] Conversion xls vers csv (Résolu) Conversion xls ou csv à ldif [MSN] CONVERSATION FICHIER XML, OPEN THIS ? Conversion xls en pdf

Bonjour à tous,
Je me permets de vous contacter dans le cadre de mon boulot. Je suis charpentier et dispose dans mon entreprise d'une tronçonneuse numérique qui lit des listes de pièces à découper au format xml. Le bureau d'études lui les exporte au format excel sous la forme suivante:

N° pièce
Hauteur
Epaisseur
Longueur
Quantité
N° mur

Voici ici un exemple d'excel avec une liste de production brute et une macro qui générerait un tri par section stricte (réalisée par eriiic du forum, merci à lui : https://www.cjoint.com/c/HAmwBwePFny ).

Au sein du fichier xml, les pièces sont regroupées par section (hauteur ET épaisseur strictement identiques) sous un en-tête qui liste ensuite les longueurs, le numéro de mur (s'il y en a un) et la quantité de chacune. Voici ci-dessous un exemple de code avec trois section différentes 30x65, 45x240 et 80x240 avec pour chacune, plusieurs longueurs et dans le cas du 45x240, deux longueurs de 555 n'appartenant pas au même mur (MD101 et MD102) et donc codées l'une à la suite de l'autre.

 <?xml version="1.0"?> <Programs fileversion="version 1.0">     <PrgProgram>02012018_Test_Stromab</PrgProgram>     <PrgHeadTrimmingLength>0</PrgHeadTrimmingLength>     <PrgTailTrimmingLength>0</PrgTailTrimmingLength>     <PrgPrinterField1></PrgPrinterField1>     <PrgPrinterField2></PrgPrinterField2>     <PrgPrinterField3></PrgPrinterField3>     <PrgPreOptimized>0</PrgPreOptimized>     <PrgProgrammedBarLength>0</PrgProgrammedBarLength>     <PrgSections>         <SecSectionID>1</SecSectionID>         <SecHeight>30</SecHeight>         <SecMinWidth/>         <SecMaxWidth/>         <SecWidth>65</SecWidth>         <PreOpt/>         <PrgPieces>             <PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>1</PcPieceID>             <PcLength>830</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>2</PcUnloader1>             <PcUnloader2>0</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2572</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces> 		<PrgPieces> 			<PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>2</PcPieceID>             <PcLength>3980</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>1</PcUnloader1>             <PcUnloader2>3</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2562</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected>         </PrgPieces> 	    <SecSectionID>2</SecSectionID>         <SecHeight>45</SecHeight>         <SecMinWidth/>         <SecMaxWidth/>         <SecWidth>240</SecWidth>         <PreOpt/>         <PrgPieces>             <PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>3</PcPieceID>             <PcLength>413</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>2</PcUnloader1>             <PcUnloader2>0</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2546</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces> 		<PrgPieces> 			<PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>4</PcPieceID>             <PcLength>452</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>2</PcUnloader1>             <PcUnloader2>0</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2544</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces> 		<PrgPieces> 			<PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>5</PcPieceID>             <PcLength>555</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>2</PcUnloader1>             <PcUnloader2>0</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2534</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces> 		<PrgPieces> 			<PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>6</PcPieceID>             <PcLength>555</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>2</PcUnloader1>             <PcUnloader2>0</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2534</PcPrinterField2>             <PcPrinterField3>MD102</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces> 	    <SecSectionID>3</SecSectionID>         <SecHeight>80</SecHeight>         <SecMinWidth/>         <SecMaxWidth/>         <SecWidth>240</SecWidth>         <PreOpt/>         <PrgPieces>             <PcPage/>             <PcQuality>1</PcQuality>             <PcPieceID>12</PcPieceID>             <PcLength>2945</PcLength>             <PcNumberOfPieces>1</PcNumberOfPieces>             <PcPriority>0</PcPriority>             <PcUnloader1>1</PcUnloader1>             <PcUnloader2>3</PcUnloader2>             <PcPrinterCode></PcPrinterCode>             <PcPrinterId></PcPrinterId>             <PcPrinterField1></PcPrinterField1>             <PcPrinterField2>2481</PcPrinterField2>             <PcPrinterField3>MD101</PcPrinterField3>             <PcPrinterField4></PcPrinterField4>             <PcPrinterField5></PcPrinterField5>             <PcPrinterField6></PcPrinterField6>             <PcPrinterField7></PcPrinterField7>             <PcPrinterField8></PcPrinterField8>             <PcPrinterField9></PcPrinterField9>             <PcPrinterField10></PcPrinterField10>             <PcNumberOfDonePieces>0</PcNumberOfDonePieces>             <PcSelected>1</PcSelected> 		</PrgPieces>     </PrgSections> </Programs> 


Afin de faciliter la tâche des gars à l'atelier, je souhaiterais un peu d'aide pour développer un fichier excel qui automatiserait la conversion.
Avez-vous des idées sur la conception (la forme que pourrait prendre l'interface) et d'éventuelles idées de fonction, macros etc ?

D'avance merci, bien à vous.
Baptiste.


Forum

Conversion xls > xml Conversion .xls en .qif (Résolu) [VBA Excel] Conversion xls vers csv (Résolu) Conversion xls ou csv à ldif [MSN] CONVERSATION FICHIER XML, OPEN THIS ? Conversion xls en pdf

Web: www.shapebootstrap.net

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed