3、SAP提供TRANSFORMATION的方式直接创建XML的二进制文件
这种方法对ABAP程序里面的开发相对简单,但是需要在STRANS建立 simple transform:
data:i_contents_hex like solix occurs 0 with header line.
data:xml_xstring type xstring.
call transformation z_lian_xml_volvo
SOURCE header = lt_itab
detail = lt_itab
RESULT XML xml_xstring.
CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'
EXPORTING
buffer = xml_xstring
TABLES
binary_tab = i_contents_hex.
STRANS中代码相对复杂一点:
<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
<tt:root name="HEADER"/>
<tt:root name="DETAIL"/>
<tt:template>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Styles>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Center"/>
<Borders/>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s62">
<Alignment ss:Vertical="Center" ss:Horizontal="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weifht="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:FontName="Arial" x:Fanmily="Swiss" ss:Bold="1"/>
<Interior ss:Color="#F9F900" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s63">
<Alignment ss:Vertical="Center" ss:Horizontal="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weifht="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weifht="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
</Style>
</Styles>
<Worksheet ss:Name="Header" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:ExpandedColumnCount="19" ss:ExpandedRowCount="2" x:FullColums="1"
x:FullRows="1" ss:DefaultRowHeight="14.25">
<Row ss:Height="25.5">
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname1</Data></Cell>
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname2</Data></Cell>
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname3</Data></Cell>
</Row>
<tt:loop ref = ".HEADER">
<Row>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_1"/></Data></Cell>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_2"/></Data></Cell>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_3"/></Data></Cell>
</Row>
<Row/>
</tt:loop>
</Table>
</Worksheet>
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="DETAIL">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:ExpandedColumnCount="16" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Row ss:Height="51">
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname1</Data></Cell>
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname2</Data></Cell>
<Cell ss:StyleID="s62"><Data ss:Type="String">Fieldname3</Data></Cell>
</Row>
<tt:loop ref=".DETAIL">
<Row>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_1"/></Data></Cell>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_2"/></Data></Cell>
<Cell ss:StyleID="s63"><Data ss:Type="String"><tt:value ref="field_3"/></Data></Cell>
</Row>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</Workbook>
</tt:template>
</tt:transform>
下面还带有两个相对复杂一点的transform做一下例子,主要是格式上更丰富一点。
<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
<tt:root name="DATA_H"/>
<tt:root name="DATA_I"/>
<tt:template>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Styles>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Center"/>
<Borders/>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="等线" ss:Size="11" x:CharSet="134"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s20">
<Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" ss:Size="11" x:CharSet="134"/>
<NumberFormat ss:Format="@"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s19">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Borders>
<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" ss:Size="11" x:CharSet="134"/>
<NumberFormat ss:Format="@"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s21">
<Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="黑体" ss:Size="12" x:CharSet="134" ss:Bold="1" x:Family="Modern"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s18">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Borders>
<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="黑体" ss:Size="12" x:CharSet="134" ss:Bold="1" x:Family="Modern"/>
<Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s17">
<Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:Size="12" ss:FontName="宋体" x:CharSet="134" ss:Bold="1"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s22">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:Size="18" ss:FontName="宋体" x:CharSet="134"/>
</Style>
</Styles>
<tt:cond check="not-initial(DATA_I)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="一般貿易進口申請表">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="27" ss:ExpandedRowCount="4000" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="46.5" ss:Index="2"/>
<Column ss:Width="76.5"/>
<Column ss:Width="87.75"/>
<Column ss:Width="53.25"/>
<Column ss:Width="88.5" ss:AutoFitWidth="0" ss:Index="6"/>
<Column ss:Width="82.5"/>
<Column ss:Width="40.5"/>
<Column ss:Width="38.25"/>
<Column ss:Width="41.25"/>
<Column ss:Width="53.25"/>
<Column ss:Width="38.25"/>
<Column ss:Width="49.5"/>
<Column ss:Width="49.5"/>
<Column ss:Width="60.75"/>
<Column ss:Width="67.5" ss:AutoFitWidth="0" ss:Index="16"/>
<Column ss:Width="73.5" ss:AutoFitWidth="0" ss:Index="17"/>
<Column ss:Width="104.25" ss:AutoFitWidth="0" ss:Index="18"/>
<Column ss:Width="80.5" ss:AutoFitWidth="0"/>
<Column ss:Width="41.25" ss:AutoFitWidth="0" ss:Index="20"/>
<Column ss:Width="50.5" ss:AutoFitWidth="0" ss:Index="21"/>
<Column ss:Width="50.75" ss:AutoFitWidth="0" ss:Index="22"/>
<Column ss:Width="50.25" ss:AutoFitWidth="0" ss:Index="23"/>
<Column ss:Width="42.5" ss:AutoFitWidth="0" ss:Index="24"/>
<Column ss:Width="50.75" ss:AutoFitWidth="0" ss:Index="25"/>
<Column ss:Width="47.25" ss:AutoFitWidth="0" ss:Index="26"/>
<Column ss:Width="194.5"ss:AutoFitWidth="0" ss:Index="27"/>
<tt:loop ref=".DATA_H">
<Row ss:Height="25.5"ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s22"ss:MergeAcross="12">
<Data ss:Type="String">一般貿易進口申請表</Data>
</Cell>
</Row>
<Row ss:Height="21.5"ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s17">
<!-- <Data ss:Type="String">公司名稱:</Data>-->
<Data ss:Type="String"><tt:value ref="txt1"/></Data>
</Cell>
<Cell ss:Index="8" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請日期:</Data>-->
<Data ss:Type="String"><tt:value ref="txt2"/></Data>-->
</Cell>
<Cell ss:Index="15" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請單號:</Data>-->
<Data ss:Type="String"><tt:value ref="txt3"/></Data>-->
</Cell>
</Row>
<Row ss:Height="21.5"ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請人:</Data>-->
<Data ss:Type="String"><tt:value ref="txt4"/></Data>-->
</Cell>
<Cell ss:Index="8" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請人聯繫方式:</Data>-->
<Data ss:Type="String"><tt:value ref="txt5"/></Data>-->
</Cell>
<Cell ss:Index="15" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請部門代碼及名稱:</Data>-->
<Data ss:Type="String"><tt:value ref="txt6"/></Data>-->
</Cell>
</Row>
<Row ss:Height="21.5"ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s17">
<!-- <Data ss:Type="String">申請表信息:</Data>-->
<Data ss:Type="String"><tt:value ref="txt7"/></Data>-->
</Cell>
</Row>
<Row/>
</tt:loop>
<Row ss:Height="30.5" ss:AutoFitHeight="0">
<Cell ss:Index="2"ss:StyleID="s18"><Data ss:Type="String">序號</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">料號</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">商品編碼</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">CIQ號碼</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">商品品名</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">型號</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">數量</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">單位</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">單價</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">總金額</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">幣別</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">原產國</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">成交方式</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">新舊狀態</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">功能</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">用途</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">工作原理</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">其他</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">關稅稅率</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">關稅金額</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">增值税金额</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">總稅額</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">是否涉證</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">海關監管條件</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">是否涉效能</Data></Cell>
<Cell ss:StyleID="s18"><Data ss:Type="String">申報要素</Data></Cell>
</Row>
<tt:loop ref=".DATA_I">
<!-- <Row ss:Height="100.5" ss:AutoFitHeight="0">-->
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2"ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="num"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="matnr_m"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="taxxcode"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="ciqcode"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="bondmatl"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="addition"/></Data></Cell>
<!-- <Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="poqty_txt"/></Data></Cell>-->
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="poqty_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="oaunit_t"/></Data></Cell>
<!-- <Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="poprice_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="totalamt_txt"/></Data></Cell>-->
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="poprice_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="totalamt_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="currencycode"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="placename"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="incoterm"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="nosta"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="funct"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="usede"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="wrkde"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="othde"/></Data></Cell>
<!-- <Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="tarifrat_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="tarifa_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="valat_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="Number"><tt:value ref="addta_txt"/></Data></Cell>-->
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="tarifrat_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="tarifa_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="valat_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="addta_txt"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="cert_flag"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="cert_code_ttl"/></Data></Cell>
<Cell ss:StyleID="s19"><Data ss:Type="String"><tt:value ref="ee_flag"/></Data></Cell>
<Cell ss:StyleID="s20"><Data ss:Type="String"><tt:value ref="detail_ttl"/></Data></Cell>
</Row>
<!-- <Row/>-->
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
</Workbook>
</tt:template>
</tt:transform>
第二个:
<?sap.transform simple?>
<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">
<tt:root name="OUTPUT"/>
<tt:root name="OUTPUT01"/>
<tt:root name="OUTPUT02"/>
<tt:root name="OUTPUT03"/>
<tt:root name="OUTPUT04"/>
<tt:template>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Styles>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="m10">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
<Borders>
<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#0066CC" ss:FontName="宋体" x:CharSet="134"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="m20">
<Alignment ss:Horizontal="Left" ss:ReadingOrder="LeftToRight" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" x:CharSet="134"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="m30">
<Alignment ss:Horizontal="Left" ss:ReadingOrder="LeftToRight" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" x:CharSet="134"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s110">
<Alignment ss:Horizontal="Left" ss:ReadingOrder="LeftToRight" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" x:CharSet="134"/>
<Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s111">
<Alignment ss:Horizontal="Left" ss:ReadingOrder="LeftToRight" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" x:CharSet="134"/>
</Style>
<Style xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:ID="s112">
<Alignment ss:Horizontal="Left" ss:ReadingOrder="LeftToRight" ss:Vertical="Center" ss:WrapText="1"/>
<Borders>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
<Border ss:Color="#000000" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
</Borders>
<Font xmlns:x="urn:schemas-microsoft-com:office:excel" ss:Color="#000000" ss:FontName="宋体" x:CharSet="134"/>
<NumberFormat ss:Format="0.00%"/>
</Style>
</Styles>
<tt:cond check="not-initial(OUTPUT)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="已結案未結案總攬">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="6" ss:ExpandedRowCount="4000" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="166.5"/>
<Column ss:Width="48"/>
<Column ss:Width="57.75"/>
<Column ss:Width="55.5"/>
<Column ss:Width="57.75"/>
<Column ss:Width="55.5"/>
<tt:loop ref=".OUTPUT">
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="5" ss:StyleID="m10">
<Data ss:Type="String">
<tt:value ref="$ref.mt_depart"/>
</Data>
</Cell>
</Row>
<Row>
<Cell ss:MergeAcross="1" ss:StyleID="m20">
<Data ss:Type="String">處置類型</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">已完成数量</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">占比</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">未完成数量</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">占比</Data>
</Cell>
</Row>
<Row>
<Cell ss:MergeAcross="1" ss:StyleID="m20">
<Data ss:Type="String">服务用机:换新机/周转机</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_10"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_10"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_10"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_10"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="1" ss:StyleID="m20">
<Data ss:Type="String">维修客退:换新机/周转机</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_20"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_20"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_20"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_20"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeDown="2" ss:StyleID="m30">
<Data ss:Type="String">维修客退:一般维修返还(回工厂)</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">保內台責</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_31"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_31"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_31"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_31"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String">保內客責</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_32"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_32"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_32"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_32"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String">保外</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_33"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_33"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_33"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_33"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:MergeDown="2" ss:StyleID="m30">
<Data ss:Type="String">维修客退:一般维修返还(维修站)</Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String">保內台責</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_41"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_41"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_41"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_41"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String">保內客責</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_42"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_42"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_42"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_42"/>
</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String">保外</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_y_43"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_y_43"/>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<Data ss:Type="Number">
<tt:value ref="$ref.cnt_n_43"/>
</Data>
</Cell>
<Cell ss:StyleID="s112">
<Data ss:Type="Number">
<tt:value ref="$ref.prc_n_43"/>
</Data>
</Cell>
</Row>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
<tt:cond check="not-initial(OUTPUT01)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="節點分析(一般維修返還(回工廠))">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="15" ss:ExpandedRowCount="4000" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="100.5"/>
<Column ss:AutoFitWidth="0" ss:Width="41.25" ss:Span="13"/>
<tt:loop ref=".OUTPUT01" name="op01">
<tt:cond check="initial($op01.title_h)">
<tt:loop ref="$op01.info_xx">
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="14" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.dtype_t"/></Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"/>
<Cell ss:StyleID="s110"><Data ss:Type="String">0天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">1天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4--7天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">5周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">6周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">7周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">8周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周以上</Data></Cell>
</Row>
<tt:loop ref="$ref.info">
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"><Data ss:Type="String"><tt:value ref="$ref.col01"/></Data></Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op01.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
</Row>
</tt:loop>
</tt:loop>
</tt:cond>
<tt:cond check="not-initial($op01.title_h)">
<tt:loop ref="$op01.info_xx">
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="14" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.dtype_t"/></Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"/>
<Cell ss:StyleID="s110"><Data ss:Type="String">0天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">1天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4--7天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">5周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">6周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">7周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">8周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周以上</Data></Cell>
</Row>
<tt:loop ref="$ref.info">
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"><Data ss:Type="String"><tt:value ref="$ref.col01"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col02"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col03"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col04"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col05"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col06"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col07"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col08"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col09"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col10"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col11"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col12"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col13"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col14"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col15"/></Data></Cell>
</Row>
</tt:loop>
</tt:loop>
</tt:cond>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
<tt:cond check="not-initial(OUTPUT02)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="節點分析(一般維修返還(維修站))">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="15" ss:ExpandedRowCount="4000" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="48"/>
<Column ss:AutoFitWidth="0" ss:Width="41.25" ss:Span="13"/>
<tt:loop ref=".OUTPUT02" name="op02">
<tt:cond check="initial($op02.title_h)">
<tt:loop ref="$op02.info_xx">
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="14" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.dtype_t"/></Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"/>
<Cell ss:StyleID="s110"><Data ss:Type="String">0天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">1天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4--7天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">5周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">6周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">7周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">8周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周以上</Data></Cell>
</Row>
<tt:loop ref="$ref.info">
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"><Data ss:Type="String"><tt:value ref="$ref.col01"/></Data></Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:attribute name="ss:Formula" value-ref="$op02.formula"/>
<Data ss:Type="Number"></Data>
</Cell>
</Row>
</tt:loop>
</tt:loop>
</tt:cond>
<tt:cond check="not-initial($op02.title_h)">
<tt:loop ref="$op02.info_xx">
<Row ss:AutoFitHeight="0">
<Cell ss:MergeAcross="14" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.dtype_t"/></Data></Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"/>
<Cell ss:StyleID="s110"><Data ss:Type="String">0天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">1天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4--7天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">5周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">6周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">7周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">8周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周以上</Data></Cell>
</Row>
<tt:loop ref="$ref.info">
<Row ss:AutoFitHeight="0">
<Cell ss:StyleID="s110"><Data ss:Type="String"><tt:value ref="$ref.col01"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col02"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col03"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col04"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col05"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col06"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col07"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col08"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col09"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col10"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col11"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col12"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col13"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col14"/></Data></Cell>
<Cell ss:StyleID="s111"><Data ss:Type="Number"><tt:value ref="$ref.col15"/></Data></Cell>
</Row>
</tt:loop>
</tt:loop>
</tt:cond>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
<tt:cond check="not-initial(OUTPUT03)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="未結案數據時效分佈">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="16" ss:ExpandedRowCount="4000" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="166.5"/>
<Column ss:Width="48"/>
<Column ss:AutoFitWidth="0" ss:Width="46.5" ss:Span="13"/>
<tt:loop ref=".OUTPUT03" name="line">
<tt:cond check="initial($line.title_h)">
<Row>
<Cell ss:MergeAcross="15" ss:StyleID="m10"><Data ss:Type="String">未結案數據時效分佈(全國)</Data></Cell>
</Row>
</tt:cond>
<tt:cond check="not-initial($line.title_h)">
<Row>
<Cell ss:MergeAcross="15" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.title_h"/></Data></Cell>
</Row>
</tt:cond>
<Row>
<Cell ss:MergeAcross="1" ss:StyleID="m20"><Data ss:Type="String">處置類型</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">0天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">1天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4--7天</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">2周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">3周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">4周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">5周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">6周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">7周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">8周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周</Data></Cell>
<Cell ss:StyleID="s110"><Data ss:Type="String">9周以上</Data></Cell>
</Row>
<tt:loop ref="$line.info_w">
<Row>
<tt:cond check="not-initial($ref.col01)">
<tt:cond check="initial($ref.col02)">
<Cell ss:MergeAcross="1" ss:StyleID="m20">
<Data ss:Type="String"><tt:value ref="$ref.col01"/></Data>
</Cell>
</tt:cond>
</tt:cond>
<tt:cond check="not-initial($ref.col01)">
<tt:cond check="not-initial($ref.col02)">
<Cell ss:MergeDown="2" ss:StyleID="m30">
<Data ss:Type="String"><tt:value ref="$ref.col01"/></Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String"><tt:value ref="$ref.col02"/></Data>
</Cell>
</tt:cond>
</tt:cond>
<tt:cond check="initial($ref.col01)">
<tt:cond check="not-initial($ref.col02)">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String"><tt:value ref="$ref.col02"/></Data>
</Cell>
</tt:cond>
</tt:cond>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col03"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col04"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col05"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col06"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col07"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col08"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col09"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col10"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col11"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col12"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col13"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col14"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col15"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="initial($line.title_h)">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="not-initial($line.title_h)">
<tt:value ref="$ref.col16"/>
</tt:cond>
</Data>
</Cell>
</Row>
</tt:loop>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
<tt:cond check="not-initial(OUTPUT04)">
<Worksheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" ss:Name="未結案狀態分佈表">
<Table xmlns:x="urn:schemas-microsoft-com:office:excel" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5" ss:ExpandedColumnCount="9" ss:ExpandedRowCount="400" x:FullColumns="1" x:FullRows="1">
<Column ss:Width="78.75"/>
<Column ss:Width="104.25"/>
<Column ss:Width="118.5"/>
<Column ss:Width="61.5" ss:Span="5"/>
<tt:loop ref=".OUTPUT04" name="line">
<Row>
<Cell ss:MergeAcross="8" ss:StyleID="m10"><Data ss:Type="String"><tt:value ref="$ref.title_h"/></Data></Cell>
</Row>
<Row>
<tt:loop ref="$line.col_ctxt">
<Cell ss:StyleID="s110"><Data ss:Type="String"><tt:value ref="$ref.ctxt"/></Data></Cell>
</tt:loop>
</Row>
<tt:loop ref="$line.info_s">
<Row>
<tt:cond check="not-initial($ref.col01)">
<tt:cond check="not-initial($ref.col02)">
<Cell ss:StyleID="m30">
<tt:attribute name="ss:MergeDown" value-ref="$ref.flg"/>
<Data ss:Type="String"><tt:value ref="$ref.col01"/></Data>
</Cell>
<Cell ss:StyleID="s110">
<Data ss:Type="String"><tt:value ref="$ref.col02"/></Data>
</Cell>
</tt:cond>
</tt:cond>
<tt:cond check="initial($ref.col01)">
<tt:cond check="not-initial($ref.col02)">
<Cell ss:Index="2" ss:StyleID="s110">
<Data ss:Type="String"><tt:value ref="$ref.col02"/></Data>
</Cell>
</tt:cond>
</tt:cond>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col03"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col04"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col05"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col06"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col07"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col08"/>
</tt:cond>
</Data>
</Cell>
<Cell ss:StyleID="s111">
<tt:cond check="$line.mt_deptcd = 'ALL'">
<tt:attribute name="ss:Formula" value-ref="$line.formula">
</tt:attribute>
</tt:cond>
<Data ss:Type="Number">
<tt:cond check="$line.mt_deptcd != 'ALL'">
<tt:value ref="$ref.col09"/>
</tt:cond>
</Data>
</Cell>
</Row>
</tt:loop>
<Row/>
</tt:loop>
</Table>
</Worksheet>
</tt:cond>
</Workbook>
</tt:template>
</tt:transform>