一个案例：把EXCEL按行拆分；按行拆分EXCEL；一个EXCEL变成多个EXCEL文档；

countsun

已于 2022-05-24 22:47:51 修改

阅读量1.7k

点赞数 1

文章标签： xml microsoft

于 2022-05-24 18:32:19 首次发布

本文链接：https://blog.csdn.net/countsun/article/details/124952036

版权

功能需求描述，有一个excel，根据某个规则（案例中的规则是1-50一个excel文档,剩下不足50的一个文档）划分成若干个文档，比如要给员工分配不同的客户信息，比如要分地区给数据。

下面是vba的代码，放在sheet1中，运行宏就行；后面这个例子其实不用看了

Sub chaifen()
 Dim selfpath, outpath_name, i, j, m, li, cl, arr, tt
 Dim strsheet, wordte
 Dim str1, Str2
   
  selfpath = ThisWorkbook.Path
  savepath = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & "拆分50"  '保存的文件夹名称=模板名称+拆分50
  t = ThisWorkbook.Path
  Set fso = CreateObject("scripting.filesystemobject")
  If (fso.folderexists(t & "\" & savepath)) Then
        '如果存在不管他
       ' MsgBox "拆分操作没有完成!" & vbCrLf & "请到本目录下“拆分后文档”文件夹查看！！", vbInformation
  '   Exit Sub
     Else
       Set f1 = fso.createfolder(t & "\" & savepath)
     End If
'以上创建文件夹，多谢Mn860429卡卡西
savepath = ThisWorkbook.Path & "\" & savepath

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Set Rng = ThisWorkbook.Sheets(1)
    s = Rng.Range("A56566").End(3).Row
    For i = 2 To s Step 50
        Workbooks.Add
        With Sheets(1)
      Rng.Range("A1:R1").Copy .[a1]
       Rng.Range("A" & i & ":R" & i + 49).Copy .[a2] 'R表示到R列结束，如果实际不是R列这里要修改的
        End With
        If i + 48 < s Then
        Workbooks(Workbooks.Count).SaveAs savepath & "\" & Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & "_" & i - 1 & "-" & i + 48 & ".xls"
        Else
         Workbooks(Workbooks.Count).SaveAs savepath & "\" & Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & "_" & i - 1 & "-" & s - 1 & ".xls"
        End If
        
        Workbooks(Workbooks.Count).Close 1
    Next i
    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
End Sub



Private Sub CommandButton1_Click()
chaifen
End Sub

下面是一个例子，很简单，就是1-50分表格

上面是sheet1的内容截图

下面是这个excel的xml形式（复制到txt，另存为xml，用excel打开就行）

<?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>Administrator</Author><LastAuthor>User</LastAuthor><Created>2017-11-22T06:45:15Z</Created><LastSaved>2022-05-24T10:24:24Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Generator dt:dt="string">NPOI</Generator><Generator_x0020_Version dt:dt="string">2.3.0</Generator_x0020_Version><KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</KSOProductBuildVer><ICV dt:dt="string">9DE78DD505FA4538A6393B72EC65EB6D</ICV></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>18600</WindowWidth><WindowHeight>6980</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s17" ss:Name="标题"><Font ss:FontName="等线 Light" x:CharSet="134" ss:Size="18" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Bottom"/><Borders/><Font ss:FontName="Arial" x:CharSet="0" x:Family="Swiss" ss:Size="10"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s24" ss:Name="输出"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#333333" ss:Bold="1"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#33CCCC"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0_ ;_ &quot;￥&quot;* \-#,##0_ ;_ &quot;￥&quot;* &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0.00_ ;_ &quot;￥&quot;* \-#,##0.00_ ;_ &quot;￥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s13" ss:Name="注释"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/></Borders><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s3" ss:Name="输入"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#333399"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s7" ss:Name="差"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#800080"/><Interior ss:Color="#FF99CC" ss:Pattern="Solid"/></Style><Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s32" ss:Name="适中"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#993300"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3" ss:Color="#99CCFF"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="13" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s12" ss:Name="已访问的超链接"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#333399" ss:Pattern="Solid"/></Style><Style ss:ID="s29" ss:Name="链接单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#FF9900"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF9900"/></Style><Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s16" ss:Name="警告文本"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF0000"/></Style><Style ss:ID="s25" ss:Name="计算"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF9900" ss:Bold="1"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3" ss:Color="#333399"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="15" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s18" ss:Name="解释性文本"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#808080" ss:Italic="1"/></Style><Style ss:ID="s31" ss:Name="好"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#008000"/><Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#33CCCC" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFCC00" ss:Pattern="Solid"/></Style><Style ss:ID="s39" ss:Name="强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#969696" ss:Pattern="Solid"/></Style><Style ss:ID="s26" ss:Name="检查单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/><Interior ss:Color="#969696" ss:Pattern="Solid"/></Style><Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FF6600" ss:Pattern="Solid"/></Style><Style ss:ID="s44" ss:Name="强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#33CCCC" ss:Pattern="Solid"/></Style><Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333399"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333399"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCCCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s42" ss:Name="常规_长虹300-1205"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s50" ss:Name="常规 2"><Alignment ss:Vertical="Bottom"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s45" ss:Name="40% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s46" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s47" ss:Name="强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#339966" ss:Pattern="Solid"/></Style><Style ss:ID="s48" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s49" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#339966" ss:Pattern="Solid"/></Style><Style ss:ID="s51" ss:Name="常规_虹南264-1204上报"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s52"/><Style ss:ID="s53"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="10"/></Style><Style ss:ID="s54" ss:Parent="s51"/><Style ss:ID="s55" ss:Parent="s42"/></Styles><Worksheet ss:Name="导入拆分"><Names><NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=导入拆分!#REF!" ss:Hidden="1"/></Names><Table ss:ExpandedColumnCount="256" ss:ExpandedRowCount="117" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="50.25" ss:DefaultRowHeight="15"><Column ss:Index="1" ss:StyleID="s55" ss:AutoFitWidth="0" ss:Width="56.55" ss:Span="7"/><Column ss:Index="9" ss:StyleID="s55" ss:AutoFitWidth="0" ss:Span="223"/><Column ss:Index="233" ss:StyleID="s55" ss:Span="23"/><Row ss:StyleID="s54" ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="String">a</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注</Data></Cell></Row><Row ss:StyleID="s54" ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名1</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄100</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注2甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名2</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄101</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注3甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名3</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄102</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注4甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名4</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄103</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注5甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名5</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄104</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注6甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名6</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄105</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注7甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名7</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄106</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注8甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">8</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名8</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄107</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注9甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">9</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名9</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄108</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注10甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">10</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名10</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄109</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注11甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">11</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名11</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄110</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注12甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">12</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名12</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄111</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注13甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">13</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名13</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄112</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注14甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">14</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名14</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄113</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注15甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">15</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名15</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄114</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注16甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">16</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名16</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄115</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注17甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">17</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名17</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄116</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注18甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">18</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名18</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄117</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注19甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">19</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名19</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄118</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注20甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">20</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名20</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄119</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注21甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">21</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名21</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄120</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注22甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">22</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名22</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄121</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注23甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">23</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名23</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄122</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注24甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">24</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名24</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄123</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注25甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">25</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名25</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄124</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注26甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">26</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名26</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄125</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注27甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">27</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名27</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄126</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注28甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">28</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名28</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄127</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注29甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">29</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名29</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄128</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注30甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">30</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名30</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄129</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注31甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">31</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名31</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄130</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注32甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">32</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名32</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄131</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注33甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">33</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名33</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄132</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注34甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">34</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名34</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄133</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注35甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">35</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名35</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄134</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注36甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">36</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名36</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄135</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注37甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">37</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名37</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄136</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注38甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">38</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名38</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄137</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注39甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">39</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名39</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄138</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注40甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">40</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名40</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄139</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注41甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">41</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名41</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄140</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注42甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">42</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名42</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄141</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注43甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">43</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名43</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄142</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注44甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">44</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名44</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄143</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注45甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">45</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名45</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄144</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注46甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">46</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名46</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄145</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注47甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">47</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名47</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄146</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注48甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">48</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名48</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄147</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注49甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">49</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名49</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄148</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注50甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">50</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名50</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄149</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注51甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">51</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名51</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄150</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注52甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">52</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名52</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄151</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注53甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">53</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名53</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄152</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注54甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">54</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名54</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄153</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注55甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">55</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名55</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄154</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注56甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">56</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名56</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄155</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注57甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">57</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名57</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄156</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注58甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">58</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名58</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄157</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注59甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">59</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名59</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄158</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注60甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">60</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名60</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄159</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注61甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">61</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名61</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄160</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注62甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">62</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名62</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄161</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注63甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">63</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名63</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄162</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注64甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">64</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名64</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄163</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注65甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">65</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名65</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄164</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注66甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">66</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名66</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄165</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注67甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">67</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名67</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄166</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注68甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">68</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名68</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄167</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注69甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">69</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名69</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄168</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注70甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">70</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名70</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄169</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注71甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">71</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名71</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄170</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注72甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">72</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名72</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄171</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注73甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">73</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名73</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄172</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注74甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">74</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名74</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄173</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注75甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">75</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名75</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄174</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注76甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">76</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名76</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄175</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注77甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">77</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名77</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄176</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注78甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">78</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名78</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄177</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注79甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">79</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名79</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄178</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注80甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">80</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名80</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄179</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注81甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">81</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名81</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄180</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注82甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">82</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名82</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄181</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注83甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">83</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名83</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄182</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注84甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">84</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名84</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄183</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注85甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">85</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名85</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄184</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注86甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">86</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名86</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄185</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注87甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">87</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名87</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄186</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注88甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">88</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名88</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄187</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注89甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">89</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名89</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄188</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注90甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">90</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名90</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄189</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注91甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">91</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名91</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄190</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注92甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">92</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名92</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄191</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注93甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">93</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名93</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄192</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注94甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">94</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名94</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄193</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注95甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">95</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名95</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄194</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注96甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">96</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名96</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄195</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注97甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">97</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名97</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄196</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注98甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">98</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名98</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄197</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注99甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">99</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名99</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄198</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注100甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">100</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名100</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄199</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注101甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">101</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名101</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄200</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注102甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">102</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名102</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄201</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注103甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">103</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名103</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄202</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注104甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">104</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名104</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄203</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注105甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">105</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名105</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄204</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注106甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">106</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名106</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄205</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注107甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">107</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名107</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄206</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注108甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">108</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名108</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄207</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注109甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">109</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名109</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄208</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注110甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">110</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名110</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄209</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注111甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">111</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名111</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄210</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注112甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">112</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名112</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄211</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注113甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">113</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名113</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄212</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注114甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">114</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名114</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄213</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注115甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">115</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名115</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄214</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注116甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s54"><Data ss:Type="Number">116</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">姓名116</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">年龄215</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">备注117甲</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><FreezePanes/><FrozenNoSplit/><SplitHorizontal>1</SplitHorizontal><TopRowBottomPane>1</TopRowBottomPane><SplitVertical>1</SplitVertical><LeftColumnRightPane>1</LeftColumnRightPane><ActivePane>0</ActivePane><Panes><Pane><Number>3</Number></Pane><Pane><Number>1</Number></Pane><Pane><Number>2</Number></Pane><Pane><Number>0</Number><ActiveRow>6</ActiveRow><ActiveCol>1</ActiveCol><RangeSelection>R7C2</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet><Worksheet ss:Name="操作说明"><Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="4" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="50.25" ss:DefaultRowHeight="12.5"><Row ss:Height="12"/><Row ss:Height="12"><Cell><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">文件另存为<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>一个<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">xx</Font>，要不然拆分处理的文件名<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>都是拆分<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">50</Font>模板<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">_1-50</Font>这样的</ss:Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">把数据复制过来（处理好的数据）<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>可以复制整个表<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>点拆分就<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">ok</Font></ss:Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">结束列是<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">R</Font>列，如果要改，<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">vba</Font>里边要改掉</ss:Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Print><ValidPrinterInfo/><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution><VerticalResolution>600</VerticalResolution></Print><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><Panes><Pane><Number>3</Number><ActiveRow>4</ActiveRow><ActiveCol>1</ActiveCol><RangeSelection>R5C2</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>

下面这个更加通用一点，可以自己编辑拆分规则；

规则	文件名
地区1	xx地区1
地区2	xx地区2
地区3	xx地区3
地区4	xx地区43
地区46	xx地区52
地区48	xx地区4
地区5	xx地区5
地区6	地区6

拆分规则	序号	姓名	年龄	备注
地区1	1	姓名1	年龄100	备注2甲
地区1	6	姓名6	年龄105	备注7甲
地区1	10	姓名10	年龄109	备注11甲
地区1	15	姓名15	年龄114	备注16甲
地区1	19	姓名19	年龄118	备注20甲
地区1	24	姓名24	年龄123	备注25甲
地区1	28	姓名28	年龄127	备注29甲

效果图

代码如下

代码如下，放在sheet里边；

操作说明如下

1、把拆分规则设置好，如果有多个字段，搞成一个合并的字段，拆分规则只有一个字段
2、数据复制原数据B到xx列，不要A列开始；把规则列的数据复制到A列，然后按A列排序
3、现在程序复制的结束列是R列，如果要改，vba里边要改掉
4、切记：原数据第一列的值，必须都在拆分规则中，否则出错，而且这两列必须都是相同的排序，可以降序，可以升序。

备注：（有点绕，不看也没啥）如果原数据第一列最后一个值，小于拆分规则第一列最后一个数据，那么这些都不会拆分，比如地区6不会出现在表格中。就是说拆分规则多出来的，因为没数据，可能就不生产表格了。

下面是excel的xml文件

<?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>Administrator</Author><LastAuthor>User</LastAuthor><Created>2017-11-22T06:45:15Z</Created><LastSaved>2022-05-24T14:41:24Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Generator dt:dt="string">NPOI</Generator><Generator_x0020_Version dt:dt="string">2.3.0</Generator_x0020_Version><KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</KSOProductBuildVer><ICV dt:dt="string">9DE78DD505FA4538A6393B72EC65EB6D</ICV></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>19200</WindowWidth><WindowHeight>6680</WindowHeight><ActiveSheet>2</ActiveSheet><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Bottom"/><Borders/><Font ss:FontName="Arial" x:CharSet="0" x:Family="Swiss" ss:Size="10"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s32" ss:Name="适中"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#993300"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3" ss:Color="#99CCFF"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="13" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s16" ss:Name="警告文本"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF0000"/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0_ ;_ &quot;￥&quot;* \-#,##0_ ;_ &quot;￥&quot;* &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s7" ss:Name="差"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#800080"/><Interior ss:Color="#FF99CC" ss:Pattern="Solid"/></Style><Style ss:ID="s47" ss:Name="强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#339966" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFCC00" ss:Pattern="Solid"/></Style><Style ss:ID="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#333399" ss:Pattern="Solid"/></Style><Style ss:ID="s24" ss:Name="输出"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333333"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#333333" ss:Bold="1"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#33CCCC" ss:Pattern="Solid"/></Style><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s42" ss:Name="常规_长虹300-1205"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333399"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#333399"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0.00_ ;_ &quot;￥&quot;* \-#,##0.00_ ;_ &quot;￥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s51" ss:Name="常规_虹南264-1204上报"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s48" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s18" ss:Name="解释性文本"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#808080" ss:Italic="1"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s12" ss:Name="已访问的超链接"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/></Style><Style ss:ID="s3" ss:Name="输入"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#333399"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s44" ss:Name="强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#33CCCC" ss:Pattern="Solid"/></Style><Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCCCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s29" ss:Name="链接单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#FF9900"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF9900"/></Style><Style ss:ID="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s45" ss:Name="40% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FF6600" ss:Pattern="Solid"/></Style><Style ss:ID="s26" ss:Name="检查单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/><Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3" ss:Color="#333333"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/><Interior ss:Color="#969696" ss:Pattern="Solid"/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#33CCCC"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s17" ss:Name="标题"><Font ss:FontName="等线 Light" x:CharSet="134" ss:Size="18" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s50" ss:Name="常规 2"><Alignment ss:Vertical="Bottom"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s46" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#99CCFF" ss:Pattern="Solid"/></Style><Style ss:ID="s31" ss:Name="好"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#008000"/><Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFFF99" ss:Pattern="Solid"/></Style><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3" ss:Color="#333399"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="15" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s13" ss:Name="注释"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#C0C0C0"/></Borders><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s49" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#339966" ss:Pattern="Solid"/></Style><Style ss:ID="s39" ss:Name="强调文字颜色 3"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#969696" ss:Pattern="Solid"/></Style><Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6"><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s25" ss:Name="计算"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#808080"/></Borders><Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#FF9900" ss:Bold="1"/><Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/></Style><Style ss:ID="s52"/><Style ss:ID="s53"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="10"/></Style><Style ss:ID="s54"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="10" ss:Bold="1"/></Style><Style ss:ID="s55"><Font ss:FontName="Arial" x:CharSet="0" x:Family="Swiss" ss:Size="10"/></Style><Style ss:ID="s56"><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="10"/></Style><Style ss:ID="s57" ss:Parent="s51"/><Style ss:ID="s58" ss:Parent="s42"/><Style ss:ID="s59" ss:Parent="s51"><Borders/></Style></Styles><Worksheet ss:Name="原数据"><Names><NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=原数据!#REF!" ss:Hidden="1"/></Names><Table ss:ExpandedColumnCount="256" ss:ExpandedRowCount="117" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="50.25" ss:DefaultRowHeight="15"><Column ss:Index="1" ss:StyleID="s58"/><Column ss:Index="2" ss:StyleID="s58" ss:AutoFitWidth="0" ss:Width="56.55" ss:Span="7"/><Column ss:Index="10" ss:StyleID="s58" ss:AutoFitWidth="0" ss:Span="223"/><Column ss:Index="234" ss:StyleID="s58" ss:Span="22"/><Row ss:StyleID="s57" ss:Height="14"><Cell ss:StyleID="s57"><Data ss:Type="String">拆分规则</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">序号</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">姓名</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">年龄</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">备注</Data></Cell></Row><Row ss:StyleID="s57" ss:Height="14"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">姓名1</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">年龄100</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">备注2甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">6</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名6</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄105</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注7甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">10</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名10</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄109</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注11甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">15</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名15</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄114</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注16甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">19</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名19</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄118</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注20甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">24</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名24</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄123</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注25甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">28</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名28</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄127</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注29甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">33</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名33</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄132</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注34甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">37</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名37</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄136</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注38甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">42</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名42</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄141</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注43甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">46</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名46</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄145</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注47甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">48</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名48</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄147</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注49甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">50</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名50</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄149</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注51甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">52</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名52</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄151</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注53甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">54</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名54</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄153</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注55甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">56</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名56</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄155</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注57甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">58</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名58</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄157</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注59甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">60</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名60</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄159</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注61甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">62</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名62</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄161</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注63甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">64</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名64</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄163</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注65甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">66</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名66</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄165</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注67甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">68</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名68</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄167</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注69甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">70</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名70</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄169</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注71甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">72</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名72</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄171</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注73甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">74</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名74</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄173</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注75甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">76</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名76</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄175</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注77甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">78</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名78</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄177</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注79甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">80</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名80</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄179</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注81甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">82</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名82</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄181</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注83甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">84</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名84</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄183</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注85甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">86</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名86</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄185</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注87甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">88</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名88</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄187</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注89甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">90</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名90</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄189</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注91甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">92</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名92</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄191</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注93甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">94</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名94</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄193</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注95甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">96</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名96</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄195</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注97甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">98</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名98</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄197</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注99甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">100</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名100</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄199</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注101甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">102</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名102</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄201</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注103甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">104</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名104</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄203</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注105甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">106</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名106</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄205</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注107甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">108</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名108</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄207</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注109甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">110</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名110</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄209</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注111甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">112</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名112</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄211</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注113甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">114</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名114</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄213</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注115甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">116</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名116</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄215</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注117甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名2</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄101</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注3甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">7</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名7</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄106</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注8甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">11</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名11</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄110</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注12甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">16</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名16</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄115</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注17甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">20</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名20</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄119</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注21甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">25</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名25</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄124</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注26甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">29</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名29</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄128</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注30甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">34</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名34</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄133</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注35甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">38</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名38</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄137</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注39甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">43</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名43</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄142</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注44甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名3</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄102</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注4甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">8</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名8</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄107</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注9甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">12</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名12</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄111</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注13甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">17</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名17</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄116</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注18甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">21</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名21</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄120</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注22甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">26</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名26</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄125</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注27甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">30</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名30</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄129</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注31甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">35</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名35</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄134</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注36甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">39</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名39</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄138</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注40甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">3</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">44</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名44</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄143</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注45甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名4</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄103</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注5甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">9</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名9</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄108</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注10甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">13</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名13</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄112</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注14甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">18</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名18</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄117</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注19甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">22</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名22</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄121</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注23甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">27</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名27</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄126</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注28甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">31</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名31</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄130</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注32甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">36</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名36</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄135</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注37甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">40</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名40</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄139</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注41甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">45</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名45</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄144</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注46甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">47</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名47</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄146</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注48甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">49</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名49</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄148</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注50甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">51</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名51</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄150</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注52甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">53</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名53</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄152</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注54甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">55</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名55</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄154</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注56甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">57</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名57</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄156</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注58甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">59</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名59</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄158</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注60甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">61</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名61</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄160</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注62甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">63</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名63</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄162</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注64甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">65</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名65</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄164</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注66甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">67</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名67</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄166</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注68甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">69</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名69</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄168</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注70甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">71</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名71</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄170</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注72甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">73</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名73</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄172</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注74甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">75</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名75</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄174</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注76甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">77</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名77</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄176</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注78甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">79</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名79</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄178</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注80甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">81</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名81</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄180</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注82甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">83</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名83</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄182</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注84甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">85</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名85</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄184</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注86甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">87</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名87</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄186</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注88甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">89</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名89</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄188</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注90甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">91</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名91</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄190</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注92甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">93</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名93</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄192</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注94甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">95</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名95</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄194</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注96甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">97</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名97</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄196</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注98甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">99</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名99</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄198</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注100甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">101</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名101</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄200</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注102甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">103</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名103</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄202</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注104甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">105</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名105</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄204</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注106甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="Number">107</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">姓名107</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">年龄206</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">备注108甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">109</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名109</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄208</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注110甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">111</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名111</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄210</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注112甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">113</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名113</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄212</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注114甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">115</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名115</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄214</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注116甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">5</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名5</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄104</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注6甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">14</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名14</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄113</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注15甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">23</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名23</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄122</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注24甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">32</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名32</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄131</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注33甲</Data></Cell></Row><Row ss:Height="14"><Cell ss:StyleID="s56"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="Number">41</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">姓名41</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">年龄140</Data></Cell><Cell ss:StyleID="s59"><Data ss:Type="String">备注42甲</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><FreezePanes/><FrozenNoSplit/><SplitHorizontal>1</SplitHorizontal><TopRowBottomPane>1</TopRowBottomPane><SplitVertical>2</SplitVertical><LeftColumnRightPane>2</LeftColumnRightPane><ActivePane>0</ActivePane><Panes><Pane><Number>3</Number></Pane><Pane><Number>1</Number></Pane><Pane><Number>2</Number></Pane><Pane><Number>0</Number><ActiveRow>0</ActiveRow><ActiveCol>0</ActiveCol><RangeSelection>R1C1:R8C5</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet><Worksheet ss:Name="拆分规则"><Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="9" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="12.5"><Row ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">规则</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">文件名</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地区1</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">规则里边的规则列不能重复，不能出现两个一样的，并且要排序好</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地区2</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">地区3</Data></Cell><Cell ss:StyleID="s55"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font x:Family="Swiss">xx</Font><Font html:Face="宋体" x:CharSet="134">地区</Font><Font x:Family="Swiss">3</Font></ss:Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">4</Font></ss:Data></Cell><Cell ss:StyleID="s55"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font x:Family="Swiss">xx</Font><Font html:Face="宋体" x:CharSet="134">地区</Font><Font x:Family="Swiss">43</Font></ss:Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">地区46</Data></Cell><Cell ss:StyleID="s55"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font x:Family="Swiss">xx</Font><Font html:Face="宋体" x:CharSet="134">地区</Font><Font x:Family="Swiss">52</Font></ss:Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">48</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地区4</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地区<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地区5</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s56"><Data ss:Type="String">地区6</Data></Cell><Cell ss:StyleID="s56"><Data ss:Type="String">地区6</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>5</ActiveRow><ActiveCol>5</ActiveCol><RangeSelection>R6C6</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet><Worksheet ss:Name="操作说明"><Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="8" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="50.25" ss:DefaultRowHeight="12.5"><Row ss:Height="12"/><Row ss:Height="12"><Cell><Data ss:Type="Number">1</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">把拆分规则设置好，如果有多个字段，搞成一个合并的字段，拆分规则只有一个字段</Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">数据复制原数据B到xx列，不要A列开始；把规则列的数据复制到A列，然后按A列排序</Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">3</Data></Cell><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">现在程序复制的结束列是<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">R</Font>列，如果要改，<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">vba</Font>里边要改掉</ss:Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">4</Data></Cell><Cell ss:StyleID="s54"><Data ss:Type="String">切记：原数据第一列的值，必须都在拆分规则中，否则出错，而且这两列必须都是相同的排序</Data></Cell></Row><Row ss:Index="8" ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">备注：如果原数据第一列最后一个值，小于拆分规则第一列最后一个数据，那么这些都不会拆分，比如地区6不会出现在表格中</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Print><ValidPrinterInfo/><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution><VerticalResolution>600</VerticalResolution></Print><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><Panes><Pane><Number>3</Number><ActiveRow>9</ActiveRow><ActiveCol>4</ActiveCol><RangeSelection>R10C5</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>

下面是VBA源码

Sub chaifen()

  strSheet1 = "原数据"
  strSheet2 = "拆分规则"
  savepath = "拆分文档"  '保存的文件夹名称
  t = ThisWorkbook.Path
  Set fso = CreateObject("scripting.filesystemobject")
  If (fso.folderexists(t & "\" & savepath)) Then
        '如果存在不管他
       ' MsgBox "拆分操作没有完成!" & vbCrLf & "请到本目录下“拆分后文档”文件夹查看！！", vbInformation
  '   Exit Sub
     Else
       Set f1 = fso.createfolder(t & "\" & savepath)
     End If
'以上创建文件夹，多谢Mn860429卡卡西
savepath = ThisWorkbook.Path & "\" & savepath

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Set Rng = ThisWorkbook.Sheets(strSheet1)
    s = Rng.Range("A56566").End(3).Row
    Set Rng2 = ThisWorkbook.Sheets(strSheet2)
    s2 = Rng2.Range("A56566").End(3).Row
    j = 2
    ej = 2
    bi = 2
    ei = 1
    For i = 2 To s Step 1
    outname = Sheets(strSheet2).Cells(j, 2) & ".xls"
     If Sheets(strSheet2).Cells(j, 1) = Sheets(strSheet1).Cells(i, 1) Then
       If i = s Then
       Workbooks.Add
        With Sheets(1)
      Rng.Range("A1:R1").Copy .[a1]
      Rng.Range("A" & bi & ":R" & s).Copy .[a2]  'R表示到R列结束，如果实际不是R列这里要修改的R1 也改改
        End With
        Workbooks(Workbooks.Count).SaveAs savepath & "\" & outname
        Workbooks(Workbooks.Count).Close 1
        j = j + 1
        End If
     
     Else
     
     If (i > bi) Then
     ei = i - 1
      Workbooks.Add
        With Sheets(1)
      Rng.Range("A1:R1").Copy .[a1]
      Rng.Range("A" & bi & ":R" & ei).Copy .[a2]  'R表示到R列结束，如果实际不是R列这里要修改的R1 也改改
        End With
        Workbooks(Workbooks.Count).SaveAs savepath & "\" & outname
        Workbooks(Workbooks.Count).Close 1
        j = j + 1
        ej = j
        bi = i
        i = i - 1
      Else
      Workbooks.Add
        With Sheets(1)
      Rng.Range("A1:R1").Copy .[a1]
      'R表示到R列结束，如果实际不是R列这里要修改的R1 也改改
        End With
        Workbooks(Workbooks.Count).SaveAs savepath & "\无" & outname
        Workbooks(Workbooks.Count).Close 1
        j = j + 1
        i = i - 1
      End If
      
     End If
     If j > s2 Then
     i = i + 1
     j = ej
     End If
    Next i
    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
End Sub



Private Sub CommandButton1_Click()
chaifen
End Sub

资源在下面，VBA都给了，其实真没必要下载

excel拆分模板，一个excel拆成多个excel-数据集文档类资源-CSDN下载

countsun

关注

1
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
一个案例：把EXCEL按行拆分；按行拆分EXCEL；一个EXCEL变成多个EXCEL文档；

功能需求描述，有一个excel，根据某个规则（案例中的规则是1-50一个excel文档）,剩下不足50的一个文档；下面是vba的代码，放在sheet1中，运行宏就行；后面这个例子其实不用看了Sub chaifen() Dim selfpath, outpath_name, i, j, m, li, cl, arr, tt Dim strsheet, wordte Dim str1, Str2 selfpath = ThisWorkbook.Path savepath
复制链接

扫一扫