execl导出业务定制化导出方案

博主： jiliangliang
发布时间：2022 年 08 月 05 日
1583 次浏览
暂无评论
20494字数
分类：亚洲渔港学习内容

思路：将execl文件编辑好格式后然后保存成xml格式然后进行替换xml文件中的字符串然后在将xml格式文件转化成execl

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook
    xmlns="urn:schemas-microsoft-com:office:spreadsheet"
    xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
    xmlns:html="http://www.w3.org/TR/REC-html40"
    xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882">
    <DocumentProperties
        xmlns="urn:schemas-microsoft-com:office:office">
        <Author>liuhaibo</Author>
        <LastAuthor>司空如风</LastAuthor>
        <Created>2017-05-27T08:35:16Z</Created>
        <LastSaved>2022-08-04T18:04:24Z</LastSaved>
    </DocumentProperties>
    <CustomDocumentProperties
        xmlns="urn:schemas-microsoft-com:office:office">
        <KSOProductBuildVer dt:dt="string">2052-4.1.1.6630</KSOProductBuildVer>
        <ICV dt:dt="string">1D4475DC3BEDB418A899EB62E41D67DB</ICV>
    </CustomDocumentProperties>
    <OfficeDocumentSettings
        xmlns="urn:schemas-microsoft-com:office:office">
        <Colors>
            <Color>
                <Index>2</Index>
                <RGB>#FFF909</RGB>
            </Color>
        </Colors>
    </OfficeDocumentSettings>
    <ExcelWorkbook
        xmlns="urn:schemas-microsoft-com:office:excel">
        <WindowHeight>16960</WindowHeight>
        <ProtectStructure>False</ProtectStructure>
        <ProtectWindows>False</ProtectWindows>
    </ExcelWorkbook>
    <Styles>
        <Style ss:ID="Default" ss:Name="Normal">
            <Alignment ss:Vertical="Bottom"/>
            <Borders/>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <NumberFormat/>
        </Style>
        <Style ss:ID="s49">
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s50">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s51">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s52">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s53">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s54">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="黑体" x:CharSet="0" x:Family="Modern" ss:Size="20" ss:Color="#000000"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s55">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s56">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s57">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s58">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s59">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s60">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s61">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s62">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s63">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s64">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s65">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s66">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s67">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s68">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s69">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s70">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s71">
            <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s72">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s73">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s74">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s75">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s76">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s77">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s78">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s79">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s80">
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s81">
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s82">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s83">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s84">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s85">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s86">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s87">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s88">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s89">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s90">
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s91">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s92">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s93">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s94">
            <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s95">
            <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s96">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s97">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s98">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s99">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <NumberFormat ss:Format="Short Date"/>
            <Protection/>
        </Style>
        <Style ss:ID="s100">
            <Interior/>
            <NumberFormat ss:Format="Short Date"/>
            <Protection/>
        </Style>
        <Style ss:ID="s101">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s102">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s103">
            <Alignment ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s104">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="黑体" x:CharSet="0" x:Family="Modern" ss:Size="20" ss:Color="#000000"/>
            <Interior ss:Color="#D9D9D9" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s105">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s106">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s107">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s108">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s109">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s110">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s111">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s112">
            <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s113">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s114">
            <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s115">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s116">
            <Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s117">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s118">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s119">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s120">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/>
            <Protection/>
        </Style>
        <Style ss:ID="s121">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s122">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s123">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s124">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s125">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s126">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s127">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s128">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="Calibri" x:CharSet="0" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s129">
            <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
            <Borders>
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
            </Borders>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s130">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s131">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
        <Style ss:ID="s132">
            <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
            <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>
            <Interior/>
            <Protection/>
        </Style>
    </Styles>
    <Worksheet ss:Name="订货确认单">
        <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="40" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="57.6" ss:DefaultRowHeight="14">
            <Column ss:Index="1" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="76.8" />
            <Column ss:Index="2" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="215.75" />
            <Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="170.05" />
            <Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="135.3" />
            <Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="159.1" />
            <Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="87.75" />
            <Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="73.15" />
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s50">
                    <Data ss:Type="String">网址：</Data>
                </Cell>
                <Cell ss:StyleID="s103" ss:MergeAcross="5" />
            </Row>
            <Row ss:Height="20.8">
                <Cell ss:StyleID="s104" ss:MergeAcross="6">
                    <Data ss:Type="String">订 货 确 认 单</Data>
                </Cell>
            </Row>
            <Row ss:Height="17">
                <Cell ss:StyleID="s56">
                    <ss:Data ss:Type="String"
                        xmlns="http://www.w3.org/TR/REC-html40">
                        <B>
                            <Font x:Family="Swiss" html:Color="#000000"></Font>
                            <Font html:Face="宋体" x:CharSet="134" html:Color="#000000">订单编号：</Font>
                        </B>
                    </ss:Data>
                </Cell>
                <Cell ss:StyleID="s105" ss:MergeAcross="2">
                    <ss:Data ss:Type="String"
                        xmlns="http://www.w3.org/TR/REC-html40">
                        <Font x:Family="Swiss" html:Color="#000000">[%%order_id%%] </Font>
                    </ss:Data>
                </Cell>
                <Cell ss:StyleID="s82">
                    <Data ss:Type="String">运输方式：</Data>
                </Cell>
                <Cell ss:StyleID="s106" ss:MergeAcross="1">
                    <Data ss:Type="String">低温运输</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s50">
                    <Data ss:Type="String">客户名称：</Data>
                </Cell>
                <Cell ss:StyleID="s107" ss:MergeAcross="5">
                    <Data ss:Type="String">%%customer_name%%</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s59">
                    <Data ss:Type="String">联系人：</Data>
                </Cell>
                <Cell ss:StyleID="s57">
                    <Data ss:Type="String">%%name%%</Data>
                </Cell>
                <Cell ss:StyleID="s50">
                    <Data ss:Type="String">联系电话：</Data>
                </Cell>
                <Cell ss:StyleID="s60">
                    <Data ss:Type="String">%%mobile%%</Data>
                </Cell>
                <Cell ss:StyleID="s85" />
                <Cell ss:StyleID="s85" />
                <Cell ss:StyleID="s86" />
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s59">
                    <Data ss:Type="String">送货地址：</Data>
                </Cell>
                <Cell ss:StyleID="s108" ss:MergeAcross="5">
                    <Data ss:Type="String">%%address%%</Data>
                </Cell>
            </Row>
            <Row>
                <Cell ss:StyleID="s63">
                    <Data ss:Type="String">编号</Data>
                </Cell>
                <Cell ss:StyleID="s63">
                    <Data ss:Type="String">品名</Data>
                </Cell>
                <Cell ss:StyleID="s63">
                    <Data ss:Type="String">规格</Data>
                </Cell>
                <Cell ss:StyleID="s64">
                    <Data ss:Type="String">数量</Data>
                </Cell>
                <Cell ss:StyleID="s64">
                    <Data ss:Type="String">单价</Data>
                </Cell>
                <Cell ss:StyleID="s109" ss:MergeAcross="1">
                    <Data ss:Type="String">总额</Data>
                </Cell>
            </Row>
    %%products%%

            <Row ss:Height="16.8">
                <Cell ss:StyleID="s111" ss:MergeAcross="1">
                    <Data ss:Type="String">产品总价：%%price%%</Data>
                </Cell>
                <Cell ss:StyleID="s69">
                    <Data ss:Type="String">折扣：%%rebate%%</Data>
                </Cell>
                <Cell ss:StyleID="s69">
                    <Data ss:Type="String">运费：%%freight%%</Data>
                </Cell>
                <Cell ss:StyleID="s112" ss:MergeAcross="2">
                    <Data ss:Type="String">总价：%%totalprice%%</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s113" ss:MergeAcross="2">
                    <Data ss:Type="String">件：%%jian%%</Data>
                </Cell>
                <Cell ss:StyleID="s114" ss:MergeAcross="3">
                    <Data ss:Type="String">散：%%san%%</Data>
                </Cell>
            </Row>
            <Row ss:Height="17">
                <Cell ss:StyleID="s115" ss:MergeAcross="6">
                    <ss:Data ss:Type="String"
                        xmlns="http://www.w3.org/TR/REC-html40">
                        <B>
                            <Font html:Color="#000000">%%pay_flg_name%%</Font>
                        </B>
                    </ss:Data>
                </Cell>
            </Row>
            <Row ss:Index="18" ss:Height="16.8">
                <Cell ss:StyleID="s116" ss:MergeAcross="2">
                    <Data ss:Type="String">*上述产品预计款到一周左右到货，请注意我们的《装柜通知》</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s75" />
                <Cell ss:StyleID="s75" />
                <Cell ss:StyleID="s75" />
            </Row>
  
            <Row ss:Index="26">
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
                <Cell ss:Index="5" ss:StyleID="s130" ss:MergeAcross="1">
                    <Data ss:Type="String">销售支持助理：</Data>
                </Cell>
                <Cell ss:StyleID="s98">
                    <Data ss:Type="String">%%ssname%%</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s81" />
                <Cell ss:StyleID="s81" />
                <Cell ss:Index="5" ss:StyleID="s131" ss:MergeAcross="1">
                    <Data ss:Type="String">填制日期：</Data>
                </Cell>
                <Cell ss:StyleID="s99">
                    <Data ss:Type="String">%%now_date%%</Data>
                </Cell>
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:Index="5" ss:StyleID="s132" ss:MergeAcross="1" />
                <Cell ss:StyleID="s99" />
            </Row>
            <Row>
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
            </Row>
            <Row>
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s81" />
                <Cell ss:StyleID="s81" />
            </Row>
            <Row ss:Index="34">
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
            </Row>
            <Row>
                <Cell ss:StyleID="s80" />
                <Cell ss:StyleID="s80" />
            </Row>
            <Row ss:Height="16.8">
                <Cell ss:StyleID="s81" />
                <Cell ss:StyleID="s81" />
            </Row>
            <Row ss:Index="38" ss:Height="16.8">
                <Cell ss:Index="5" ss:StyleID="s81" />
            </Row>
            <Row ss:Index="40">
                <Cell ss:Index="5" ss:StyleID="s100" />
            </Row>
        </Table>
        <WorksheetOptions
            xmlns="urn:schemas-microsoft-com:office:excel">
            <PageSetup>
                <Header x:Margin="0.3" />
                <Footer x:Margin="0.3" />
                <PageMargins x:Left="0.7" x:Right="0.7" x:Top="0.75" x:Bottom="0.75" />
            </PageSetup>
            <Print>
                <ValidPrinterInfo />
                <PaperSizeIndex>1</PaperSizeIndex>
                <HorizontalResolution>600</HorizontalResolution>
                <VerticalResolution>600</VerticalResolution>
            </Print>
            <Selected />
            <TopRowVisible>0</TopRowVisible>
            <LeftColumnVisible>0</LeftColumnVisible>
            <DoNotDisplayGridlines />
            <Panes>
                <Pane>
                    <Number>3</Number>
                    <ActiveRow>3</ActiveRow>
                    <ActiveCol>1</ActiveCol>
                    <RangeSelection>R4C2:R4C7</RangeSelection>
                </Pane>
            </Panes>
            <ProtectObjects>False</ProtectObjects>
            <ProtectScenarios>False</ProtectScenarios>
            <AllowFormatCells />
            <AllowSizeCols />
            <AllowSizeRows />
            <AllowInsertRows />
            <AllowInsertCols />
            <AllowInsertHyperlinks />
            <AllowDeleteCols />
            <AllowDeleteRows />
            <AllowSort />
            <AllowFilter />
            <AllowUsePivotTables />
        </WorksheetOptions>
    </Worksheet>
</Workbook>

$orderSaReplace = [
            "order_id" => $orderSaVO['order_id'], //订单编号
            "customer_name" => $orderSaVO['customer']['shortname'], //客户名称
            "name" => $orderSaVO['delivery']['name'],
            "mobile" => $orderSaVO['delivery']['mobile'],
            "address" => $orderSaVO['delivery']['address'],
            "price" => NumberUtility::priceDecimalPoint($orderSaVO['price'], 2),
            "rebate" => NumberUtility::priceDecimalPoint((float)$orderSaVO['rebate_price'] + (float)$orderSaVO['discount_price'], 2), //折扣
            "freight" => NumberUtility::priceDecimalPoint($orderSaVO['freight'], 2),//运费
            "ap_price" => NumberUtility::priceDecimalPoint($orderSaVO['ap_price'], 2),//
            "totalprice" => NumberUtility::priceDecimalPoint($orderSaVO['totalprice'], 2),//总价
            "pay_flg_name" => $orderSaVO['pay_flg'] > 0 ? "已结款" : "未结款",
            "jian" => $orderSaVO['jian'],
            "san" => $orderSaVO['san'],
            "ssname" => $customer['ss_name'],
            "now_date" => date("Y-m-d"),
        ];

        $productsXml = "";
        foreach ($orderSaVO['order_sa_pros'] as $val) {
            $price = (float)$val['after_ask_price'] > 0 ? (float)$val['after_ask_price'] : (float)$val['before_ask_price'] > 0 ? (float)$val['before_ask_price'] : (float)$val['price'];
            $totalprice = (float)$price * (float)$val['pcount'];
            $price = NumberUtility::priceDecimalPoint($price, 2); //单价
            $totalprice = NumberUtility::priceDecimalPoint($totalprice, 2); //总额

            $productsXml .= "
                <Row>
                    <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">{$val['pno']}</Data></Cell>
                    <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">{$val['product_name']}</Data></Cell>
                    <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">{$val['guige']}</Data></Cell>
                    <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">{$val['pcount']}</Data></Cell>
                    <Cell ss:StyleID=\"s65\"><Data ss:Type=\"String\">{$price}</Data></Cell>
                    <Cell ss:StyleID=\"s110\" ss:MergeAcross=\"1\"><Data ss:Type=\"String\">{$totalprice}</Data></Cell>
                </Row>
            ";
        }
        $orderSaReplace['products'] = $productsXml;


        $execlDir = EASYSWOOLE_ROOT . "/App/Module/Export/execl/";
        //读取文件 读的方式
        $fileSource = fopen($execlDir . "saorder.xml", "r");

        //从文件中读取内容
        $bufferAll = "";
        while (true) {
            $buffer = fread($fileSource, 512);
            $bufferAll .= $buffer;
            if (superEmpty($buffer)) {
                break; //读完就跳出循环
            }
        }

        fclose($fileSource);

        //循环替换字符
        foreach ($orderSaReplace as $key => $value) {
            $bufferAll = str_replace("%%$key%%", $value, $bufferAll); //替换产品
        }

        //读写方式打开一个 execl 空的文件
        $filePath = config('TEMP_DIR');
        $fileName = Random::makeUUIDV4() . ".xlsx";

        $newFileSource = fopen($filePath . "/" . $fileName, "a+");
        //把替换好的内容写到execl中
        fwrite($newFileSource, $bufferAll);
        fclose($newFileSource);

最后修改：2022 年 08 月 23 日

如果觉得我的文章对你有用，请随意赞赏

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

评论 *

私密评论

名称 *

🎲

邮箱 *

地址

execl导出业务定制化导出方案

jiliangliang • 2022 年 08 月 05 日

<p>思路：将execl文件编辑好格式后然后保存成xml格式 然后进行替换xml文件中的字符串 然后在将xml格式文件转化成execl</p><p><img src="https://cdn.7b620.cn/2022/08/3432131583.png" alt="image.png" title="image.png"style=""></p><pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; standalone=&quot;yes&quot;?&gt;
&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;
&lt;Workbook
    xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
    xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;
    xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
    xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
    xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;
    xmlns:dt=&quot;uuid:C2F41010-65B3-11d1-A29F-00AA00C14882&quot;&gt;
    &lt;DocumentProperties
        xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;
        &lt;Author&gt;liuhaibo&lt;/Author&gt;
        &lt;LastAuthor&gt;司空如风&lt;/LastAuthor&gt;
        &lt;Created&gt;2017-05-27T08:35:16Z&lt;/Created&gt;
        &lt;LastSaved&gt;2022-08-04T18:04:24Z&lt;/LastSaved&gt;
    &lt;/DocumentProperties&gt;
    &lt;CustomDocumentProperties
        xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;
        &lt;KSOProductBuildVer dt:dt=&quot;string&quot;&gt;2052-4.1.1.6630&lt;/KSOProductBuildVer&gt;
        &lt;ICV dt:dt=&quot;string&quot;&gt;1D4475DC3BEDB418A899EB62E41D67DB&lt;/ICV&gt;
    &lt;/CustomDocumentProperties&gt;
    &lt;OfficeDocumentSettings
        xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;
        &lt;Colors&gt;
            &lt;Color&gt;
                &lt;Index&gt;2&lt;/Index&gt;
                &lt;RGB&gt;#FFF909&lt;/RGB&gt;
            &lt;/Color&gt;
        &lt;/Colors&gt;
    &lt;/OfficeDocumentSettings&gt;
    &lt;ExcelWorkbook
        xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;
        &lt;WindowHeight&gt;16960&lt;/WindowHeight&gt;
        &lt;ProtectStructure&gt;False&lt;/ProtectStructure&gt;
        &lt;ProtectWindows&gt;False&lt;/ProtectWindows&gt;
    &lt;/ExcelWorkbook&gt;
    &lt;Styles&gt;
        &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders/&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;NumberFormat/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s49&quot;&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s50&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s51&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s52&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s53&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s54&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;黑体&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Modern&quot; ss:Size=&quot;20&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s55&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s56&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s57&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s58&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s59&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s60&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s61&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s62&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s63&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s64&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s65&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s66&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s67&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s68&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s69&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s70&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s71&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Center&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s72&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s73&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s74&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s75&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s76&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s77&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s78&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s79&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s80&quot;&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s81&quot;&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s82&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s83&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s84&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s85&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s86&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s87&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s88&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s89&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s90&quot;&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s91&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s92&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s93&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s94&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Center&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s95&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Center&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s96&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s97&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s98&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s99&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;NumberFormat ss:Format=&quot;Short Date&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s100&quot;&gt;
            &lt;Interior/&gt;
            &lt;NumberFormat ss:Format=&quot;Short Date&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s101&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s102&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s103&quot;&gt;
            &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s104&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;黑体&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Modern&quot; ss:Size=&quot;20&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior ss:Color=&quot;#D9D9D9&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s105&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s106&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s107&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s108&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s109&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s110&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s111&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s112&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Center&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s113&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s114&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Center&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s115&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot; ss:Color=&quot;#000000&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s116&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Left&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s117&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s118&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s119&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s120&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior ss:Color=&quot;#DBDBDB&quot; ss:Pattern=&quot;Solid&quot;/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s121&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s122&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s123&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s124&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s125&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s126&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s127&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s128&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;Calibri&quot; x:CharSet=&quot;0&quot; x:Family=&quot;Swiss&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s129&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Borders&gt;
                &lt;Border ss:Position=&quot;Bottom&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Left&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Right&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
                &lt;Border ss:Position=&quot;Top&quot; ss:LineStyle=&quot;Continuous&quot; ss:Weight=&quot;1&quot;/&gt;
            &lt;/Borders&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s130&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s131&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
        &lt;Style ss:ID=&quot;s132&quot;&gt;
            &lt;Alignment ss:Horizontal=&quot;Right&quot; ss:Vertical=&quot;Bottom&quot;/&gt;
            &lt;Font ss:FontName=&quot;宋体&quot; x:CharSet=&quot;134&quot; ss:Size=&quot;11&quot; ss:Color=&quot;#000000&quot; ss:Bold=&quot;1&quot;/&gt;
            &lt;Interior/&gt;
            &lt;Protection/&gt;
        &lt;/Style&gt;
    &lt;/Styles&gt;
    &lt;Worksheet ss:Name=&quot;订货确认单&quot;&gt;
        &lt;Table ss:ExpandedColumnCount=&quot;7&quot; ss:ExpandedRowCount=&quot;40&quot; x:FullColumns=&quot;1&quot; x:FullRows=&quot;1&quot; ss:DefaultColumnWidth=&quot;57.6&quot; ss:DefaultRowHeight=&quot;14&quot;&gt;
            &lt;Column ss:Index=&quot;1&quot; ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;76.8&quot; /&gt;
            &lt;Column ss:Index=&quot;2&quot; ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;215.75&quot; /&gt;
            &lt;Column ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;170.05&quot; /&gt;
            &lt;Column ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;135.3&quot; /&gt;
            &lt;Column ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;159.1&quot; /&gt;
            &lt;Column ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;87.75&quot; /&gt;
            &lt;Column ss:StyleID=&quot;s49&quot; ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;73.15&quot; /&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s50&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;网址：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s103&quot; ss:MergeAcross=&quot;5&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;20.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s104&quot; ss:MergeAcross=&quot;6&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;订 货 确 认 单&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;17&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s56&quot;&gt;
                    &lt;ss:Data ss:Type=&quot;String&quot;
                        xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;
                        &lt;B&gt;
                            &lt;Font x:Family=&quot;Swiss&quot; html:Color=&quot;#000000&quot;&gt;&lt;/Font&gt;
                            &lt;Font html:Face=&quot;宋体&quot; x:CharSet=&quot;134&quot; html:Color=&quot;#000000&quot;&gt;订单编号：&lt;/Font&gt;
                        &lt;/B&gt;
                    &lt;/ss:Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s105&quot; ss:MergeAcross=&quot;2&quot;&gt;
                    &lt;ss:Data ss:Type=&quot;String&quot;
                        xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;
                        &lt;Font x:Family=&quot;Swiss&quot; html:Color=&quot;#000000&quot;&gt;[%%order_id%%] &lt;/Font&gt;
                    &lt;/ss:Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s82&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;运输方式：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s106&quot; ss:MergeAcross=&quot;1&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;低温运输&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s50&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;客户名称：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s107&quot; ss:MergeAcross=&quot;5&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%customer_name%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s59&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;联系人：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s57&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%name%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s50&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;联系电话：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s60&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%mobile%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s85&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s85&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s86&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s59&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;送货地址：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s108&quot; ss:MergeAcross=&quot;5&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%address%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row&gt;
                &lt;Cell ss:StyleID=&quot;s63&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;编号&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s63&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;品名&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s63&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;规格&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s64&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;数量&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s64&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;单价&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s109&quot; ss:MergeAcross=&quot;1&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;总额&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
    %%products%%

&lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s111&quot; ss:MergeAcross=&quot;1&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;产品总价：%%price%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s69&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;折扣：%%rebate%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s69&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;运费：%%freight%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s112&quot; ss:MergeAcross=&quot;2&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;总价：%%totalprice%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s113&quot; ss:MergeAcross=&quot;2&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;件：%%jian%%&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s114&quot; ss:MergeAcross=&quot;3&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;散：%%san%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;17&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s115&quot; ss:MergeAcross=&quot;6&quot;&gt;
                    &lt;ss:Data ss:Type=&quot;String&quot;
                        xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;
                        &lt;B&gt;
                            &lt;Font html:Color=&quot;#000000&quot;&gt;%%pay_flg_name%%&lt;/Font&gt;
                        &lt;/B&gt;
                    &lt;/ss:Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Index=&quot;18&quot; ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s116&quot; ss:MergeAcross=&quot;2&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;*上述产品预计款到一周左右到货，请注意我们的《装柜通知》&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s75&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s75&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s75&quot; /&gt;
            &lt;/Row&gt;
  
            &lt;Row ss:Index=&quot;26&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:Index=&quot;5&quot; ss:StyleID=&quot;s130&quot; ss:MergeAcross=&quot;1&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;销售支持助理：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s98&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%ssname%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
                &lt;Cell ss:Index=&quot;5&quot; ss:StyleID=&quot;s131&quot; ss:MergeAcross=&quot;1&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;填制日期：&lt;/Data&gt;
                &lt;/Cell&gt;
                &lt;Cell ss:StyleID=&quot;s99&quot;&gt;
                    &lt;Data ss:Type=&quot;String&quot;&gt;%%now_date%%&lt;/Data&gt;
                &lt;/Cell&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:Index=&quot;5&quot; ss:StyleID=&quot;s132&quot; ss:MergeAcross=&quot;1&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s99&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Index=&quot;34&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s80&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
                &lt;Cell ss:StyleID=&quot;s81&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Index=&quot;38&quot; ss:Height=&quot;16.8&quot;&gt;
                &lt;Cell ss:Index=&quot;5&quot; ss:StyleID=&quot;s81&quot; /&gt;
            &lt;/Row&gt;
            &lt;Row ss:Index=&quot;40&quot;&gt;
                &lt;Cell ss:Index=&quot;5&quot; ss:StyleID=&quot;s100&quot; /&gt;
            &lt;/Row&gt;
        &lt;/Table&gt;
        &lt;WorksheetOptions
            xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;
            &lt;PageSetup&gt;
                &lt;Header x:Margin=&quot;0.3&quot; /&gt;
                &lt;Footer x:Margin=&quot;0.3&quot; /&gt;
                &lt;PageMargins x:Left=&quot;0.7&quot; x:Right=&quot;0.7&quot; x:Top=&quot;0.75&quot; x:Bottom=&quot;0.75&quot; /&gt;
            &lt;/PageSetup&gt;
            &lt;Print&gt;
                &lt;ValidPrinterInfo /&gt;
                &lt;PaperSizeIndex&gt;1&lt;/PaperSizeIndex&gt;
                &lt;HorizontalResolution&gt;600&lt;/HorizontalResolution&gt;
                &lt;VerticalResolution&gt;600&lt;/VerticalResolution&gt;
            &lt;/Print&gt;
            &lt;Selected /&gt;
            &lt;TopRowVisible&gt;0&lt;/TopRowVisible&gt;
            &lt;LeftColumnVisible&gt;0&lt;/LeftColumnVisible&gt;
            &lt;DoNotDisplayGridlines /&gt;
            &lt;Panes&gt;
                &lt;Pane&gt;
                    &lt;Number&gt;3&lt;/Number&gt;
                    &lt;ActiveRow&gt;3&lt;/ActiveRow&gt;
                    &lt;ActiveCol&gt;1&lt;/ActiveCol&gt;
                    &lt;RangeSelection&gt;R4C2:R4C7&lt;/RangeSelection&gt;
                &lt;/Pane&gt;
            &lt;/Panes&gt;
            &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;
            &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;
            &lt;AllowFormatCells /&gt;
            &lt;AllowSizeCols /&gt;
            &lt;AllowSizeRows /&gt;
            &lt;AllowInsertRows /&gt;
            &lt;AllowInsertCols /&gt;
            &lt;AllowInsertHyperlinks /&gt;
            &lt;AllowDeleteCols /&gt;
            &lt;AllowDeleteRows /&gt;
            &lt;AllowSort /&gt;
            &lt;AllowFilter /&gt;
            &lt;AllowUsePivotTables /&gt;
        &lt;/WorksheetOptions&gt;
    &lt;/Worksheet&gt;
&lt;/Workbook&gt;</code></pre><pre><code>$orderSaReplace = [
            &quot;order_id&quot; =&gt; $orderSaVO['order_id'], //订单编号
            &quot;customer_name&quot; =&gt; $orderSaVO['customer']['shortname'], //客户名称
            &quot;name&quot; =&gt; $orderSaVO['delivery']['name'],
            &quot;mobile&quot; =&gt; $orderSaVO['delivery']['mobile'],
            &quot;address&quot; =&gt; $orderSaVO['delivery']['address'],
            &quot;price&quot; =&gt; NumberUtility::priceDecimalPoint($orderSaVO['price'], 2),
            &quot;rebate&quot; =&gt; NumberUtility::priceDecimalPoint((float)$orderSaVO['rebate_price'] + (float)$orderSaVO['discount_price'], 2), //折扣
            &quot;freight&quot; =&gt; NumberUtility::priceDecimalPoint($orderSaVO['freight'], 2),//运费
            &quot;ap_price&quot; =&gt; NumberUtility::priceDecimalPoint($orderSaVO['ap_price'], 2),//
            &quot;totalprice&quot; =&gt; NumberUtility::priceDecimalPoint($orderSaVO['totalprice'], 2),//总价
            &quot;pay_flg_name&quot; =&gt; $orderSaVO['pay_flg'] &gt; 0 ? &quot;已结款&quot; : &quot;未结款&quot;,
            &quot;jian&quot; =&gt; $orderSaVO['jian'],
            &quot;san&quot; =&gt; $orderSaVO['san'],
            &quot;ssname&quot; =&gt; $customer['ss_name'],
            &quot;now_date&quot; =&gt; date(&quot;Y-m-d&quot;),
        ];

$productsXml = &quot;&quot;;
        foreach ($orderSaVO['order_sa_pros'] as $val) {
            $price = (float)$val['after_ask_price'] &gt; 0 ? (float)$val['after_ask_price'] : (float)$val['before_ask_price'] &gt; 0 ? (float)$val['before_ask_price'] : (float)$val['price'];
            $totalprice = (float)$price * (float)$val['pcount'];
            $price = NumberUtility::priceDecimalPoint($price, 2); //单价
            $totalprice = NumberUtility::priceDecimalPoint($totalprice, 2); //总额

$productsXml .= &quot;
                &lt;Row&gt;
                    &lt;Cell ss:StyleID=\&quot;s65\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$val['pno']}&lt;/Data&gt;&lt;/Cell&gt;
                    &lt;Cell ss:StyleID=\&quot;s65\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$val['product_name']}&lt;/Data&gt;&lt;/Cell&gt;
                    &lt;Cell ss:StyleID=\&quot;s65\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$val['guige']}&lt;/Data&gt;&lt;/Cell&gt;
                    &lt;Cell ss:StyleID=\&quot;s65\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$val['pcount']}&lt;/Data&gt;&lt;/Cell&gt;
                    &lt;Cell ss:StyleID=\&quot;s65\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$price}&lt;/Data&gt;&lt;/Cell&gt;
                    &lt;Cell ss:StyleID=\&quot;s110\&quot; ss:MergeAcross=\&quot;1\&quot;&gt;&lt;Data ss:Type=\&quot;String\&quot;&gt;{$totalprice}&lt;/Data&gt;&lt;/Cell&gt;
                &lt;/Row&gt;
            &quot;;
        }
        $orderSaReplace['products'] = $productsXml;

$execlDir = EASYSWOOLE_ROOT . &quot;/App/Module/Export/execl/&quot;;
        //读取文件 读的方式
        $fileSource = fopen($execlDir . &quot;saorder.xml&quot;, &quot;r&quot;);

//从文件中读取内容
        $bufferAll = &quot;&quot;;
        while (true) {
            $buffer = fread($fileSource, 512);
            $bufferAll .= $buffer;
            if (superEmpty($buffer)) {
                break; //读完就跳出循环
            }
        }

fclose($fileSource);

//循环替换字符
        foreach ($orderSaReplace as $key =&gt; $value) {
            $bufferAll = str_replace(&quot;%%$key%%&quot;, $value, $bufferAll); //替换产品
        }

//读写方式打开一个 execl 空的文件
        $filePath = config('TEMP_DIR');
        $fileName = Random::makeUUIDV4() . &quot;.xlsx&quot;;

$newFileSource = fopen($filePath . &quot;/&quot; . $fileName, &quot;a+&quot;);
        //把替换好的内容写到execl中
        fwrite($newFileSource, $bufferAll);
        fclose($newFileSource);</code></pre>

execl导出业务定制化导出方案

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

Typocho 评论时发送邮件

JS 用html2canvas.js将HTML页面转换成图片 2020 04 23 增加兼容ie

SiteCrafting Compared Five PHP Template Engines and Selected a Winner to Adopt.

夯实基础：网络知识总结

php常驻内存那些事

Mybatis笔记四：nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'xxxx' in 'class xxxxxx'

java 练习

两个人分锅粥，为公平，应该一个人分另一个人先选三个人呢？四个人呢？怎么分无论他们之间怎样串通都是

php的运行模式 -php-fpm

关于synchronized、wait、notify已经notifyAll的使用

execl导出业务定制化导出方案

发表评论 取消回复 使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

execl导出业务 定制化导出方案

发表评论取消回复
使用cookie技术保留您的个人信息以便您下次快速评论，继续评论表示您已同意该条款

execl导出业务定制化导出方案