国产 无码 综合区,色欲AV无码国产永久播放,无码天堂亚洲国产AV,国产日韩欧美女同一区二区

  1. Toy模板網(wǎng)首頁(yè)
  2. >Toy博客

一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；

2年前作者：countsun分類：Toy博客閱讀(15)違法舉報(bào)

這篇具有很好參考價(jià)值的文章主要介紹了一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；。希望對(duì)大家有所幫助。如果存在錯(cuò)誤或未考慮完全的地方，請(qǐng)大家不吝賜教，您也可以點(diǎn)擊"舉報(bào)違法"按鈕提交疑問(wèn)。

功能需求描述，有一個(gè)excel，根據(jù)某個(gè)規(guī)則（案例中的規(guī)則是1-50一個(gè)excel文檔,剩下不足50的一個(gè)文檔） 劃分成若干個(gè)文檔，比如要給員工分配不同的客戶信息，比如要分地區(qū)給數(shù)據(jù)。

一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；

下面是vba的代碼，放在sheet1中，運(yùn)行宏就行；后面這個(gè)例子其實(shí)不用看了

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 "拆分操作沒(méi)有完成!" & vbCrLf & "請(qǐng)到本目錄下“拆分后文檔”文件夾查看??！", vbInformation
  '   Exit Sub
     Else
       Set f1 = fso.createfolder(t & "\" & savepath)
     End If
'以上創(chuàng)建文件夾，多謝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列結(jié)束，如果實(shí)際不是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

下面是一個(gè)例子，很簡(jiǎn)單，就是1-50分表格?

一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；

上面是sheet1的內(nèi)容截圖

下面是這個(gè)excel的xml形式（復(fù)制到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="標(biāo)題"><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="標(biāo)題 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="標(biāo)題 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="標(biāo)題 4"><Font ss:FontName="等線" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s12" ss:Name="已訪問(wèn)的超鏈接"><Font ss:FontName="等線" x:CharSet="134" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s34" ss:Name="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="計(jì)算"><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="標(biāo)題 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="常規(guī)_長(zhǎng)虹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="常規(guī) 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="常規(guī)_虹南264-1204上報(bào)"><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="導(dǎo)入拆分"><Names><NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=導(dǎo)入拆分!#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="操作說(shuō)明"><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>一個(gè)<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">把數(shù)據(jù)復(fù)制過(guò)來(lái)（處理好的數(shù)據(jù)）<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>可以復(fù)制整個(gè)表<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss"> </Font>點(diǎn)拆分就<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">結(jié)束列是<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>

下面這個(gè)更加通用一點(diǎn)，可以自己編輯拆分規(guī)則；

規(guī)則 文件名
地區(qū)1 xx地區(qū)1
地區(qū)2 xx地區(qū)2
地區(qū)3 xx地區(qū)3
地區(qū)4 xx地區(qū)43
地區(qū)46 xx地區(qū)52
地區(qū)48 xx地區(qū)4
地區(qū)5 xx地區(qū)5
地區(qū)6 地區(qū)6
拆分規(guī)則 序號(hào) 姓名 年齡 備注
地區(qū)1 1 姓名1 年齡100 備注2甲
地區(qū)1 6 姓名6 年齡105 備注7甲
地區(qū)1 10 姓名10 年齡109 備注11甲
地區(qū)1 15 姓名15 年齡114 備注16甲
地區(qū)1 19 姓名19 年齡118 備注20甲
地區(qū)1 24 姓名24 年齡123 備注25甲
地區(qū)1 28 姓名28 年齡127 備注29甲

效果圖?

?代碼如下

一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；

?代碼如下，放在sheet里邊；

操作說(shuō)明如下

1、把拆分規(guī)則設(shè)置好，如果有多個(gè)字段，搞成一個(gè)合并的字段，拆分規(guī)則只有一個(gè)字段
2、數(shù)據(jù)復(fù)制原數(shù)據(jù)B到xx列，不要A列開始；把規(guī)則列的數(shù)據(jù)復(fù)制到A列，然后按A列排序
3、現(xiàn)在程序復(fù)制的結(jié)束列是R列，如果要改，vba里邊要改掉
4、切記：原數(shù)據(jù)第一列的值，必須都在拆分規(guī)則中，否則出錯(cuò)，而且這兩列必須都是相同的排序，可以降序，可以升序。
?

備注：（有點(diǎn)繞，不看也沒(méi)啥）如果原數(shù)據(jù)第一列最后一個(gè)值，小于拆分規(guī)則第一列最后一個(gè)數(shù)據(jù)，那么這些都不會(huì)拆分，比如地區(qū)6不會(huì)出現(xiàn)在表格中?。就是說(shuō)拆分規(guī)則多出來(lái)的，因?yàn)闆](méi)數(shù)據(jù)，可能就不生產(chǎn)表格了。

一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；

下面是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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="標(biāo)題 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="常規(guī)_長(zhǎng)虹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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="常規(guī)_虹南264-1204上報(bào)"><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% - 強(qiáng)調(diào)文字顏色 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="標(biāo)題 4"><Font ss:FontName="等線" x:CharSet="134" ss:Size="11" ss:Color="#666699" ss:Bold="1"/></Style><Style ss:ID="s12" ss:Name="已訪問(wèn)的超鏈接"><Font ss:FontName="等線" x:CharSet="134" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s2" ss:Name="20% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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="標(biāo)題 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="標(biāo)題"><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="常規(guī) 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% - 強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="標(biāo)題 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% - 強(qiáng)調(diào)文字顏色 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="強(qiáng)調(diào)文字顏色 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% - 強(qiáng)調(diào)文字顏色 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="計(jì)算"><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="原數(shù)據(jù)"><Names><NamedRange ss:Name="_FilterDatabase" ss:RefersTo="=原數(shù)據(jù)!#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">拆分規(guī)則</Data></Cell><Cell ss:StyleID="s57"><Data ss:Type="String">序號(hào)</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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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">地區(qū)<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="拆分規(guī)則"><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">規(guī)則</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">地區(qū)<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">1</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地區(qū)1</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">規(guī)則里邊的規(guī)則列不能重復(fù)，不能出現(xiàn)兩個(gè)一樣的，并且要排序好</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40">地區(qū)<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">2</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地區(qū)2</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">地區(qū)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">地區(qū)</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">地區(qū)<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">地區(qū)</Font><Font x:Family="Swiss">43</Font></ss:Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">地區(qū)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">地區(qū)</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">地區(qū)<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">48</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地區(qū)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">地區(qū)<Font html:Face="Arial" x:CharSet="0" x:Family="Swiss">5</Font></ss:Data></Cell><Cell><Data ss:Type="String">xx地區(qū)5</Data></Cell></Row><Row ss:Height="13"><Cell ss:StyleID="s56"><Data ss:Type="String">地區(qū)6</Data></Cell><Cell ss:StyleID="s56"><Data ss:Type="String">地區(qū)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="操作說(shuō)明"><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">把拆分規(guī)則設(shè)置好，如果有多個(gè)字段，搞成一個(gè)合并的字段，拆分規(guī)則只有一個(gè)字段</Data></Cell></Row><Row ss:Height="13"><Cell><Data ss:Type="Number">2</Data></Cell><Cell ss:StyleID="s53"><Data ss:Type="String">數(shù)據(jù)復(fù)制原數(shù)據(jù)B到xx列，不要A列開始；把規(guī)則列的數(shù)據(jù)復(fù)制到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">現(xiàn)在程序復(fù)制的結(jié)束列是<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">切記：原數(shù)據(jù)第一列的值，必須都在拆分規(guī)則中，否則出錯(cuò)，而且這兩列必須都是相同的排序</Data></Cell></Row><Row ss:Index="8" ss:Height="13"><Cell ss:StyleID="s53"><Data ss:Type="String">備注：如果原數(shù)據(jù)第一列最后一個(gè)值，小于拆分規(guī)則第一列最后一個(gè)數(shù)據(jù)，那么這些都不會(huì)拆分，比如地區(qū)6不會(huì)出現(xiàn)在表格中</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 = "原數(shù)據(jù)"
  strSheet2 = "拆分規(guī)則"
  savepath = "拆分文檔"  '保存的文件夾名稱
  t = ThisWorkbook.Path
  Set fso = CreateObject("scripting.filesystemobject")
  If (fso.folderexists(t & "\" & savepath)) Then
        '如果存在不管他
       ' MsgBox "拆分操作沒(méi)有完成!" & vbCrLf & "請(qǐng)到本目錄下“拆分后文檔”文件夾查看??！", vbInformation
  '   Exit Sub
     Else
       Set f1 = fso.createfolder(t & "\" & savepath)
     End If
'以上創(chuàng)建文件夾，多謝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列結(jié)束，如果實(shí)際不是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列結(jié)束，如果實(shí)際不是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列結(jié)束，如果實(shí)際不是R列這里要修改的R1 也改改
        End With
        Workbooks(Workbooks.Count).SaveAs savepath & "\無(wú)" & 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都給了，其實(shí)真沒(méi)必要下載

excel拆分模板，一個(gè)excel拆成多個(gè)excel-數(shù)據(jù)集文檔類資源-CSDN下載文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-454114.html

到了這里，關(guān)于一個(gè)案例：把EXCEL按行拆分；按行拆分EXCEL；一個(gè)EXCEL變成多個(gè)EXCEL文檔；的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！

本文來(lái)自互聯(lián)網(wǎng)用戶投稿，該文觀點(diǎn)僅代表作者本人，不代表本站立場(chǎng)。本站僅提供信息存儲(chǔ)空間服務(wù)，不擁有所有權(quán)，不承擔(dān)相關(guān)法律責(zé)任。如若轉(zhuǎn)載，請(qǐng)注明出處： 如若內(nèi)容造成侵權(quán)/違法違規(guī)/事實(shí)不符，請(qǐng)點(diǎn)擊違法舉報(bào)進(jìn)行投訴反饋，一經(jīng)查實(shí)，立即刪除！

領(lǐng)支付寶紅包贊助服務(wù)器費(fèi)用

相關(guān)文章

  • 通過(guò)ChatGPT實(shí)現(xiàn)的ChatPDF，簡(jiǎn)單的應(yīng)用落地，讓你的文檔變成一個(gè)智能助手，通過(guò)對(duì)話的方式快速學(xué)習(xí)文檔內(nèi)容

    通過(guò)ChatGPT實(shí)現(xiàn)的ChatPDF，簡(jiǎn)單的應(yīng)用落地，讓你的文檔變成一個(gè)智能助手，通過(guò)對(duì)話的方式快速學(xué)習(xí)文檔內(nèi)容

    目錄 先看效果 實(shí)現(xiàn)原理 環(huán)境安裝 應(yīng)用場(chǎng)景 首先，找到一篇論文先，我這里隨便找了一篇pdf格式的論文 那么，我現(xiàn)在讓他擔(dān)任一個(gè)研究論文的智能助手，當(dāng)然大家可以自定義自己的prompt ?開始問(wèn)答 可以看到效果很強(qiáng) 提取 pdf 文本，以便后續(xù)處理。 由于 OpenAI API 對(duì) Token 數(shù)量

    2023年04月08日
    瀏覽(27)

  • 多個(gè)excel文件合并為一個(gè)excel

    Python openpyxl庫(kù)實(shí)現(xiàn)將同一目錄下的excel文件合并為一個(gè)excel功能(包含格式，不含宏)，運(yùn)行程序后，輸入要生成的excel文件名稱即可

    2024年02月16日
    瀏覽(20)

  • 多個(gè)excel的sheet合并到一個(gè)excel下

    目標(biāo)：多個(gè)excel的sheet合并到一個(gè)excel下（不同sheet） 要求：原始數(shù)據(jù)不同excel中的sheet名不同

    2024年02月13日
    瀏覽(21)

  • Office2010 把多個(gè)excel合并成一個(gè)

    公司經(jīng)常要把多個(gè)xls文件合并到一個(gè)里面，電腦使用的是office2010，找了半天也沒(méi)找到合并多個(gè)表格的設(shè)置。 在網(wǎng)上看到有人說(shuō)，先把xls文件轉(zhuǎn)為csv格式，然后通過(guò)cmd命令合并。我借鑒網(wǎng)上的代碼寫了兩個(gè)腳本文件來(lái)處理，一個(gè)bat一個(gè)vbs，vbs主要是將xls轉(zhuǎn)為csv，bat就是將文件

    2024年02月03日
    瀏覽(19)

  • SpringBoot與文檔excel，pdf集成案例分享

    Excel一款電子表格軟件。直觀的界面、出色的計(jì)算功能和圖表工具，在系統(tǒng)開發(fā)中，經(jīng)常用來(lái)把數(shù)據(jù)轉(zhuǎn)存到Excel文件，或者Excel數(shù)據(jù)導(dǎo)入系統(tǒng)中，這就涉及數(shù)據(jù)轉(zhuǎn)換問(wèn)題。 PDF是可移植文檔格式，是一種電子文件格式，具有許多其他電子文檔格式無(wú)法相比的優(yōu)點(diǎn)。PDF文件格式可以

    2024年02月16日
    瀏覽(18)
  • 【Python數(shù)據(jù)分析】利用Python將多個(gè)EXCEL表格合并為一個(gè)EXCEL表格

    【Python數(shù)據(jù)分析】利用Python將多個(gè)EXCEL表格合并為一個(gè)EXCEL表格

    ? ? ? ? 如何將EXCEL的多個(gè)表格合并成一個(gè)表格呢？比如每月銷售額是一個(gè)單獨(dú)的表格，我想把它們合并成一個(gè)表格，今天就與大家分享如何利用Python數(shù)據(jù)分析3分鐘搞定，不管你要合并多少個(gè)文件，代碼總是那么幾行。不多說(shuō)了，上案例。 ? ? ? ? ?現(xiàn)在有3個(gè)月的銷售額，需

    2023年04月24日
    瀏覽(25)

  • 將多個(gè)單獨(dú)的 Excel 文件合并成一個(gè)，并添加標(biāo)題行

    要將多個(gè)單獨(dú)的 Excel 文件合并成一個(gè)，并添加標(biāo)題行，可以使用 Python 的 pandas 庫(kù)。以下是一個(gè)示例代碼，假設(shè)要合并的 Excel 文件都在同一個(gè)文件夾中： import os import pandas as pd # 指定文件夾路徑 folder_path = \\\'path/to/folder\\\' # 獲取文件夾中所有 Excel 文件名 excel_files = [f for f in os.l

    2024年02月13日
    瀏覽(15)
  • 一個(gè)基于Excel模板快速生成Excel文檔的小工具

    一個(gè)基于Excel模板快速生成Excel文檔的小工具

    DocumentGenerator是一個(gè)Excel快速生成工具，目標(biāo)以后還能實(shí)現(xiàn)Word、pdf等的文件的生成。該程序獨(dú)立運(yùn)行，可通過(guò)HTTP接口調(diào)用其生成接口。 典型使用場(chǎng)景為如下： 使用者編寫模板文件 使用者準(zhǔn)備模板文件的填充JSON數(shù)據(jù)內(nèi)容 使用者通過(guò)網(wǎng)絡(luò)接口調(diào)用該程序服務(wù)完成模板數(shù)據(jù)自動(dòng)

    2024年02月08日
    瀏覽(21)

  • Python合并EXCEL數(shù)據(jù)（按行、按列、按sheet）

    1.按行合并多個(gè)excel文件 2.按列合并多個(gè)excel文件（多個(gè)excel文件行數(shù)需一致） 改進(jìn)版：把需要合并的excel表格放在一個(gè)文件夾，運(yùn)行代碼把該文件夾中的表格合并 這個(gè)代碼直接粘過(guò)去用就行，改綠色的部分即可，注意要把文件都放一個(gè)文件夾里。 3.按sheet合并，把一個(gè)文件里

    2024年02月15日
    瀏覽(23)
  • Springboot基于easyexcel實(shí)現(xiàn)一個(gè)excel文件包含多個(gè)sheet表格的數(shù)據(jù)導(dǎo)出

    Springboot基于easyexcel實(shí)現(xiàn)一個(gè)excel文件包含多個(gè)sheet表格的數(shù)據(jù)導(dǎo)出

    EasyExcel 是一款基于Java的開源Excel操作工具，它提供了簡(jiǎn)單且強(qiáng)大的 API，使開發(fā)人員可以輕松地讀寫、操作和生成Excel文件。 EasyExcel 支持 Excel 文件的導(dǎo)入和導(dǎo)出，可以處理大量數(shù)據(jù)，具有高性能和低內(nèi)存占用。它可以讀取 Excel 文件中的數(shù)據(jù)，并將數(shù)據(jù)轉(zhuǎn)換為 Java 對(duì)象，也可

    2024年02月03日
    瀏覽(22)

覺(jué)得文章有用就打賞一下文章作者

支付寶掃一掃打賞

博客贊助

微信掃一掃打賞

請(qǐng)作者喝杯咖啡吧~博客贊助

支付寶掃一掃領(lǐng)取紅包，優(yōu)惠每天領(lǐng)

二維碼1

領(lǐng)取紅包

二維碼2

領(lǐng)紅包