1.准备EXCEL模板并另存为XML EXCEL
2.创建SAP TRANSFORMATION
- 事务代码:STRANS
3.导入XML EXCEL并创建入参结构和表
- 导入XML EXCEL
- 复制XML EXCEL数据(忽略第一行)到SAP TRANSFORMATION template之间
- 复制XML EXCEL数据(忽略第一行)到SAP TRANSFORMATION template之间
- 创建导入结构和表
- 切换到图形编辑模式
- 导入结构参数
- 表结构参数(创建后效果)
- 切换到图形编辑模式
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"/>
- 项目:
将: <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>