澳洲弟弟的项目代码

赵乾舟

1. from docx import Document
   
2. import os
   
3. path = 'f:/人员信息/'
   
4. list1 = []
   
5. for lujing,liebiao,wenjian in os.walk(path):
   
6.   for i in wenjian:
   
7.     url = lujing+i
   
8.     doc = Document(url)
   
9.     tables = doc.tables
   
10.     tb = tables[0]
    
11.     tb_rows = tb.rows
    
12. 
    
13.     row_data_name = []
    
14.     rows_cells = tb_rows[0].cells
    
15.     for cell in rows_cells:
    
16.         row_data_name.append(cell.text)
    
17.     name = row_data_name[2]
    
18.     print(name)
    
19. 
    
20.     row_date_xb = []
    
21.     rows_cells = tb_rows[0].cells
    
22.     for cell in rows_cells:
    
23.         row_date_xb.append(cell.text)
    
24.     xb = row_date_xb[6]
    
25.     print(xb)
    
26. 
    
27.     row_date_zy = []
    
28.     rows_cells = tb_rows[7].cells
    
29.     for cell in rows_cells:
    
30.         row_date_zy.append(cell.text)
    
31.     zy = row_date_zy[6]
    
32.     print(zy)
    
33. 
    
34.     row_date_zyt = []
    
35.     rows_cells = tb_rows[8].cells
    
36.     for cell in rows_cells:
    
37.         row_date_zyt.append(cell.text)
    
38.     zyt = row_date_zyt[4]
    
39.     print(zyt)
    
40. 
    
41. 
    
42. 
    
43. 
    
44. 
    
45. 
    
46. 
    
47. 
    
48.     row_data_tel = []
    
49.     rows_cells = tb_rows[2].cells
    
50.     for cell in rows_cells:
    
51.         row_data_tel.append(cell.text)
    
52.     tel = row_data_tel[-1]
    
53.     print(tel)
    
54. 
    
55.     row_data_name1 = []
    
56.     rows_cells = tb_rows[7].cells
    
57.     for cell in rows_cells:
    
58.         row_data_name1.append(cell.text)
    
59.     name1 = row_data_name1[2]
    
60.     print(name1)
    
61. 
    
62.     row_data_name2 = []
    
63.     rows_cells = tb_rows[10].cells
    
64.     for cell in rows_cells:
    
65.         row_data_name2.append(cell.text)
    
66.     name2 = row_data_name2[2]
    
67.     print(name2)
    
68. 
    
69. 
    
70.     list1.append([name,xb,tel,name2,name1,zy,zyt])
    
71. print(list1)
    
72. output = open('f:/人员信息/001.xls','w',encoding='gbk')
    
73. output.write('受援人\t性别\t联系电话\t案件名称\t承办人姓名\t承办人执业单位\t承办人联系电话\n')
    
74. for i in range(len(list1)):
    
75.         for j in range(len(list1[i])):
    
76.                 output.write(str(list1[i][j]))
    
77.                 output.write('\t')
    
78.         output.write('\n')
    
79. output.close()

复制代码