SAP 使用STRANS以XML格式导出EXCEL-摩杜云开发者社区

1.准备EXCEL模板并另存为XML EXCEL

SAP 使用STRANS以XML格式导出EXCEL_XML

SAP 使用STRANS以XML格式导出EXCEL_Data_02

2.创建SAP TRANSFORMATION

事务代码：STRANS

3.导入XML EXCEL并创建入参结构和表

导入XML EXCEL

复制XML EXCEL数据（忽略第一行）到SAP TRANSFORMATION template之间

SAP 使用STRANS以XML格式导出EXCEL_XML_03

创建导入结构和表

切换到图形编辑模式
导入结构参数
表结构参数（创建后效果）

4.修改XML EXCEL以入参变量传参

抬头：

将：
<tt:text>部门1</tt:text>
<tt:text>部门2</tt:text>
<tt:text>部门3</tt:text>
<tt:text>部门4</tt:text>
<tt:text>部门5</tt:text>
<tt:text>部门6</tt:text>
替换为：
<tt:value ref="HEADER.ZPAR1"/>
<tt:value ref="HEADER.ZPAR2"/>
<tt:value ref="HEADER.ZPAR3"/>
<tt:value ref="HEADER.ZPAR4"/>
<tt:value ref="HEADER.ZPAR5"/>
<tt:value ref="HEADER.ZPAR6"/>

SAP 使用STRANS以XML格式导出EXCEL_xml_04

项目：

将：
           <Row ss:AutoFitHeight="0" ss:Height="24.5">
            <Cell ss:StyleID="s59">
              <Data ss:Type="String">
                <tt:text>1</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>11</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>12</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>13</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>14</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>15</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>16</tt:text>
              </Data>
            </Cell>
          </Row>
          <Row ss:AutoFitHeight="0" ss:Height="24.5">
            <Cell ss:StyleID="s59">
              <Data ss:Type="String">
                <tt:text>2</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>21</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>22</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>23</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>24</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>25</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>26</tt:text>
              </Data>
            </Cell>
          </Row>
          <Row ss:AutoFitHeight="0" ss:Height="24.5">
            <Cell ss:StyleID="s59">
              <Data ss:Type="String">
                <tt:text>3</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>31</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>32</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>33</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>34</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>35</tt:text>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:text>36</tt:text>
              </Data>
            </Cell>
          </Row>
 替换为LOOP格式：
          <tt:loop ref="ITEM">
          <Row ss:AutoFitHeight="0" ss:Height="24.5">
            <Cell ss:StyleID="s59">
              <Data ss:Type="String">
                <tt:value ref="ZCOMM"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL1"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL2"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL3"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL4"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL5"/>
              </Data>
            </Cell>
            <Cell ss:StyleID="s60">
              <Data ss:Type="Number">
                <tt:value ref="ZVAL6"/>
              </Data>
            </Cell>
          </Row>
          </tt:loop>
或者替换为：
          <tt:loop name="I"ref="ITEM">
            <Row ss:AutoFitHeight="0" ss:Height="24.5">
              <Cell ss:StyleID="s59">
                <Data ss:Type="String">
                  <tt:value ref="$I.ZCOMM"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL1"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL2"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL3"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL4"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL5"/>
                </Data>
              </Cell>
              <Cell ss:StyleID="s60">
                <Data ss:Type="Number">
                  <tt:value ref="$I.ZVAL6"/>
                </Data>
              </Cell>
            </Row>
          </tt:loop>

5.编写导出XML EXCEL程序并运行

代码

DATA: LS_HEADER TYPE ZTS_HEADER,
      LT_ITEM   TYPE TABLE OF ZTS_ITEM.

DATA: XML_XSTRING TYPE XSTRING,
      XML_STRING  TYPE STRING.

DATA: XML_TABLE TYPE TABLE OF STRING.

DATA: FILENAME          TYPE STRING,
      PATH              TYPE STRING,
      DEFAULT_EXTENSION TYPE STRING,
      FILE_FILTER       TYPE STRING.


PARAMETERS: P_PATH TYPE STRING OBLIGATORY.

INITIALIZATION.

  LS_HEADER = VALUE #( ZPAR1 = '部门111' ZPAR2 = '部门112' ZPAR3 = '部门113' ZPAR4 = '部门114' ZPAR5 = '部门115' ZPAR6 = '部门116' ).

  LT_ITEM = VALUE #(
                    ( ZCOMM = '1' ZVAL1 = '111' ZVAL2 = '112' ZVAL3 = '113' ZVAL4 = '114' ZVAL5 = '115' ZVAL6 = '116' )
                    ( ZCOMM = '1' ZVAL1 = '121' ZVAL2 = '122' ZVAL3 = '123' ZVAL4 = '124' ZVAL5 = '125' ZVAL6 = '126' )
                    ( ZCOMM = '3' ZVAL1 = '131' ZVAL2 = '132' ZVAL3 = '133' ZVAL4 = '134' ZVAL5 = '135' ZVAL6 = '136' )
                    ).

AT SELECTION-SCREEN OUTPUT.

AT SELECTION-SCREEN.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_PATH.
  MOVE '.XLS' TO DEFAULT_EXTENSION.
  MOVE 'XLS files (.XLS)|.XLS' TO FILE_FILTER.      "导出格式必须为XLS,不能为XLSX

  CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG
    EXPORTING
      DEFAULT_EXTENSION         = DEFAULT_EXTENSION
      FILE_FILTER               = FILE_FILTER
    CHANGING
      FILENAME                  = FILENAME
      PATH                      = PATH
      FULLPATH                  = P_PATH
    EXCEPTIONS
      CNTL_ERROR                = 1
      ERROR_NO_GUI              = 2
      NOT_SUPPORTED_BY_GUI      = 3
      INVALID_DEFAULT_FILE_NAME = 4
      OTHERS                    = 5.

START-OF-SELECTION.
  PERFORM FRM_CALL_TRANSFORMATION.
  PERFORM FRM_PORC_DATA.

END-OF-SELECTION.
  PERFORM FRM_EXPORT_EXCEL.



*&---------------------------------------------------------------------*
*& Form FRM_CALL_TRANSFORMATION
*&---------------------------------------------------------------------*
*& text
*&---------------------------------------------------------------------*
*& -->  p1        text
*& <--  p2        text
*&---------------------------------------------------------------------*
FORM FRM_CALL_TRANSFORMATION .
  CALL TRANSFORMATION ZXML_T01
  SOURCE HEADER = LS_HEADER
         ITEM   = LT_ITEM
  RESULT XML XML_XSTRING.
ENDFORM.
*&---------------------------------------------------------------------*
*& Form FRM_PORC_DATA
*&---------------------------------------------------------------------*
*& text
*&---------------------------------------------------------------------*
*& -->  p1        text
*& <--  p2        text
*&---------------------------------------------------------------------*
FORM FRM_PORC_DATA .
  "转换XSTRING XML 为 STRING XML
  TRY.
      CALL METHOD CL_BCS_CONVERT=>XSTRING_TO_STRING
        EXPORTING
          IV_XSTR   = XML_XSTRING
          IV_CP     = 4110
        RECEIVING
          RV_STRING = XML_STRING.
    CATCH CX_BCS .
  ENDTRY.
  CLEAR: XML_XSTRING.

  APPEND XML_STRING TO XML_TABLE.
ENDFORM.
*&---------------------------------------------------------------------*
*& Form FRM_EXPORT_EXCEL
*&---------------------------------------------------------------------*
*& text
*&---------------------------------------------------------------------*
*& -->  p1        text
*& <--  p2        text
*&---------------------------------------------------------------------*
FORM FRM_EXPORT_EXCEL .
  "Download
  CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      FILENAME                = P_PATH
      FILETYPE                = 'ASC'
      CODEPAGE                = '4110'                "此参数必须设置
    TABLES
      DATA_TAB                = XML_TABLE
    EXCEPTIONS
      FILE_WRITE_ERROR        = 1
      NO_BATCH                = 2
      GUI_REFUSE_FILETRANSFER = 3
      INVALID_TYPE            = 4
      NO_AUTHORITY            = 5
      UNKNOWN_ERROR           = 6
      HEADER_NOT_ALLOWED      = 7
      SEPARATOR_NOT_ALLOWED   = 8
      FILESIZE_NOT_ALLOWED    = 9
      HEADER_TOO_LONG         = 10
      DP_ERROR_CREATE         = 11
      DP_ERROR_SEND           = 12
      DP_ERROR_WRITE          = 13
      UNKNOWN_DP_ERROR        = 14
      ACCESS_DENIED           = 15
      DP_OUT_OF_MEMORY        = 16
      DISK_FULL               = 17
      DP_TIMEOUT              = 18
      FILE_NOT_FOUND          = 19
      DATAPROVIDER_EXCEPTION  = 20
      CONTROL_FLUSH_ERROR     = 21
      OTHERS                  = 22.
ENDFORM.

运行后生成的xls格式excel：

附件：

XML EXCEL源文件：

<?xml version="1.0"?>
<?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:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>XXXXX科技有限公司</Author>
  <LastAuthor>Roger</LastAuthor>
  <Created>2021-08-04T13:57:07Z</Created>
  <LastSaved>2022-01-05T10:23:31Z</LastSaved>
  <Version>16.00</Version>
 </DocumentProperties>
 <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <KSOProductBuildVer dt:dt="string">2052-11.8.2.9067</KSOProductBuildVer>
 </CustomDocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>10420</WindowHeight>
  <WindowWidth>19420</WindowWidth>
  <WindowTopX>32767</WindowTopX>
  <WindowTopY>32767</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m1411229621536">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Size="24" ss:Color="#333333"
    ss:Bold="1"/>
   <Interior/>
  </Style>
  <Style ss:ID="s57">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="DiagonalLeft" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Size="12" ss:Color="#FFFFFF"
    ss:Bold="1"/>
   <Interior ss:Color="#404040" ss:Pattern="Solid"/>
   <NumberFormat
    ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
  </Style>
  <Style ss:ID="s58">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Size="12" ss:Color="#FFFFFF"
    ss:Bold="1"/>
   <Interior ss:Color="#404040" ss:Pattern="Solid"/>
   <NumberFormat
    ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
  </Style>
  <Style ss:ID="s59">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="微软雅黑" x:CharSet="134" x:Family="Swiss" ss:Color="#333333"/>
   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s60">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Color="#333333"/>
   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="0.00_ "/>
  </Style>
  <Style ss:ID="s61">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Color="#333333"/>
   <Interior ss:Color="#FFC000" ss:Pattern="Solid"/>
   <NumberFormat
    ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
  </Style>
  <Style ss:ID="s62">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"
     ss:Color="#AEAAAA"/>
   </Borders>
   <Font ss:FontName="思源黑体" x:CharSet="134" ss:Color="#333333"/>
   <Interior ss:Color="#FFC000" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="0.00_);[Red]\(0.00\)"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="6" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="49.5" ss:DefaultRowHeight="14">
   <Row ss:AutoFitHeight="0" ss:Height="31.5">
    <Cell ss:MergeAcross="7" ss:StyleID="m1411229621536"><Data ss:Type="String">财务季度报表</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="30.5">
    <Cell ss:StyleID="s57"><Data ss:Type="String">  部门
 月份</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门1</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门2</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门3</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门4</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门5</Data></Cell>
    <Cell ss:StyleID="s58"><Data ss:Type="String">部门6</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="24.5">
    <Cell ss:StyleID="s59"><Data ss:Type="String">1</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">11</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">12</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">13</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">14</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">15</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">16</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="24.5">
    <Cell ss:StyleID="s59"><Data ss:Type="String">2</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">21</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">22</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">23</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">24</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">25</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">26</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="24.5">
    <Cell ss:StyleID="s59"><Data ss:Type="String">3</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">31</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">32</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">33</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">34</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">35</Data></Cell>
    <Cell ss:StyleID="s60"><Data ss:Type="Number">36</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="24.5">
    <Cell ss:StyleID="s61"><Data ss:Type="String">总计</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">63</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">66</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">69</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">72</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">75</Data></Cell>
    <Cell ss:StyleID="s62" ss:Formula="=SUM(R[-3]C:R[-1]C)"><Data ss:Type="Number">78</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>300</HorizontalResolution>
    <VerticalResolution>0</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>7</ActiveRow>
     <ActiveCol>5</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>

XML EXCEL 程序导出文件

<?xml version="1.0" encoding="utf-8"?>
<Workbook
    xmlns="urn:schemas-microsoft-com:office:spreadsheet">
    <DocumentProperties
        xmlns="urn:schemas-microsoft-com:office:office">
        <Author>XXXXX科技有限公司</Author>
        <LastAuthor>Roger</LastAuthor>
        <Created>2021-08-04T13:57:07Z</Created>
        <LastSaved>2022-01-05T10:23:31Z</LastSaved>
        <Version>16.00</Version>
    </DocumentProperties>
    <CustomDocumentProperties
        xmlns="urn:schemas-microsoft-com:office:office">
        <KSOProductBuildVer dt:dt="string"
            xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882">2052-11.8.2.9067
        </KSOProductBuildVer>
    </CustomDocumentProperties>
    <OfficeDocumentSettings
        xmlns="urn:schemas-microsoft-com:office:office">
        <AllowPNG/>
    </OfficeDocumentSettings>
    <ExcelWorkbook
        xmlns="urn:schemas-microsoft-com:office:excel">
        <WindowHeight>10420</WindowHeight>
        <WindowWidth>19420</WindowWidth>
        <WindowTopX>32767</WindowTopX>
        <WindowTopY>32767</WindowTopY>
        <ProtectStructure>False</ProtectStructure>
        <ProtectWindows>False</ProtectWindows>
    </ExcelWorkbook>
    <Styles>
        <Style ss:ID="Default" ss:Name="Normal"
            xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
            <Alignment ss:Vertical="Center"/>
            <Borders/>
            <Font ss:Color="#000000" ss:FontName="宋体" ss:Size="11" x:CharSet="134"
                xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                <Interior/>
                <NumberFormat/>
                <Protection/>
            </Style>
            <Style ss:ID="m1411229621536"
                xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                <Borders>
                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>
                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>
                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>
                </Borders>
                <Font ss:Bold="1" ss:Color="#333333" ss:FontName="思源黑体" ss:Size="24" x:CharSet="134"
                    xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                    <Interior/>
                </Style>
                <Style ss:ID="s57"
                    xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                    <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
                    <Borders>
                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="DiagonalLeft" ss:Weight="1"/>
                    </Borders>
                    <Font ss:Bold="1" ss:Color="#FFFFFF" ss:FontName="思源黑体" ss:Size="12" x:CharSet="134"
                        xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                        <Interior ss:Color="#404040" ss:Pattern="Solid"/>
                        <NumberFormat ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
                    </Style>
                    <Style ss:ID="s58"
                        xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                        <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                        <Borders>
                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                        </Borders>
                        <Font ss:Bold="1" ss:Color="#FFFFFF" ss:FontName="思源黑体" ss:Size="12" x:CharSet="134"
                            xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                            <Interior ss:Color="#404040" ss:Pattern="Solid"/>
                            <NumberFormat ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
                        </Style>
                        <Style ss:ID="s59"
                            xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                            <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                            <Borders>
                                <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                                <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                                <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                                <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                            </Borders>
                            <Font ss:Color="#333333" ss:FontName="微软雅黑" x:CharSet="134" x:Family="Swiss"
                                xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                                <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
                                <NumberFormat ss:Format="@"/>
                            </Style>
                            <Style ss:ID="s60"
                                xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                                <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                                <Borders>
                                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                                    <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                                </Borders>
                                <Font ss:Color="#333333" ss:FontName="思源黑体" x:CharSet="134"
                                    xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                                    <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
                                    <NumberFormat ss:Format="0.00_ "/>
                                </Style>
                                <Style ss:ID="s61"
                                    xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                                    <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                                    <Borders>
                                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                                        <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                                    </Borders>
                                    <Font ss:Color="#333333" ss:FontName="思源黑体" x:CharSet="134"
                                        xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                                        <Interior ss:Color="#FFC000" ss:Pattern="Solid"/>
                                        <NumberFormat ss:Format="_ "¥"* #,##0.00_ ;_ "¥"* \-#,##0.00_ ;_ "¥"* "-"??_ ;_ @_ "/>
                                    </Style>
                                    <Style ss:ID="s62"
                                        xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                                        <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
                                        <Borders>
                                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="2"/>
                                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="2"/>
                                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="2"/>
                                            <Border ss:Color="#AEAAAA" ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="2"/>
                                        </Borders>
                                        <Font ss:Color="#333333" ss:FontName="思源黑体" x:CharSet="134"
                                            xmlns:x="urn:schemas-microsoft-com:office:excel"/>
                                            <Interior ss:Color="#FFC000" ss:Pattern="Solid"/>
                                            <NumberFormat ss:Format="0.00_);[Red]\(0.00\)"/>
                                        </Style>
                                    </Styles>
                                    <Worksheet ss:Name="Sheet1"
                                        xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
                                        <Table ss:DefaultColumnWidth="49.5" ss:DefaultRowHeight="14" ss:ExpandedColumnCount="8" ss:ExpandedRowCount="6" x:FullColumns="1" x:FullRows="1"
                                            xmlns:x="urn:schemas-microsoft-com:office:excel">
                                            <Row ss:AutoFitHeight="0" ss:Height="31.5">
                                                <Cell ss:MergeAcross="7" ss:StyleID="m1411229621536">
                                                    <Data ss:Type="String">财务季度报表</Data>
                                                </Cell>
                                            </Row>
                                            <Row ss:AutoFitHeight="0" ss:Height="30.5">
                                                <Cell ss:StyleID="s57">
                                                    <Data ss:Type="String">  部门
月份</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门111</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门112</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门113</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门114</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门115</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s58">
                                                    <Data ss:Type="String">部门116</Data>
                                                </Cell>
                                            </Row>
                                            <Row ss:AutoFitHeight="0" ss:Height="24.5">
                                                <Cell ss:StyleID="s59">
                                                    <Data ss:Type="String">1</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">111</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">112</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">113</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">114</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">115</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">116</Data>
                                                </Cell>
                                            </Row>
                                            <Row ss:AutoFitHeight="0" ss:Height="24.5">
                                                <Cell ss:StyleID="s59">
                                                    <Data ss:Type="String">1</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">121</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">122</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">123</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">124</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">125</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">126</Data>
                                                </Cell>
                                            </Row>
                                            <Row ss:AutoFitHeight="0" ss:Height="24.5">
                                                <Cell ss:StyleID="s59">
                                                    <Data ss:Type="String">3</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">131</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">132</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">133</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">134</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">135</Data>
                                                </Cell>
                                                <Cell ss:StyleID="s60">
                                                    <Data ss:Type="Number">136</Data>
                                                </Cell>
                                            </Row>
                                            <Row ss:AutoFitHeight="0" ss:Height="24.5">
                                                <Cell ss:StyleID="s61">
                                                    <Data ss:Type="String">总计</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">63</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">66</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">69</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">72</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">75</Data>
                                                </Cell>
                                                <Cell ss:Formula="=SUM(R[-3]C:R[-1]C)" ss:StyleID="s62">
                                                    <Data ss:Type="Number">78</Data>
                                                </Cell>
                                            </Row>
                                        </Table>
                                        <WorksheetOptions
                                            xmlns="urn:schemas-microsoft-com:office:excel">
                                            <Unsynced/>
                                            <Print>
                                                <ValidPrinterInfo/>
                                                <PaperSizeIndex>9</PaperSizeIndex>
                                                <HorizontalResolution>300</HorizontalResolution>
                                                <VerticalResolution>0</VerticalResolution>
                                            </Print>
                                            <Selected/>
                                            <Panes>
                                                <Pane>
                                                    <Number>3</Number>
                                                    <ActiveRow>7</ActiveRow>
                                                    <ActiveCol>5</ActiveCol>
                                                </Pane>
                                            </Panes>
                                            <ProtectObjects>False</ProtectObjects>
                                            <ProtectScenarios>False</ProtectScenarios>
                                        </WorksheetOptions>
                                    </Worksheet>
                                </Workbook>