一开始找了交叉合并,都要收费,后来就改变思路,分隔+调整+合并;
下面就是分割调整合并的思路和解决过程
引用信息
思路:用Ilovepdf来解决合并和分解问题,用excel来解决排序问题
PDF24 Tools: Free PDF solutions for all PDF problems发现这个pdf24比ilovepdf更加好用
还有免费的桌面版本,不限制大小,ilovepdf合并不能多余25个文件
1、用Ilovepdf分解为单个文档
2、用excel批量重命名,比如把1,2,3,4命名为1 3 5 7=2n-1
把另外一部分1234 命名为2468 =2n
这样两堆文件夹合并,就变成12344567,就变成交叉合并了;
下面是excel里边的源码,在wps的vba中测试过ok
Sub button_getname() Application.ScreenUpdating = False Set fso = CreateObject("scripting.filesystemobject") Set ff = fso.getfolder(ThisWorkbook.Path) 'ThisWorkbook.Path是当前代码文件所在路径,路径名可以根据需求修改 'ActiveSheet.UsedRange.ClearContents a = 2 For Each f In ff.Files Rem 如果不需要提取本代码文件名,可以增加if语句 if f.name<> thisworkbook.name then..... Rem 如果值需要提取某类文件,需要对f.name的扩展名进行判断 Rem 个人感觉split取 扩展名:split(f.name,".")(ubound(split(f.name,"."))),然后再判断,避免文件名还有其他“.” If f.Name <> ThisWorkbook.Name And f.Name <> "~$" + ThisWorkbook.Name Then Cells(a, 1) = f.Name '相对路径名 End If a = a + 1 Next f Application.ScreenUpdating = True End Sub Sub button_rename() Application.ScreenUpdating = False Set fso = CreateObject("scripting.filesystemobject") Set ff = fso.getfolder(ThisWorkbook.Path) 'ThisWorkbook.Path是当前代码文件所在路径,路径名可以根据需求修改 a = 2 For a = 2 To 3000 Rem 如果不需要提取本代码文件名,可以增加if语句 if f.name<> thisworkbook.name then..... Rem 如果值需要提取某类文件,需要对f.name的扩展名进行判断 Rem 个人感觉split取 扩展名:split(f.name,".")(ubound(split(f.name,"."))),然后再判断,避免文件名还有其他“.” If (Cells(a, 1) = "") Then Exit For End If Name ff + "\" + Cells(a, 1) As _ ff + "\" + Cells(a, 2) Next Application.ScreenUpdating = True End Sub
下面是一个例子,用来测试,把文件复制到txt然后另存为123.xml,用excle打开这个xml
把上面这段代码复制到thisworkbook里边
<?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>User</Author><LastAuthor>User</LastAuthor><Created>2022-05-10T13:41:00Z</Created><LastSaved>2022-11-18T11:16:40Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><KSOProductBuildVer dt:dt="string">2052-11.1.0.12763</KSOProductBuildVer><ICV dt:dt="string">74F3F4988C01418DBCC0E1C129EB1EDE</ICV></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>19200</WindowWidth><WindowHeight>7130</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s49"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s50"><Interior ss:Color="#FFFF00" ss:Pattern="Solid"/></Style><Style ss:ID="s51"><NumberFormat/></Style></Styles><Worksheet ss:Name="修改主界面"><Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="117" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="14"><Column ss:Index="1" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="188"/><Column ss:Index="2" ss:StyleID="s50" ss:AutoFitWidth="0" ss:Width="182"/><Row><Cell><Data ss:Type="String">原文件名</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">改变后的文件名</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-1.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">1.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-2.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">3.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-3.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">2.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-4.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">5.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-5.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">4.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-6.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">7.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-7.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">6.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-8.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">9.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-9.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">8.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-10.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">11.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-11.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">10.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-12.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">13.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-13.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">12.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-14.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">15.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell><Data ss:Type="String">19、双面-红色-15.pdf</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">14.pdf</Data></Cell><Cell ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row><Row><Cell ss:Index="3" ss:StyleID="s51"/></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>1</ActiveRow><ActiveCol>1</ActiveCol><RangeSelection>R2C2</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet><Worksheet ss:Name="修改辅助"><Table ss:ExpandedColumnCount="10" ss:ExpandedRowCount="16" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="14"><Column ss:Index="1" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="173.5"/><Column ss:Index="2" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="75.5" ss:Span="1"/><Column ss:Index="4" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="178.5"/><Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="86"/><Column ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="88.5" ss:Span="1"/><Column ss:Index="8" ss:StyleID="s49" ss:AutoFitWidth="0" ss:Width="86"/><Row><Cell><Data ss:Type="String">原文件名</Data></Cell><Cell><Data ss:Type="String">后缀</Data></Cell><Cell><Data ss:Type="String">后缀内容</Data></Cell><Cell><Data ss:Type="String">文件没有后缀</Data></Cell><Cell><Data ss:Type="String">修改后的文件名</Data></Cell><Cell><Data ss:Type="String">修改后的后缀</Data></Cell><Cell><Data ss:Type="String">修改后的名称</Data></Cell><Cell><Data ss:Type="String">修改后的文件名</Data></Cell><Cell ss:Index="10"><Data ss:Type="String">改变</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-1.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-1</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">1</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">1.pdf</Data></Cell><Cell><Data ss:Type="String">1</Data></Cell><Cell><Data ss:Type="Number">1</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">1.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-2.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-2</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">2</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">2.pdf</Data></Cell><Cell><Data ss:Type="String">2</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">3</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">3.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-3.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-3</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">3</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">3.pdf</Data></Cell><Cell><Data ss:Type="String">3</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">2</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">2.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-4.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-4</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">4</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">4.pdf</Data></Cell><Cell><Data ss:Type="String">4</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">5</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">5.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-5.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-5</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">5</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">5.pdf</Data></Cell><Cell><Data ss:Type="String">5</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">4</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">4.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-6.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-6</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">6</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">6.pdf</Data></Cell><Cell><Data ss:Type="String">6</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">7</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">7.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-7.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-7</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">7</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">7.pdf</Data></Cell><Cell><Data ss:Type="String">7</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">6</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">6.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-8.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-8</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">8</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">8.pdf</Data></Cell><Cell><Data ss:Type="String">8</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">9</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">9.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-9.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-9</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">9</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">9.pdf</Data></Cell><Cell><Data ss:Type="String">9</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">8</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">8.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-10.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-10</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">10</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">10.pdf</Data></Cell><Cell><Data ss:Type="String">10</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">11</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">11.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-11.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-11</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">11</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">11.pdf</Data></Cell><Cell><Data ss:Type="String">11</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">10</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">10.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-12.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">12</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">12.pdf</Data></Cell><Cell><Data ss:Type="String">12</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">13</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">13.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-13.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-13</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">13</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">13.pdf</Data></Cell><Cell><Data ss:Type="String">13</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">12.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-14.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-14</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">14</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">14.pdf</Data></Cell><Cell><Data ss:Type="String">14</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">15</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">15.pdf</Data></Cell></Row><Row><Cell><Data ss:Type="String">19、双面-红色-15.pdf</Data></Cell><Cell ss:Formula="=FIND(".",RC[-1],1)"><Data ss:Type="Number">12</Data></Cell><Cell ss:Formula="=RIGHT(RC[-2],LEN(RC[-2])-RC[-1])"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=LEFT(RC[-3],RC[-2]-1)"><Data ss:Type="String">19、双面-红色-15</Data></Cell><Cell ss:Formula="=RIGHT(RC[-1],LEN(RC[-1])-FIND("色-",RC[-1],1)-1)"><Data ss:Type="String">15</Data></Cell><Cell ss:Formula="=RC[-3]"><Data ss:Type="String">pdf</Data></Cell><Cell ss:Formula="=RC[-2]&"."&RC[-1]"><Data ss:Type="String">15.pdf</Data></Cell><Cell><Data ss:Type="String">15</Data></Cell><Cell ss:Formula="=IF(MOD(RC[-1],2)=1,RC[-1]-1,RC[-1]+1)"><Data ss:Type="Number">14</Data></Cell><Cell ss:Formula="=RC[-1]&"."&RC[-4]"><Data ss:Type="String">14.pdf</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><TopRowVisible>0</TopRowVisible><LeftColumnVisible>1</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>0</ActiveRow><ActiveCol>9</ActiveCol><RangeSelection>R1C10:R16C10</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>