xml文档转换Excel

最新推荐文章于 2023-11-28 11:21:31 发布

qq_39633984

最新推荐文章于 2023-11-28 11:21:31 发布

阅读量4.1k

点赞数 1

本文链接：https://blog.csdn.net/qq_39633984/article/details/76168646

版权

package com.pl.dcloud.xmlParse;

import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import jxl.Cell;
import jxl.CellType;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.dom4j.Attribute;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

@SuppressWarnings({"unchecked","rawtypes"})
public class XmltoExcelUtil {

private static Map orderMap = new HashMap();// 订单信息map

private static List<Map> rolList = new ArrayList<Map>();// 分类2集合

public static void xmlBody2list(String xmlPath) throws DocumentException {
SAXReader reader = new SAXReader();
Document document = reader.read(new File(xmlPath));
Element root = document.getRootElement();
_buildXmlBody2map(root);
}

private static void _buildXmlBody2map(Element root) {
List elements = root.elements();// 获得子节点
Map category1Map=null;
Map category2Map=null;
Map category3Map=null;
Map componentMap=null;
for (Iterator it = elements.iterator(); it.hasNext();) {
Element elem = (Element) it.next();
if (elem.getName().equals("Order")) {// 判断是否为订单信息节点
List<Attribute> rootAttrs = elem.attributes(); // 当前节点的所有属性的List
for (Attribute attr : rootAttrs) {
orderMap.put(attr.getName(), attr.getValue());// 循环将订单节点信息放入ordermap
}
}
if (elem.getName().equals("SceneBOM")) {// 判断是否分类1
category1Map=new HashMap();
category1Map.put("B", elem.attributeValue("Room"));
rolList.add(category1Map);

List elements2 = elem.elements();// 获得子节点
for (Iterator it2 = elements2.iterator(); it2.hasNext();) {
Element elem2 = (Element) it2.next();
if (elem2.getName().equals("SingleGroup")) {// 判断是否分类2
category2Map=new HashMap();
category2Map.put("C", elem2.attributeValue("Name"));
rolList.add(category2Map);
List elements3 = elem2.elements();// 获得子节点
for (Iterator it3 = elements3.iterator(); it3.hasNext();) {
Element elem3 = (Element) it3.next();
if (elem3.getName().equals("Subassembly")) {// 判断是否分类3
category3Map=new HashMap();
category3Map.put("D", elem3.attributeValue("Name"));
rolList.add(category3Map);
List<Element> objectElements=getObjectElements(elem3);
for(Element objElment:objectElements){
componentMap=new HashMap();
componentMap.put("E", objElment.attributeValue("Name"));
Map objChildMap=getObjectChildElements(objElment);
Element transformElement=(Element)objChildMap.get("Transform");
Element materialElement=(Element)objChildMap.get("Material");
Element productSizeElement=(Element)objChildMap.get("ProductSize");
componentMap.put("F", transformElement.attributeValue("length"));
componentMap.put("G", transformElement.attributeValue("width"));
componentMap.put("H", transformElement.attributeValue("height"));
componentMap.put("I", materialElement.attributeValue("BaseName"));
componentMap.put("J", materialElement.attributeValue("ColorName"));
componentMap.put("K", materialElement.attributeValue("MapDir"));
componentMap.put("L", productSizeElement.attributeValue("EdgeSet"));
componentMap.put("N", orderMap.get("OrderCode"));
componentMap.put("O", orderMap.get("Userarea"));
componentMap.put("P", orderMap.get("Reviewer"));
componentMap.put("Q", orderMap.get("Reviewertime"));
componentMap.put("R", orderMap.get("UserName"));

componentMap.put("S", orderMap.get("BusinessmanAddr"));
componentMap.put("T", orderMap.get("Reviewercall"));
componentMap.put("U", orderMap.get("BusinessmanCall"));
componentMap.put("V", orderMap.get("Productiondate"));
componentMap.put("W", elem2.attributeValue("GroupID"));
componentMap.put("X", productSizeElement.attributeValue("Length"));
componentMap.put("Y", productSizeElement.attributeValue("Width"));
componentMap.put("Z", productSizeElement.attributeValue("Thickness"));
// System.out.println(componentMap.toString());
rolList.add(componentMap);
}

}
}
}
}
}
}
}

public static List<Element> getObjectElements(Element subassembly){
List<Element> resultements = new ArrayList<Element>();
List elements = subassembly.elements();// 获得子节点
for (Iterator it = elements.iterator(); it.hasNext();) {
Element elem = (Element) it.next();
if (elem.getName().equals("Object")) {
resultements.add(elem);
}
}
return resultements;
}

private static Map getObjectChildElements(Element objElement){
Map resultmap = new HashMap();
List elements = objElement.elements();// 获得子节点
for (Iterator it = elements.iterator(); it.hasNext();) {
Element elem = (Element) it.next();
resultmap.put(elem.getName(), elem);
}
return resultmap;
}

private static void writeToExcel(String excelPath) {
File f = new File(excelPath);
try {
Workbook wb = Workbook.getWorkbook(f);//
WritableWorkbook book = wb.createWorkbook(f, wb);
// Sheet sheet = wb.getSheet(0); // 获得第一个工作表对象
WritableSheet st = book.getSheet(0);

for (int i = 1; i < rolList.size(); i++) {
Map map=rolList.get(i-1);
for (int j = 0; j < st.getColumns(); j++) {
Cell cell = st.getCell(j, i); // 获得单元格
String key=getExcelColumnLabel(j);
//System.out.println( j);
//System.out.println( key);
//System.out.println( (String) (map.get(key)==null?"": map.get(key)));
Label label = new Label(j, i, (String) (map.get(key)==null?"": map.get(key)));
// Yes 是需要填充单元格的内容
st.addCell(label);
}
}
book.write();
book.close();
wb.close();
} catch (Exception e) {
e.printStackTrace();
}

}

private static String getExcelColumnLabel(int num) {
String temp = "";
double i = Math.floor(Math.log(25.0 * (num) / 26.0 + 1) / Math.log(26)) + 1;
if (i > 1) {
double sub = num - 26 * (Math.pow(26, i - 1) - 1) / 25;
for (double j = i; j > 0; j--) {
temp = temp + (char) (sub / Math.pow(26, j - 1) + 65);
sub = sub % Math.pow(26, j - 1);
}
} else {
temp = temp + (char) (num + 65);
}
return temp;
}

public static void xmltoexcel(String xmlPath,String excelPath) throws DocumentException{
orderMap.clear();
rolList.clear();
xmlBody2list(xmlPath);
XmltoExcelUtil.writeToExcel(excelPath);
}

/**
* @param args
* @throws DocumentException
*/
public static void main(String[] args) throws DocumentException {
// TODO Auto-generated method stub
XmltoExcelUtil.xmltoexcel("E:\\test\\XML文件-0112.xml","E:\\test\\表格模板.xls");
}

}

/// xml文档内容如下：

<?xml version="1.0"?>



-<Project Phone="18166618602" Company="公司" Data="2016-12-05" Designer="李四" Name="两室一厅简约风格设计方案">



<Order Sales="小丘" BusinessmanCall="10000121020" BusinessmanAddr="北京海淀区" Businessman="aweidnawda" Productiondate="2017-1-10" Reviewercall="18318881935" Reviewertime="2016-12-13" Reviewer="潘涛" Userarea="棠德小区" UserTel="18166618602" WeChat="1289879830" UserAddr="广州市" UserName="潘涛" OrderCode="161215092946"/>



<Ichnography Openging="" Radiator="" Bridge="" OutsideWindow="" Balcong="" Square="" Cylinder="" Door="" Window="0,2300,1000;0,2500,1000" Wall="0,0,2800;4000,0,2800;4000,5000,2800;0,5000,2800;0,0,2800;" name="户型图"> </Ichnography>



-<SceneBOM Roomaread="45.5㎡" FileCode="127867c109926de8303ac9c3faf29a27" Room="客厅">



<Camera TarPos="-588.34,27.53,1200.00" CamPos="-1063.74,1970.21,1200.00" Fov="90.00"/>



<GoodsData Rmarks="备注" Price="7890元" UnitName="个" style="简约" BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" SalesName="本公司或其他公司或淘宝网站" Size="1422*950*363" Count="1" ProjectName="茶几" ProjectNumber="3847-21682"/>



-<SingleGroup Name="掩门下柜二区间" Price="7890元" UnitName="个" BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" ColorName="心情" Remarks="备注" Standard="标准/非标" GroupID="001" ID="001" RoomNumber="卧室" Depth="550.0" Height="2100.0" Width="1334.0" ColorNumber="4020-22439-11" GoodsType="整体衣柜">



<Transform z="0.0" y="-2496.0" x="-2071.9" az="360.0" ay="0.0" ax="0.0" height="2100.0" length="550.0" width="1334.0"/>

<VarList Name="参数列表"/>



-<Subassembly Name="掩门下柜二区间" Price="7833元" BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" ColorName="心情" Standard="标准/非标" RoomNumber="卧室" Depth="550.0" Height="2100.0" Width="1334.0" ColorNumber="4020-22439-11" GoodsType="整体衣柜">

-<Object Name="底板" Price="7890元" UnitName="平方" Remarks="备注" Processroute="工艺路径" ObjType="矩形板" Id="1001" Class="panel">



<Transform z="0.0" y="22.0" x="18.0" az="0.0" ay="0.0" ax="0.0" height="18.0" length="527.0" width="640.0" z2="9.0" y2="285.5" x2="338.0" z1="0.0" y1="22.0" x1="18.0"/>

<Material BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" BaseMatBaseMat="20141114-132207688" WccMapDir="1"/>



<ProductSize Width="527.0" EBW1="1" EBL2="1" EBW2="2" EBL1="1" EdgeSet="1211" Kwidth="525.0" Klength="478.0" Thickness="18.0" Length="480.0"/>



<CncCode Name="CNC编码" Code2="001-20011" Code1="001-10014" Nub="001-001"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="117.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="2"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="405.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="2"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="69.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="2"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="453.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="149.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="373.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="149.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="373.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="3"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="2" ZA="9.0" YA="69.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="91.0" x="18.0" z0="9.0" y0="69.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="25.5" Face="0" ZA="18.0" YA="69.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="91.0" x="43.5" z0="18.0" y0="69.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="25.5" Face="1" ZA="18.0" YA="69.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="91.0" x="43.5" z0="18.0" y0="69.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="2" ZA="9.0" YA="453.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="475.0" x="18.0" z0="9.0" y0="453.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="25.5" Face="0" ZA="18.0" YA="453.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="475.0" x="43.5" z0="18.0" y0="453.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="3" ZA="9.0" YA="69.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="91.0" x="498.0" z0="9.0" y0="69.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="454.5" Face="0" ZA="18.0" YA="69.0" XA="454.5" Diam="15">

<Transform z="2100.0" y="91.0" x="472.5" z0="18.0" y0="69.0" x0="454.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="3" ZA="9.0" YA="453.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="475.0" x="498.0" z0="9.0" y0="453.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="454.5" Face="0" ZA="18.0" YA="453.0" XA="454.5" Diam="15">

<Transform z="2100.0" y="475.0" x="472.5" z0="18.0" y0="453.0" x0="454.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="117.0" FaceSide="1" Face="2" ZA="9.0" YA="117.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="139.0" x="18.0" z0="9.0" y0="117.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="117.0" X="25.5" Face="0" ZA="18.0" YA="117.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="139.0" x="43.5" z0="18.0" y0="117.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="149.0" FaceSide="0" Face="2" ZA="9.0" YA="149.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="171.0" x="18.0" z0="9.0" y0="149.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="405.0" FaceSide="1" Face="2" ZA="9.0" YA="405.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="427.0" x="18.0" z0="9.0" y0="405.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="405.0" X="25.5" Face="0" ZA="18.0" YA="405.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="427.0" x="43.5" z0="18.0" y0="405.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="373.0" FaceSide="0" Face="2" ZA="9.0" YA="373.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="395.0" x="18.0" z0="9.0" y0="373.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="117.0" FaceSide="1" Face="3" ZA="9.0" YA="117.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="139.0" x="498.0" z0="9.0" y0="117.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="117.0" X="454.5" Face="0" ZA="18.0" YA="117.0" XA="454.5" Diam="15">

<Transform z="2100.0" y="139.0" x="472.5" z0="18.0" y0="117.0" x0="454.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="149.0" FaceSide="0" Face="3" ZA="9.0" YA="149.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="171.0" x="498.0" z0="9.0" y0="149.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="405.0" FaceSide="1" Face="3" ZA="9.0" YA="405.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="427.0" x="498.0" z0="9.0" y0="405.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="405.0" X="454.5" Face="0" ZA="18.0" YA="405.0" XA="454.5" Diam="15">

<Transform z="2100.0" y="427.0" x="472.5" z0="18.0" y0="405.0" x0="454.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="373.0" FaceSide="0" Face="3" ZA="9.0" YA="373.0" XA="480.0" Diam="8">

<Transform z="2091.0" y="395.0" x="498.0" z0="9.0" y0="373.0" x0="480.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="左侧板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" Memo="内进16K 上留0 下留60" id="1002" class="panel">

<Transform z="0.0" y="0.0" x="0.0" az="0.0" ay="0.0" ax="0.0" height="2100.0" length="550.0" width="18.0" z2="1050.0" y2="275.0" x2="9.0" z1="0.0" y1="0.0" x1="0.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="竖纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="2100.0" width="550.0" EBW1="1" EBL2="1" EBW2="1" EBL1="2" EdgeSet="2111" kwidth="548.0" klength="2098.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code2="001-20021" Code="001-002"/>

<LinkParts Name="连接件"/>

-<DrillData Name="孔位数据">

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="91.0" X="2091.0" Face="1" ZA="0.0" YA="91.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="91.0" x="18.0" z0="2091.0" y0="91.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="475.0" X="2091.0" Face="1" ZA="0.0" YA="475.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="475.0" x="18.0" z0="2091.0" y0="475.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="开槽" Depth="9" Length="2040.0" Z="0.0" Y="19.0" X="1080.0" Face="1" YA="19.0" XA="60.0" Diam="6" YE="19.0" XE="2100.0">

<Transform z="1080.0" y="19.0" x="18.0" z2="60.0" y2="19.0" x2="18.0" z1="2100.0" y1="19.0" x1="18.0" z0="1080.0" y0="19.0" x0="18.0" face="3" z02="60.0" y02="19.0" x02="18.0" z01="2100.0" y01="19.0" x01="18.0"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="91.0" X="69.0" Face="1" ZA="0.0" YA="91.0" XA="69.0" Diam="10">

<Transform z="69.0" y="91.0" x="18.0" z0="69.0" y0="91.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="475.0" X="69.0" Face="1" ZA="0.0" YA="475.0" XA="69.0" Diam="10">

<Transform z="69.0" y="475.0" x="18.0" z0="69.0" y0="475.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="123.0" X="69.0" Face="1" ZA="0.0" YA="123.0" XA="69.0" Diam="8">

<Transform z="69.0" y="123.0" x="18.0" z0="69.0" y0="123.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="443.0" X="69.0" Face="1" ZA="0.0" YA="443.0" XA="69.0" Diam="8">

<Transform z="69.0" y="443.0" x="18.0" z0="69.0" y0="443.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="539.0" X="14.0" Face="1" ZA="0.0" YA="539.0" XA="14.0" Diam="10">

<Transform z="14.0" y="539.0" x="18.0" z0="14.0" y0="539.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="539.0" X="46.0" Face="1" ZA="0.0" YA="539.0" XA="46.0" Diam="8">

<Transform z="46.0" y="539.0" x="18.0" z0="46.0" y0="539.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="32.0" X="14.0" Face="1" ZA="0.0" YA="32.0" XA="14.0" Diam="10">

<Transform z="14.0" y="32.0" x="18.0" z0="14.0" y0="32.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="32.0" X="46.0" Face="1" ZA="0.0" YA="32.0" XA="46.0" Diam="8">

<Transform z="46.0" y="32.0" x="18.0" z0="46.0" y0="32.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="177.0" Face="1" ZA="0.0" YA="513.0" XA="177.0" Diam="5">

<Transform z="177.0" y="513.0" x="18.0" z0="177.0" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="145.0" Face="1" ZA="0.0" YA="513.0" XA="145.0" Diam="5">

<Transform z="145.0" y="513.0" x="18.0" z0="145.0" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="789.7" Face="1" ZA="0.0" YA="513.0" XA="789.7" Diam="5">

<Transform z="789.7" y="513.0" x="18.0" z0="789.7" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="757.7" Face="1" ZA="0.0" YA="513.0" XA="757.7" Diam="5">

<Transform z="757.7" y="513.0" x="18.0" z0="757.7" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="1402.3" Face="1" ZA="0.0" YA="513.0" XA="1402.3" Diam="5">

<Transform z="1402.3" y="513.0" x="18.0" z0="1402.3" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="1370.3" Face="1" ZA="0.0" YA="513.0" XA="1370.3" Diam="5">

<Transform z="1370.3" y="513.0" x="18.0" z0="1370.3" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="2015.0" Face="1" ZA="0.0" YA="513.0" XA="2015.0" Diam="5">

<Transform z="2015.0" y="513.0" x="18.0" z0="2015.0" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="门铰侧板引孔" Depth="5" Z="0.0" Y="513.0" X="1983.0" Face="1" ZA="0.0" YA="513.0" XA="1983.0" Diam="5">

<Transform z="1983.0" y="513.0" x="18.0" z0="1983.0" y0="513.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="139.0" X="2091.0" Face="1" ZA="0.0" YA="139.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="139.0" x="18.0" z0="2091.0" y0="139.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="171.0" X="2091.0" Face="1" ZA="0.0" YA="171.0" XA="2091.0" Diam="8">

<Transform z="2091.0" y="171.0" x="18.0" z0="2091.0" y0="171.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="427.0" X="2091.0" Face="1" ZA="0.0" YA="427.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="427.0" x="18.0" z0="2091.0" y0="427.0" x0="18.0" face="3"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="395.0" X="2091.0" Face="1" ZA="0.0" YA="395.0" XA="2091.0" Diam="8">

<Transform z="2091.0" y="395.0" x="18.0" z0="2091.0" y0="395.0" x0="18.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="右侧板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" Memo="内进16K 上留0 下留60" id="1003" class="panel">

<Transform z="0.0" y="0.0" x="1316.0" az="0.0" ay="0.0" ax="0.0" height="2100.0" length="550.0" width="18.0" z2="1050.0" y2="275.0" x2="1325.0" z1="0.0" y1="0.0" x1="1316.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="竖纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="2100.0" width="550.0" EBW1="1" EBL2="1" EBW2="1" EBL1="2" EdgeSet="2111" kwidth="548" klength="2098" thickness="18.0"/>

<CncCode Name="CNC编码" Code1="001-10034" Code="001-003"/>

<LinkParts Name="连接件"/>

-<DrillData Name="孔位数据">

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="91.0" X="2091.0" Face="0" ZA="18.0" YA="91.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="91.0" x="1316.0" z0="2091.0" y0="91.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="475.0" X="2091.0" Face="0" ZA="18.0" YA="475.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="475.0" x="1316.0" z0="2091.0" y0="475.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="开槽" Depth="9" Length="2040.0" Z="0.0" Y="19.0" X="1080.0" Face="0" YA="19.0" XA="60.0" Diam="6" YE="19.0" XE="2100.0">

<Transform z="1080.0" y="19.0" x="1316.0" z2="60.0" y2="19.0" x2="1316.0" z1="2100.0" y1="19.0" x1="1316.0" z0="1080.0" y0="19.0" x0="0.0" face="2" z02="60.0" y02="19.0" x02="0.0" z01="2100.0" y01="19.0" x01="0.0"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="91.0" X="69.0" Face="0" ZA="18.0" YA="91.0" XA="69.0" Diam="10">

<Transform z="69.0" y="91.0" x="1316.0" z0="69.0" y0="91.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="475.0" X="69.0" Face="0" ZA="18.0" YA="475.0" XA="69.0" Diam="10">

<Transform z="69.0" y="475.0" x="1316.0" z0="69.0" y0="475.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="123.0" X="69.0" Face="0" ZA="18.0" YA="123.0" XA="69.0" Diam="8">

<Transform z="69.0" y="123.0" x="1316.0" z0="69.0" y0="123.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="443.0" X="69.0" Face="0" ZA="18.0" YA="443.0" XA="69.0" Diam="8">

<Transform z="69.0" y="443.0" x="1316.0" z0="69.0" y0="443.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="539.0" X="14.0" Face="0" ZA="18.0" YA="539.0" XA="14.0" Diam="10">

<Transform z="14.0" y="539.0" x="1316.0" z0="14.0" y0="539.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="539.0" X="46.0" Face="0" ZA="18.0" YA="539.0" XA="46.0" Diam="8">

<Transform z="46.0" y="539.0" x="1316.0" z0="46.0" y0="539.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="32.0" X="14.0" Face="0" ZA="18.0" YA="32.0" XA="14.0" Diam="10">

<Transform z="14.0" y="32.0" x="1316.0" z0="14.0" y0="32.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="32.0" X="46.0" Face="0" ZA="18.0" YA="32.0" XA="46.0" Diam="8">

<Transform z="46.0" y="32.0" x="1316.0" z0="46.0" y0="32.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="侧板引孔" Depth="5" Z="0.0" Y="203.0" X="526.6" Face="0" ZA="18.0" YA="203.0" XA="526.6" Diam="3">

<Transform z="526.6" y="203.0" x="1316.0" z0="526.6" y0="203.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="侧板引孔" Depth="5" Z="0.0" Y="491.0" X="526.6" Face="0" ZA="18.0" YA="491.0" XA="526.6" Diam="3">

<Transform z="526.6" y="491.0" x="1316.0" z0="526.6" y0="491.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="91.0" X="1080.0" Face="0" ZA="18.0" YA="91.0" XA="1080.0" Diam="10">

<Transform z="1080.0" y="91.0" x="1316.0" z0="1080.0" y0="91.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="475.0" X="1080.0" Face="0" ZA="18.0" YA="475.0" XA="1080.0" Diam="10">

<Transform z="1080.0" y="475.0" x="1316.0" z0="1080.0" y0="475.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="123.0" X="1080.0" Face="0" ZA="18.0" YA="123.0" XA="1080.0" Diam="8">

<Transform z="1080.0" y="123.0" x="1316.0" z0="1080.0" y0="123.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="443.0" X="1080.0" Face="0" ZA="18.0" YA="443.0" XA="1080.0" Diam="8">

<Transform z="1080.0" y="443.0" x="1316.0" z0="1080.0" y0="443.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="139.0" X="2091.0" Face="0" ZA="18.0" YA="139.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="139.0" x="1316.0" z0="2091.0" y0="139.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="171.0" X="2091.0" Face="0" ZA="18.0" YA="171.0" XA="2091.0" Diam="8">

<Transform z="2091.0" y="171.0" x="1316.0" z0="2091.0" y0="171.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="胶粒孔" Depth="13" Z="0.0" Y="427.0" X="2091.0" Face="0" ZA="18.0" YA="427.0" XA="2091.0" Diam="10">

<Transform z="2091.0" y="427.0" x="1316.0" z0="2091.0" y0="427.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="垂直孔" Depth="13" Z="0.0" Y="395.0" X="2091.0" Face="0" ZA="18.0" YA="395.0" XA="2091.0" Diam="8">

<Transform z="2091.0" y="395.0" x="1316.0" z0="2091.0" y0="395.0" x0="0.0" face="2"/>

</Drill>

</DrillData>

</Object>
SS

-<Object Name="背板" Price="7890元" UnitName="平方" Remarks="备注" Processroute="工艺路径" ObjType="矩形板" id="1004" class="panel" CrmFlow="背板生产">

<Transform z="60.0" y="17.0" x="18.0" az="0.0" ay="0.0" ax="0.0" height="2040.0" length="5.0" width="488.0" z2="1080.0" y2="19.5" x2="262.0" z1="60.0" y1="17.0" x1="18.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="竖纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="2140.0" width="496.0" EBW1="0" EBL2="0" EBW2="0" EBL1="0" EdgeSet="0000" kwidth="496.0" klength="2040.0" thickness="5.0"/>

<CncCode Name="CNC编码" Code="001-004"/>

-<LinkParts Name="连接件">

<Link Name="开槽" Z="0.0" Y="2.5" X="1020.0" FaceSide="0" Face="4"/>

</LinkParts>

<DrillData Name="孔位数据"/>

</Object>

-<Object Name="底板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1005" class="panel">

<Transform z="60.0" y="22.0" x="18.0" az="0.0" ay="0.0" ax="0.0" height="18.0" length="527.0" width="480.0" z2="69.0" y2="285.5" x2="258.0" z1="60.0" y1="22.0" x1="18.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="480.0" width="527.0" EBW1="1" EBL2="1" EBW2="1" EBL1="2" EdgeSet="2111" kwidth="525.0" klength="478.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code2="001-20051" Code="001-005"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="69.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="2"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="453.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="101.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="421.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="101.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="421.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="3"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="2" ZA="9.0" YA="69.0" XA="0.0" Diam="8">

<Transform z="69.0" y="91.0" x="18.0" z0="9.0" y0="69.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="25.5" Face="1" ZA="0.0" YA="69.0" XA="25.5" Diam="15">

<Transform z="60.0" y="91.0" x="43.5" z0="0.0" y0="69.0" x0="25.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="2" ZA="9.0" YA="453.0" XA="0.0" Diam="8">

<Transform z="69.0" y="475.0" x="18.0" z0="9.0" y0="453.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="25.5" Face="1" ZA="0.0" YA="453.0" XA="25.5" Diam="15">

<Transform z="60.0" y="475.0" x="43.5" z0="0.0" y0="453.0" x0="25.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="3" ZA="9.0" YA="69.0" XA="480.0" Diam="8">

<Transform z="69.0" y="91.0" x="498.0" z0="9.0" y0="69.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="454.5" Face="1" ZA="0.0" YA="69.0" XA="454.5" Diam="15">

<Transform z="60.0" y="91.0" x="472.5" z0="0.0" y0="69.0" x0="454.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="3" ZA="9.0" YA="453.0" XA="480.0" Diam="8">

<Transform z="69.0" y="475.0" x="498.0" z0="9.0" y0="453.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="454.5" Face="1" ZA="0.0" YA="453.0" XA="454.5" Diam="15">

<Transform z="60.0" y="475.0" x="472.5" z0="0.0" y0="453.0" x0="454.5" face="1"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="101.0" FaceSide="1" Face="2" ZA="9.0" YA="101.0" XA="0.0" Diam="8">

<Transform z="69.0" y="123.0" x="18.0" z0="9.0" y0="101.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="421.0" FaceSide="1" Face="2" ZA="9.0" YA="421.0" XA="0.0" Diam="8">

<Transform z="69.0" y="443.0" x="18.0" z0="9.0" y0="421.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="101.0" FaceSide="1" Face="3" ZA="9.0" YA="101.0" XA="480.0" Diam="8">

<Transform z="69.0" y="123.0" x="498.0" z0="9.0" y0="101.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="421.0" FaceSide="1" Face="3" ZA="9.0" YA="421.0" XA="480.0" Diam="8">

<Transform z="69.0" y="443.0" x="498.0" z0="9.0" y0="421.0" x0="480.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="脚线" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1006" class="panel">

<Transform z="0.0" y="530.0" x="18.0" az="0.0" ay="0.0" ax="0.0" height="60.0" length="18.0" width="480.0" z2="30.0" y2="539.0" x2="258.0" z1="0.0" y1="530.0" x1="18.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="2"/>

<ProductSize length="480.0" width="60.0" EBW1="0" EBL2="2" EBW2="0" EBL1="2" EdgeSet="2020" kwidth="58" klength="480" thickness="18.0"/>

<CncCode Name="CNC编码" Code2="001-20061" Code="001-006"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="14.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="4"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="4"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="5"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="1" Face="2" ZA="9.0" YA="46.0" XA="0.0" Diam="8">

<Transform z="14.0" y="539.0" x="18.0" z0="14.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="25.5" Face="1" ZA="0.0" YA="46.0" XA="25.5" Diam="15">

<Transform z="14.0" y="530.0" x="43.5" z0="14.0" y0="0.0" x0="25.5" face="4"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="1" Face="3" ZA="9.0" YA="46.0" XA="480.0" Diam="8">

<Transform z="14.0" y="539.0" x="498.0" z0="14.0" y0="9.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="454.5" Face="1" ZA="0.0" YA="46.0" XA="454.5" Diam="15">

<Transform z="14.0" y="530.0" x="472.5" z0="14.0" y0="0.0" x0="454.5" face="4"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="1" Face="2" ZA="9.0" YA="14.0" XA="0.0" Diam="8">

<Transform z="46.0" y="539.0" x="18.0" z0="46.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="1" Face="3" ZA="9.0" YA="14.0" XA="480.0" Diam="8">

<Transform z="46.0" y="539.0" x="498.0" z0="46.0" y0="9.0" x0="480.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="脚线" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1007" class="panel">

<Transform z="0.0" y="23.0" x="18.0" az="0.0" ay="0.0" ax="0.0" height="60.0" length="18.0" width="480.0" z2="30.0" y2="32.0" x2="258.0" z1="0.0" y1="23.0" x1="18.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="2"/>

<ProductSize length="480.0" width="60.0" EBW1="0" EBL2="2" EBW2="0" EBL1="2" EdgeSet="2020" kwidth="58.0" klength="480.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code1="001-10074" Code="001-007"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="14.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="4"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="4"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="5"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="0" Face="2" ZA="9.0" YA="46.0" XA="0.0" Diam="8">

<Transform z="14.0" y="32.0" x="18.0" z0="14.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="25.5" Face="0" ZA="18.0" YA="46.0" XA="25.5" Diam="15">

<Transform z="14.0" y="41.0" x="43.5" z0="14.0" y0="18.0" x0="25.5" face="5"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="0" Face="3" ZA="9.0" YA="46.0" XA="480.0" Diam="8">

<Transform z="14.0" y="32.0" x="498.0" z0="14.0" y0="9.0" x0="480.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="454.5" Face="0" ZA="18.0" YA="46.0" XA="454.5" Diam="15">

<Transform z="14.0" y="41.0" x="472.5" z0="14.0" y0="18.0" x0="454.5" face="5"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="0" Face="2" ZA="9.0" YA="14.0" XA="0.0" Diam="8">

<Transform z="46.0" y="32.0" x="18.0" z0="46.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="0" Face="3" ZA="9.0" YA="14.0" XA="480.0" Diam="8">

<Transform z="46.0" y="32.0" x="498.0" z0="46.0" y0="9.0" x0="480.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="顶板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1008" class="panel">

<Transform z="2082.0" y="22.0" x="516.0" az="0.0" ay="0.0" ax="0.0" height="18.0" length="527.0" width="800.0" z2="2091.0" y2="285.5" x2="916.0" z1="2082.0" y1="22.0" x1="516.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="800.0" width="527.0" EBW1="1" EBL2="1" EBW2="1" EBL1="2" EdgeSet="2111" kwidth="525.0" klength="798.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code1="001-10084" Code="001-008"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="117.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="3"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="405.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="3"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="69.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="3"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="453.0" Specs="" Number="550500111" Brand="" FaceSide="0" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="149.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="373.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="149.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="373.0" Specs="" Number="160143111" Brand="" FaceSide="0" Face="3"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="0" Face="2" ZA="9.0" YA="69.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="91.0" x="516.0" z0="9.0" y0="69.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="25.5" Face="0" ZA="18.0" YA="69.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="91.0" x="541.5" z0="18.0" y0="69.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="0" Face="2" ZA="9.0" YA="453.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="475.0" x="516.0" z0="9.0" y0="453.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="25.5" Face="0" ZA="18.0" YA="453.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="475.0" x="541.5" z0="18.0" y0="453.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="0" Face="3" ZA="9.0" YA="69.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="91.0" x="1316.0" z0="9.0" y0="69.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="774.5" Face="0" ZA="18.0" YA="69.0" XA="774.5" Diam="15">

<Transform z="2100.0" y="91.0" x="1290.5" z0="18.0" y0="69.0" x0="774.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="0" Face="3" ZA="9.0" YA="453.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="475.0" x="1316.0" z0="9.0" y0="453.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="774.5" Face="0" ZA="18.0" YA="453.0" XA="774.5" Diam="15">

<Transform z="2100.0" y="475.0" x="1290.5" z0="18.0" y0="453.0" x0="774.5" face="0"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="117.0" FaceSide="0" Face="2" ZA="9.0" YA="117.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="139.0" x="516.0" z0="9.0" y0="117.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="117.0" X="25.5" Face="0" ZA="18.0" YA="117.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="139.0" x="541.5" z0="18.0" y0="117.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="149.0" FaceSide="0" Face="2" ZA="9.0" YA="149.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="171.0" x="516.0" z0="9.0" y0="149.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="405.0" FaceSide="0" Face="2" ZA="9.0" YA="405.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="427.0" x="516.0" z0="9.0" y0="405.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="405.0" X="25.5" Face="0" ZA="18.0" YA="405.0" XA="25.5" Diam="15">

<Transform z="2100.0" y="427.0" x="541.5" z0="18.0" y0="405.0" x0="25.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="373.0" FaceSide="0" Face="2" ZA="9.0" YA="373.0" XA="0.0" Diam="8">

<Transform z="2091.0" y="395.0" x="516.0" z0="9.0" y0="373.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="117.0" FaceSide="0" Face="3" ZA="9.0" YA="117.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="139.0" x="1316.0" z0="9.0" y0="117.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="117.0" X="774.5" Face="0" ZA="18.0" YA="117.0" XA="774.5" Diam="15">

<Transform z="2100.0" y="139.0" x="1290.5" z0="18.0" y0="117.0" x0="774.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="149.0" FaceSide="0" Face="3" ZA="9.0" YA="149.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="171.0" x="1316.0" z0="9.0" y0="149.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="405.0" FaceSide="0" Face="3" ZA="9.0" YA="405.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="427.0" x="1316.0" z0="9.0" y0="405.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="405.0" X="774.5" Face="0" ZA="18.0" YA="405.0" XA="774.5" Diam="15">

<Transform z="2100.0" y="427.0" x="1290.5" z0="18.0" y0="405.0" x0="774.5" face="0"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="373.0" FaceSide="0" Face="3" ZA="9.0" YA="373.0" XA="800.0" Diam="8">

<Transform z="2091.0" y="395.0" x="1316.0" z0="9.0" y0="373.0" x0="800.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="背板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1009" class="panel" CrmFlow="背板生产">

<Transform z="60.0" y="17.0" x="508.0" az="0.0" ay="0.0" ax="0.0" height="2040.0" length="5.0" width="808.0" z2="1080.0" y2="19.5" x2="912.0" z1="60.0" y1="17.0" x1="508.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="竖纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="2040.0" width="816.0" EBW1="0" EBL2="0" EBW2="0" EBL1="0" EdgeSet="0000" kwidth="816.0" klength="2040.0" thickness="5.0"/>

<CncCode Name="CNC编码" Code="001-009"/>

-<LinkParts Name="连接件">

<Link Name="开槽" Z="0.0" Y="2.5" X="1020.0" FaceSide="0" Face="5"/>

</LinkParts>

<DrillData Name="孔位数据"/>

</Object>

-<Object Name="底板" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1010" class="panel">

<Transform z="60.0" y="22.0" x="516.0" az="0.0" ay="0.0" ax="0.0" height="18.0" length="527.0" width="800.0" z2="69.0" y2="285.5" x2="916.0" z1="60.0" y1="22.0" x1="516.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="1"/>

<ProductSize length="800.0" width="527.0" EBW1="1" EBL2="1" EBW2="1" EBL1="2" EdgeSet="2111" kwidth="525.0" klength="798.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code2="001-20101" Code="001-010"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="69.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="3"/>

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="453.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="101.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="421.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="2"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="101.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="3"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="421.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="3"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="2" ZA="9.0" YA="69.0" XA="0.0" Diam="8">

<Transform z="69.0" y="91.0" x="516.0" z0="9.0" y0="69.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="25.5" Face="1" ZA="0.0" YA="69.0" XA="25.5" Diam="15">

<Transform z="60.0" y="91.0" x="541.5" z0="0.0" y0="69.0" x0="25.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="2" ZA="9.0" YA="453.0" XA="0.0" Diam="8">

<Transform z="69.0" y="475.0" x="516.0" z0="9.0" y0="453.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="25.5" Face="1" ZA="0.0" YA="453.0" XA="25.5" Diam="15">

<Transform z="60.0" y="475.0" x="541.5" z0="0.0" y0="453.0" x0="25.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="69.0" FaceSide="1" Face="3" ZA="9.0" YA="69.0" XA="800.0" Diam="8">

<Transform z="69.0" y="91.0" x="1316.0" z0="9.0" y0="69.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="69.0" X="774.5" Face="1" ZA="0.0" YA="69.0" XA="774.5" Diam="15">

<Transform z="60.0" y="91.0" x="1290.5" z0="0.0" y0="69.0" x0="774.5" face="1"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="453.0" FaceSide="1" Face="3" ZA="9.0" YA="453.0" XA="800.0" Diam="8">

<Transform z="69.0" y="475.0" x="1316.0" z0="9.0" y0="453.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="453.0" X="774.5" Face="1" ZA="0.0" YA="453.0" XA="774.5" Diam="15">

<Transform z="60.0" y="475.0" x="1290.5" z0="0.0" y0="453.0" x0="774.5" face="1"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="101.0" FaceSide="1" Face="2" ZA="9.0" YA="101.0" XA="0.0" Diam="8">

<Transform z="69.0" y="123.0" x="516.0" z0="9.0" y0="101.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="421.0" FaceSide="1" Face="2" ZA="9.0" YA="421.0" XA="0.0" Diam="8">

<Transform z="69.0" y="443.0" x="516.0" z0="9.0" y0="421.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="101.0" FaceSide="1" Face="3" ZA="9.0" YA="101.0" XA="800.0" Diam="8">

<Transform z="69.0" y="123.0" x="1316.0" z0="9.0" y0="101.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="421.0" FaceSide="1" Face="3" ZA="9.0" YA="421.0" XA="800.0" Diam="8">

<Transform z="69.0" y="443.0" x="1316.0" z0="9.0" y0="421.0" x0="800.0" face="3"/>

</Drill>

</DrillData>

</Object>

-<Object Name="脚线" Price="7890元" UnitName="平方" ObjType="矩形板" processroute="工艺路径" remarks="备注" id="1011" class="panel">

<Transform z="0.0" y="530.0" x="516.0" az="0.0" ay="0.0" ax="0.0" height="60.0" length="18.0" width="800.0" z2="30.0" y2="539.0" x2="916.0" z1="0.0" y1="530.0" x1="516.0"/>

<Material BaseMat="20141114-132207688" BaseName="原态板" MapDir="横纹" PartsNumber="4020-22439-11" ColorName="心情" WccMapDir="2"/>

<ProductSize length="800.0" width="60.0" EBW1="0" EBL2="2" EBW2="0" EBL1="2" EdgeSet="2020" kwidth="60.0" klength="800.0" thickness="18.0"/>

<CncCode Name="CNC编码" Code2="001-20111" Code="001-011"/>

-<LinkParts Name="连接件">

<Link Name="三合一" UnitName="个" Z="0.0" Y="9.0" X="14.0" Specs="" Number="550500111" Brand="" FaceSide="1" Face="5"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="4"/>

<Link Name="木榫" UnitName="个" Z="0.0" Y="9.0" X="46.0" Specs="" Number="160143111" Brand="" FaceSide="1" Face="5"/>

</LinkParts>

-<DrillData Name="孔位数据">

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="1" Face="2" ZA="9.0" YA="46.0" XA="0.0" Diam="8">

<Transform z="14.0" y="539.0" x="516.0" z0="14.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="25.5" Face="1" ZA="0.0" YA="46.0" XA="25.5" Diam="15">

<Transform z="14.0" y="530.0" x="541.5" z0="14.0" y0="0.0" x0="25.5" face="4"/>

</Drill>

-<Drill Name="连杆水平孔" Depth="30" Z="0.0" Y="9.0" X="46.0" FaceSide="1" Face="3" ZA="9.0" YA="46.0" XA="800.0" Diam="8">

<Transform z="14.0" y="539.0" x="1316.0" z0="14.0" y0="9.0" x0="800.0" face="3"/>

</Drill>

-<Drill Name="大柄孔" Depth="14" Z="0.0" Y="46.0" X="774.5" Face="1" ZA="0.0" YA="46.0" XA="774.5" Diam="15">

<Transform z="14.0" y="530.0" x="1290.5" z0="14.0" y0="0.0" x0="774.5" face="4"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="1" Face="2" ZA="9.0" YA="14.0" XA="0.0" Diam="8">

<Transform z="46.0" y="539.0" x="516.0" z0="46.0" y0="9.0" x0="0.0" face="2"/>

</Drill>

-<Drill Name="水平孔" Depth="30" Z="0.0" Y="9.0" X="14.0" FaceSide="1" Face="3" ZA="9.0" YA="14.0" XA="800.0" Diam="8">

<Transform z

最低0.47元/天解锁文章

qq_39633984

关注

1
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
xml文档转换Excel

package com.pl.dcloud.xmlParse;import java.io.File;import java.util.ArrayList;import java.util.HashMap;import java.util.Iterator;import java.util.List;import java.util.Map;import jxl
复制链接

扫一扫