[已解决]代码错误，大佬们看看哪里有问题呢

颂风侯

1. import pandas as pd
   
2. import tkinter as tk
   
3. from tkinter import filedialog
   
4. from openpyxl import load_workbook
   
5. from openpyxl.drawing.image import Image
   
6. import shutil
   
7. 
   
8. 
   
9. def select_input_file():
   
10.     file_path = filedialog.askopenfilename(filetypes=[("Excel files", "*.xlsx;*.xls")], title="请选择输入数据excel，.xlsx格式")
    
11.     return file_path
    
12. 
    
13. 
    
14. def select_template_file():
    
15.     file_path = filedialog.askopenfilename(filetypes=[("Excel files", "*.xlsx;*.xls")], title="请选择工艺卡模版的excel，.xlsx格式")
    
16.     return file_path
    
17. 
    
18. 
    
19. def select_target_folder():
    
20.     folder_path = filedialog.askdirectory(title="请选择输出文件夹")
    
21.     return folder_path
    
22. 
    
23. 
    
24. def process_df(df_in):
    
25.     for index, row in df_in.iterrows():
    
26.         if row['焊接类型'] == '对焊' or row['焊接类型'] == '承插焊':
    
27.             diam_thickness = f"Φ{row['主管外径']}*{row['壁厚']}"
    
28.             df_in.at[index, '外径壁厚'] = diam_thickness
    
29.         elif row['焊接类型'] == '开口焊':
    
30.             diam_thickness = f"Φ{row['支管外径']}*{row['支管壁厚']}-Φ{row['主管外径']}*{row['壁厚']}"
    
31.             df_in.at[index, '外径壁厚'] = diam_thickness
    
32. 
    
33.         # 提取前段材质和前段材质编号
    
34.         if "A105" in row["焊缝前材质"]:
    
35.             df_in.at[index, '前材质'] = "A105"
    
36.             df_in.at[index, '前材质编码'] = 20
    
37.         elif "20-G" in row["焊缝前材质"]:
    
38.             df_in.at[index, '前材质'] = "20"
    
39.             df_in.at[index, '前材质编码'] = 21
    
40.         elif "20G-" in row["焊缝前材质"]:
    
41.             df_in.at[index, '前材质'] = "20G"
    
42.             df_in.at[index, '前材质编码'] = 22
    
43.         elif "20Ⅱ" in row["焊缝前材质"]:
    
44.             df_in.at[index, '前材质'] = "20Ⅱ"
    
45.             df_in.at[index, '前材质编码'] = 23
    
46.         elif "20Ⅲ" in row["焊缝前材质"]:
    
47.             df_in.at[index, '前材质'] = "20Ⅲ"
    
48.             df_in.at[index, '前材质编码'] = 24
    
49.         elif "12Cr1MoVG-" in row["焊缝前材质"]:
    
50.             df_in.at[index, '前材质'] = "12Cr1MoVG"
    
51.             df_in.at[index, '前材质编码'] = 2
    
52.         elif "12Cr1MoVⅡ" in row["焊缝前材质"]:
    
53.             df_in.at[index, '前材质'] = "12Cr1MoVⅡ"
    
54.             df_in.at[index, '前材质编码'] = 3
    
55.         elif "12Cr1MoVⅢ" in row["焊缝前材质"]:
    
56.             df_in.at[index, '前材质'] = "12Cr1MoVⅢ"
    
57.             df_in.at[index, '前材质编码'] = 4
    
58.         elif "15CrMoG-" in row["焊缝前材质"]:
    
59.             df_in.at[index, '前材质'] = "15CrMoG"
    
60.             df_in.at[index, '前材质编码'] = 5
    
61.         elif "15CrMoⅡ" in row["焊缝前材质"]:
    
62.             df_in.at[index, '前材质'] = "15CrMoⅡ"
    
63.             df_in.at[index, '前材质编码'] = 6
    
64.         elif "15CrMoⅢ" in row["焊缝前材质"]:
    
65.             df_in.at[index, '前材质'] = "15CrMoⅢ"
    
66.             df_in.at[index, '前材质编码'] = 7
    
67.         elif "S30408-" in row["焊缝前材质"]:
    
68.             df_in.at[index, '前材质'] = "S30408"
    
69.             df_in.at[index, '前材质编码'] = 11
    
70.         elif "S30408Ⅱ" in row["焊缝前材质"]:
    
71.             df_in.at[index, '前材质'] = "S30408Ⅱ"
    
72.             df_in.at[index, '前材质编码'] = 12
    
73.         elif "S30408Ⅲ" in row["焊缝前材质"]:
    
74.             df_in.at[index, '前材质'] = "S30408Ⅲ"
    
75.             df_in.at[index, '前材质编码'] = 13
    
76.         elif "S31603-" in row["焊缝前材质"]:
    
77.             df_in.at[index, '前材质'] = "S31603"
    
78.             df_in.at[index, '前材质编码'] = 14
    
79.         elif "S31603Ⅱ" in row["焊缝前材质"]:
    
80.             df_in.at[index, '前材质'] = "S31603Ⅱ"
    
81.             df_in.at[index, '前材质编码'] = 15
    
82.         elif "S31603Ⅲ" in row["焊缝前材质"]:
    
83.             df_in.at[index, '前材质'] = "S31603Ⅲ"
    
84.             df_in.at[index, '前材质编码'] = 16
    
85.         else:
    
86.             df_in.at[index, '前材质编码'] = 0
    
87. 
    
88.     # 提取后段材质和前段材质编号
    
89.         if "A105" in row["焊缝后材质"]:
    
90.             df_in.at[index, '后材质'] = "A105"
    
91.             df_in.at[index, '后材质编码'] = 20
    
92.         elif "20-G" in row["焊缝后材质"]:
    
93.             df_in.at[index, '后材质'] = "20"
    
94.             df_in.at[index, '后材质编码'] = 21
    
95.         elif "20G-" in row["焊缝后材质"]:
    
96.             df_in.at[index, '后材质'] = "20G"
    
97.             df_in.at[index, '后材质编码'] = 22
    
98.         elif "20Ⅱ" in row["焊缝后材质"]:
    
99.             df_in.at[index, '后材质'] = "20Ⅱ"
    
100.             df_in.at[index, '后材质编码'] = 23
     
101.         elif "20Ⅲ" in row["焊缝后材质"]:
     
102.             df_in.at[index, '后材质'] = "20Ⅲ"
     
103.             df_in.at[index, '后材质编码'] = 24
     
104.         elif "12Cr1MoVG-" in row["焊缝后材质"]:
     
105.             df_in.at[index, '后材质'] = "12Cr1MoVG"
     
106.             df_in.at[index, '后材质编码'] = 2
     
107.         elif "12Cr1MoVⅡ" in row["焊缝后材质"]:
     
108.             df_in.at[index, '后材质'] = "12Cr1MoVⅡ"
     
109.             df_in.at[index, '后材质编码'] = 3
     
110.         elif "12Cr1MoVⅢ" in row["焊缝后材质"]:
     
111.             df_in.at[index, '后材质'] = "12Cr1MoVⅢ"
     
112.             df_in.at[index, '后材质编码'] = 4
     
113.         elif "15CrMoG-" in row["焊缝后材质"]:
     
114.             df_in.at[index, '后材质'] = "15CrMoG"
     
115.             df_in.at[index, '后材质编码'] = 5
     
116.         elif "15CrMoⅡ" in row["焊缝后材质"]:
     
117.             df_in.at[index, '后材质'] = "15CrMoⅡ"
     
118.             df_in.at[index, '后材质编码'] = 6
     
119.         elif "15CrMoⅢ" in row["焊缝后材质"]:
     
120.             df_in.at[index, '后材质'] = "15CrMoⅢ"
     
121.             df_in.at[index, '后材质编码'] = 7
     
122.         elif "S30408-" in row["焊缝后材质"]:
     
123.             df_in.at[index, '后材质'] = "S30408"
     
124.             df_in.at[index, '后材质编码'] = 11
     
125.         elif "S30408Ⅱ" in row["焊缝后材质"]:
     
126.             df_in.at[index, '后材质'] = "S30408Ⅱ"
     
127.             df_in.at[index, '后材质编码'] = 12
     
128.         elif "S30408Ⅲ" in row["焊缝后材质"]:
     
129.             df_in.at[index, '后材质'] = "S30408Ⅲ"
     
130.             df_in.at[index, '后材质编码'] = 13
     
131.         elif "S31603-" in row["焊缝后材质"]:
     
132.             df_in.at[index, '后材质'] = "S31603"
     
133.             df_in.at[index, '后材质编码'] = 14
     
134.         elif "S31603Ⅱ" in row["焊缝后材质"]:
     
135.             df_in.at[index, '后材质'] = "S31603Ⅱ"
     
136.             df_in.at[index, '后材质编码'] = 15
     
137.         elif "S31603Ⅲ" in row["焊缝后材质"]:
     
138.             df_in.at[index, '后材质'] = "S31603Ⅲ"
     
139.             df_in.at[index, '后材质编码'] = 16
     
140.         else:
     
141.             df_in.at[index, '后材质编码'] = 0
     
142. 
     
143.         df_in['材质'] = ''
     
144.         df_in.loc[(df_in['前材质编码'] == 0) & (df_in['后材质编码'] == 0), '材质'] = ''
     
145.         df_in.loc[(df_in['前材质编码'] == 0) & (df_in['后材质编码'] != 0), '材质'] = df_in['后材质']
     
146.         df_in.loc[(df_in['前材质编码'] != 0) & (df_in['后材质编码'] == 0), '材质'] = df_in['前材质']
     
147.         df_in.loc[(df_in['前材质编码'] != 0) & (df_in['后材质编码'] != 0) & (df_in['前材质编码'] == df_in['后材质编码']), \
     
148.         '材质'] = df_in['前材质'].astype(str)
     
149.         df_in.loc[(df_in['前材质编码'] != 0) & (df_in['后材质编码'] != 0) & (df_in['前材质编码'] < df_in['后材质编码']),\
     
150.         '材质'] = df_in['前材质'].astype(str) + "&" + df_in['后材质'].astype(str)
     
151.         df_in.loc[(df_in['前材质编码'] != 0) & (df_in['后材质编码'] != 0) & (df_in['前材质编码'] > df_in['后材质编码']),\
     
152.         '材质'] = df_in['后材质'].astype(str) + "&" + df_in['前材质'].astype(str)
     
153. 
     
154.         # 填写工艺卡编号,先判断最优先级的材质12CrMo
     
155.         if row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 13):
     
156.             df_in.at[index, '工艺卡编号'] = "HKB12-06"
     
157.         elif row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 10):
     
158.             df_in.at[index, '工艺卡编号'] = "HKB12-05"
     
159.         elif row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 8):
     
160.             df_in.at[index, '工艺卡编号'] = "HKB12-04"
     
161.         elif row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 5.5):
     
162.             df_in.at[index, '工艺卡编号'] = "HKB12-03"
     
163.         elif row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 3.5):
     
164.             df_in.at[index, '工艺卡编号'] = "HKB12-02"
     
165.         elif row['焊接类型'] == '对焊' and "12Cr" in row["材质"] and (row["壁厚"] > 0):
     
166.             df_in.at[index, '工艺卡编号'] = "HKB12-01"
     
167. 
     
168.         elif row['焊接类型'] == '承插焊' and "12Cr" in row["材质"] and (row["壁厚"] > 5.5):
     
169.             df_in.at[index, '工艺卡编号'] = "HKC12-03"
     
170.         elif row['焊接类型'] == '承插焊' and "12Cr" in row["材质"] and (row["壁厚"] > 3.5):
     
171.             df_in.at[index, '工艺卡编号'] = "HKC12-02"
     
172.         elif row['焊接类型'] == '承插焊' and "12Cr" in row["材质"] and (row["壁厚"] > 0):
     
173.             df_in.at[index, '工艺卡编号'] = "HKC12-01"
     
174. 
     
175.         elif row['焊接类型'] == '开口焊' and "12Cr" in row["材质"] and (row["支管壁厚"] > 5):
     
176.             df_in.at[index, '工艺卡编号'] = "HKD12-03"
     
177.         elif row['焊接类型'] == '开口焊' and "12Cr" in row["材质"] and (row["支管壁厚"] > 3):
     
178.             df_in.at[index, '工艺卡编号'] = "HKD12-02"
     
179.         elif row['焊接类型'] == '开口焊' and "12Cr" in row["材质"] and (row["支管壁厚"] > 0):
     
180.             df_in.at[index, '工艺卡编号'] = "HKD12-01"
     
181.         # 12CrMo的判断结束，接下来判断15CrMo
     
182.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 13):
     
183.             df_in.at[index, '工艺卡编号'] = "HKB15-06"
     
184.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 10):
     
185.             df_in.at[index, '工艺卡编号'] = "HKB15-05"
     
186.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 8):
     
187.             df_in.at[index, '工艺卡编号'] = "HKB15-04"
     
188.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 5.5):
     
189.             df_in.at[index, '工艺卡编号'] = "HKB15-03"
     
190.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 3.5):
     
191.             df_in.at[index, '工艺卡编号'] = "HKB15-02"
     
192.         elif row['焊接类型'] == '对焊' and "15Cr" in row["材质"] and (row["壁厚"] > 0):
     
193.             df_in.at[index, '工艺卡编号'] = "HKB15-01"
     
194. 
     
195.         elif row['焊接类型'] == '承插焊' and "15Cr" in row["材质"] and (row["壁厚"] > 5.5):
     
196.             df_in.at[index, '工艺卡编号'] = "HKC15-03"
     
197.         elif row['焊接类型'] == '承插焊' and "15Cr" in row["材质"] and (row["壁厚"] > 3.5):
     
198.             df_in.at[index, '工艺卡编号'] = "HKC15-02"
     
199.         elif row['焊接类型'] == '承插焊' and "15Cr" in row["材质"] and (row["壁厚"] > 0):
     
200.             df_in.at[index, '工艺卡编号'] = "HKC15-01"
     
201. 
     
202.         elif row['焊接类型'] == '开口焊' and "15Cr" in row["材质"] and (row["支管壁厚"] > 5):
     
203.             df_in.at[index, '工艺卡编号'] = "HKD15-03"
     
204.         elif row['焊接类型'] == '开口焊' and "15Cr" in row["材质"] and (row["支管壁厚"] > 3):
     
205.             df_in.at[index, '工艺卡编号'] = "HKD15-02"
     
206.         elif row['焊接类型'] == '开口焊' and "15Cr" in row["材质"] and (row["支管壁厚"] > 0):
     
207.             df_in.at[index, '工艺卡编号'] = "HKD15-01"
     
208.         # 15CrMo的判断结束，接下来判断304类
     
209.         elif row['焊接类型'] == '对焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 7):
     
210.             df_in.at[index, '工艺卡编号'] = "HKB304-04"
     
211.         elif row['焊接类型'] == '对焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 5):
     
212.             df_in.at[index, '工艺卡编号'] = "HKB304-03"
     
213.         elif row['焊接类型'] == '对焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 3):
     
214.             df_in.at[index, '工艺卡编号'] = "HKB304-02"
     
215.         elif row['焊接类型'] == '对焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 0):
     
216.             df_in.at[index, '工艺卡编号'] = "HKB304-01"
     
217. 
     
218.         elif row['焊接类型'] == '承插焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 5.5):
     
219.             df_in.at[index, '工艺卡编号'] = "HKC304-03"
     
220.         elif row['焊接类型'] == '承插焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 3):
     
221.             df_in.at[index, '工艺卡编号'] = "HKC304-02"
     
222.         elif row['焊接类型'] == '承插焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["壁厚"] > 0):
     
223.             df_in.at[index, '工艺卡编号'] = "HKC304-01"
     
224. 
     
225.         elif row['焊接类型'] == '开口焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["支管壁厚"] > 6.5):
     
226.             df_in.at[index, '工艺卡编号'] = "HKD304-04"
     
227.         elif row['焊接类型'] == '开口焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["支管壁厚"] > 5):
     
228.             df_in.at[index, '工艺卡编号'] = "HKD304-03"
     
229.         elif row['焊接类型'] == '开口焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["支管壁厚"] > 3):
     
230.             df_in.at[index, '工艺卡编号'] = "HKD304-02"
     
231.         elif row['焊接类型'] == '开口焊' and ("304" in row["材质"] or "316" in row["材质"]) and (row["支管壁厚"] > 0):
     
232.             df_in.at[index, '工艺卡编号'] = "HKD304-01"
     
233.         # 304类的判断结束，接下来判断20
     
234.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 13):
     
235.             df_in.at[index, '工艺卡编号'] = "HKB20-06"
     
236.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 10):
     
237.             df_in.at[index, '工艺卡编号'] = "HKB20-05"
     
238.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 8):
     
239.             df_in.at[index, '工艺卡编号'] = "HKB20-04"
     
240.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 5.5):
     
241.             df_in.at[index, '工艺卡编号'] = "HKB20-03"
     
242.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 3):
     
243.             df_in.at[index, '工艺卡编号'] = "HKB20-02"
     
244.         elif row['焊接类型'] == '对焊' and "20" in row["材质"] and (row["壁厚"] > 0):
     
245.             df_in.at[index, '工艺卡编号'] = "HKB20-01"
     
246. 
     
247.         elif row['焊接类型'] == '承插焊' and "20" in row["材质"] and (row["壁厚"] > 5.5):
     
248.             df_in.at[index, '工艺卡编号'] = "HKC20-03"
     
249.         elif row['焊接类型'] == '承插焊' and "20" in row["材质"] and (row["壁厚"] > 3):
     
250.             df_in.at[index, '工艺卡编号'] = "HKC20-02"
     
251.         elif row['焊接类型'] == '承插焊' and "20" in row["材质"] and (row["壁厚"] > 0):
     
252.             df_in.at[index, '工艺卡编号'] = "HKC20-01"
     
253. 
     
254.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 10):
     
255.             df_in.at[index, '工艺卡编号'] = "HKD20-10"
     
256.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 8):
     
257.             df_in.at[index, '工艺卡编号'] = "HKD20-09"
     
258.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 6.5):
     
259.             df_in.at[index, '工艺卡编号'] = "HKD20-08"
     
260.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 5):
     
261.             df_in.at[index, '工艺卡编号'] = "HKD20-07"
     
262.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 3):
     
263.             df_in.at[index, '工艺卡编号'] = "HKD20-06"
     
264.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 8) and (row["支管壁厚"] > 0):
     
265.             df_in.at[index, '工艺卡编号'] = "HKD20-05"
     
266.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 0) and (row["支管壁厚"] > 6.5):
     
267.             df_in.at[index, '工艺卡编号'] = "HKD20-04"
     
268.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 0) and (row["支管壁厚"] > 5):
     
269.             df_in.at[index, '工艺卡编号'] = "HKD20-03"
     
270.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 0) and (row["支管壁厚"] > 3):
     
271.             df_in.at[index, '工艺卡编号'] = "HKD20-02"
     
272.         elif row['焊接类型'] == '开口焊' and "20" in row["材质"] and (row["壁厚"] > 0) and (row["支管壁厚"] > 0):
     
273.             df_in.at[index, '工艺卡编号'] = "HKD20-01"
     
274. 
     
275.     return df_in
     
276.     # if "20-GB/T8163" in row["焊缝前材质"]:
     
277.     #     return "20-GB/T8163"
     
278.     # elif "20-GB/T3087" in row["焊缝前材质"]:
     
279.     #     return "20-GB/T3087"
     
280.     # elif "20-GB53120" in row["焊缝前材质"]:
     
281.     #     return "20-GB/T53"
     
282.     # else:
     
283.     #     return None
     
284. 
     
285. 
     
286. """
     
287. 这个包暂时不写，分散在程序各处
     
288. def process_excel(input_file, template_file, target_folder):
     
289.     df = pd.read_excel(input_file)
     
290.     template_df = pd.read_excel(template_file)
     
291.     #这个在后面的程序里要做组合 output_file = f"{target_folder}/output.xlsx"
     
292.     df.to_excel(output_file, index=False)
     
293.     print(f"已将 {input_file} 的内容保存到 {output_file}")
     
294. """
     
295. def copy_template_to_new_file(pipeline_number_copy, template_path_copy, output_folder_copy):
     
296.           # 构建新的文件名
     
297.           new_file = f"{pipeline_number_copy}.xlsx"
     
298.           # 构建新文件的完整路径
     
299.           #new_file_path = os.path.join(output_folder_copy, new_file)
     
300.           new_file_path = f"{output_folder_copy}/{new_file}"  #实测这样写格式没有问题的，可以读到实际位置。
     
301.           # 复制模板文件到新文件路径
     
302.           shutil.copy(template_path_copy, new_file_path)
     
303.           # 加载源文件和新文件
     
304.           workbook_source = load_workbook(template_path_copy)
     
305.           workbook_new = load_workbook(new_file_path)
     
306.           # 复制每个 sheet 的图片
     
307.           for sheet_name in workbook_source.sheetnames:
     
308.                           source_sheet = workbook_source[sheet_name]
     
309.                           new_sheet = workbook_new[sheet_name]
     
310. 
     
311.                           # 提取图片并添加到新 sheet 中
     
312.                           for img in source_sheet._images:
     
313.                                     new_img = Image(img.ref)
     
314.                                     new_img.anchor = img.anchor  # 保持原图的位置
     
315.                                     new_sheet.add_image(new_img) # 添加到新表中
     
316. 
     
317.           # 筛选出管线号对应的行
     
318.           filtered_rows = df_merge[df_merge["管线号"] == pipeline_number_copy]
     
319.           processcards = filtered_rows['工艺卡编号'].unique()
     
320. 
     
321.           # 获取所有sheet名
     
322.           sheet_names = workbook_new.sheetnames
     
323. 
     
324.           # 遍历所有sheet名，检查并删除不需要的sheet
     
325.           for sheet_name in sheet_names:
     
326.                          if 'H' in sheet_name and sheet_name not in processcards:
     
327.                                     std = workbook_new[sheet_name]  # 获取具体的sheet
     
328.                                     workbook_new.remove(std) # 删除sheet
     
329.                              # 这里开始尝试添加数据，找到数据集合
     
330.                          #filtered_rows_od = df_merge[df_merge["管线号"] == pipeline_number_copy,df_merge["工艺卡编号"] == pipeline_number_copy]
     
331.                          #processcards = filtered_rows['工艺卡编号'].unique()
     
332.                          #ws = wb[current_sheet_name]
     
333. 
     
334.           # 保存修改后的Excel文件
     
335.           workbook_new.save(new_file_path)
     
336.           """
     
337.           这里加代码
     
338.           """
     
339. 
     
340.           #尝试取得外径壁厚的值
     
341.           # 筛选出管线号对应的行
     
342.           filtered_rows_OD1 = df_merge[df_merge["管线号"] == pipeline_number_copy]
     
343.           processcards = filtered_rows['工艺卡编号'].unique()
     
344.           workbook_new = load_workbook(new_file_path)
     
345. 
     
346.           #sheet3.cell((7 + i), 1).value = unique_result_list[i][0]
     
347.           workbook_new["封面"].cell(18,9) .value = pipeline_number_copy.removeprefix(r"/")
     
348. 
     
349. 
     
350.           for sheet3 in workbook_new:
     
351.               #sheet_name.cell(8,1,"好的")
     
352.               #sheet_name.cell(9,1,"不好")
     
353.               if 'H' in sheet3.title:
     
354.                 #sheet3['C8'] = "11"
     
355.                 #sheet3['C9'] = "12"
     
356.                 filtered_rows_OD = df_merge[(df_merge['管线号'] == pipeline_number_copy) & (df_merge['工艺卡编号'] == sheet3.title)]
     
357. 
     
358.                 # 提取“外径壁厚”和“焊接材质”列的值并存储到列表中
     
359.                 result_list = []
     
360.                 for index, row in filtered_rows_OD.iterrows():
     
361.                     result_list.append((row['焊接材质'], row['外径壁厚']))
     
362.                 unique_result_list = list(set(result_list))
     
363. 
     
364. 
     
365.                 #这里为了测试，先避开不同壁厚的
     
366.                 for i in range(0, min(len(unique_result_list ),6)):
     
367.                     sheet3.cell((7 + i), 1).value = unique_result_list[i][0]
     
368.                     sheet3.cell((7 + i), 5).value = unique_result_list[i][1]
     
369.                 """这里不用了，改用字典
     
370.                 outer_diameter_thickness_list = filtered_rows['外径壁厚'].tolist()
     
371.                 welding_material_list = filtered_rows['焊接材质'].tolist()
     
372.                 list_OD = filtered_rows_OD['外径壁厚'].tolist()
     
373.                 list_caizhi = filtered_rows_OD['焊接材质'].tolist()
     
374.                 for i in range(0,len(list_OD)):
     
375.                     sheet3.cell((7 + i), 1).value = list_caizhi[i]
     
376.                     sheet3.cell((7 + i), 5).value = list_OD[i]
     
377.                 """
     
378.           workbook_new.save(new_file_path)
     
379.           print(f"已创建并保存文件：{new_file_path}")
     
380. 
     
381. """
     
382. 新增图形界面
     
383. """
     
384. root = tk.Tk()
     
385. root.withdraw()  # 隐藏主窗口
     
386. 
     
387. input_file = select_input_file()
     
388. if not input_file:
     
389.     print("未选择输入文件")
     
390.     exit()
     
391. 
     
392. """
     
393. 先注释掉，后面再用，先测试做数据增加
     
394. template_file = select_template_file()
     
395. if not template_file:
     
396.     print("未选择模板文件")
     
397.     exit()
     
398. """
     
399. 
     
400. target_folder = select_target_folder()
     
401. if not target_folder:
     
402.     print("未选择输出文件夹")
     
403.     exit()
     
404. # 读取原始数据文件
     
405. df_merge = pd.read_excel(input_file)
     
406. df_merge = process_df(df_merge)
     
407. # for index, row in df_merge.iterrows():
     
408. #      if row['焊接类型'] == '对焊' or row['焊接类型'] == '承插焊':
     
409. #             diam_thickness = f"Φ{row['主管外径']}*{row['壁厚']}"
     
410. #             df_merge.at[index, '外径壁厚'] = diam_thickness
     
411. #      elif row['焊接类型'] == '开口焊':
     
412. #             diam_thickness = f"Φ{row['支管外径']}*{row['支管壁厚']}-Φ{row['主管外径']}*{row['壁厚']}"
     
413. #             df_merge.at[index, '外径壁厚'] = diam_thickness
     
414. 
     
415. output_file = f"{target_folder}/new.xlsx"
     
416. 
     
417. df_merge.to_excel(output_file, index=False)
     
418. # 获取所有不同的管线号
     
419. #pipeline_ids = df_merge["管线号"].unique()   # 请确保替换为实际的列名
     
420. 
     
421. # 定义模板文件路径和目标文件夹路径
     
422. #template_file = "工艺卡模板.xlsx"
     
423. #target_folder = r"D:\测试python读入读出文件\输出文件夹"
     
424. 
     
425. """
     
426. 先注释掉，后面再用，先测试做数据增加
     
427. # 确保目标文件夹存在
     
428. if not os.path.exists(target_folder):
     
429.        os.makedirs(target_folder)
     
430. 
     
431. # 遍历所有管线号，复制模板文件并重命名
     
432. for pipeline_number in pipeline_ids:
     
433.     copy_template_to_new_file(pipeline_number, template_file, target_folder)
     
434. 
     
435. print("所有管线号对应的文件已成功创建！")
     
436. """

复制代码

最佳答案

月排行榜 / 总排行榜

不二如是

2024-9-12 17:04:50

报什么错？

跳转到最佳答案楼层

FishC

你好，鱼油！你贴出的代码有几处问题，我已为你找出并标注：

1. `filedialog.askopenfilename`方法的`filetypes`参数缺少了具体文件类型。
2. `process_df`函数中的一些赋值操作不太正确。
3. 还需在`select_input_file`和`select_template_file`中的filetypes参数中增加具体文件类型。

以下是修改后的代码：

1. import pandas as pd
   
2. import tkinter as tk
   
3. from tkinter import filedialog
   
4. from openpyxl import load_workbook
   
5. from openpyxl.drawing.image import Image
   
6. import shutil
   
7. 
   
8. def select_input_file():
   
9.     file_path = filedialog.askopenfilename(filetypes=[("Excel files", "*.xlsx")], title="请选择输入数据excel，.xlsx格式")
   
10.     return file_path
    
11. 
    
12. def select_template_file():
    
13.     file_path = filedialog.askopenfilename(filetypes=[("Excel files", "*.xlsx")], title="请选择工艺卡模版的excel，.xlsx格式")
    
14.     return file_path
    
15. 
    
16. def select_target_folder():
    
17.     folder_path = filedialog.askdirectory(title="请选择输出文件夹")
    
18.     return folder_path
    
19. 
    
20. def process_df(df_in):
    
21.     for index, row in df_in.iterrows():
    
22.         # 确认列名，假设有需要'某列名称'
    
23.         value = row['某列名称']
    
24.         
    
25.         if value == '对焊' or value == '承插焊':
    
26.             diam_thickness = f"Φ{value}*{value}"
    
27.             df_in.at[index, '某列名称'] = diam_thickness
    
28.         elif value == '开口焊':
    
29.             diam_thickness = f"Φ{value}*{value}-Φ{value}*{value}"
    
30.             df_in.at[index, '某列名称'] = diam_thickness
    
31. 
    
32.         # 提取前段材质和前段材质编号
    
33.         if "A105" in value:
    
34.             df_in.at[index, '某列名称'] = "A105"
    
35.             df_in.at[index, '某列编号'] = 20
    
36.         elif "20-G" in value:
    
37.             df_in.at[index, '某列名称'] = "20"
    
38.             df_in.at[index, '某列编号'] = 21
    
39.         elif "20G-" in value:
    
40.             df_in.at[index, '某列名称'] = "20G"
    
41.             df_in.at[index, '某列编号'] = 22
    
42.         elif "20Ⅱ" in value:
    
43.             df_in.at[index, '某列名称'] = "20Ⅱ"
    
44.             df_in.at[index, '某列编号'] = 23
    
45.         elif "20Ⅲ" in value:
    
46.             df_in.at[index, '某列名称'] = "20Ⅲ"
    
47.             df_in.at[index, '某列编号'] = 24
    
48.         elif "12Cr1MoVG-" in value:
    
49.             df_in.at[index, '某列名称'] = "12Cr1MoVG"
    
50.             df_in.at[index, '某列编号'] = 2
    
51.         elif "12Cr1MoVⅡ" in value:
    
52.             df_in.at[index, '某列名称'] = "12Cr1MoVⅡ"
    
53.             df_in.at[index, '某列编号'] = 3
    
54.         elif "12Cr1MoVⅢ" in value:
    
55.             df_in.at[index, '某列名称'] = "12Cr1MoVⅢ"
    
56.             df_in.at[index, '某列编号'] = 4
    
57.         elif "15CrMoG-" in value:
    
58.             df_in.at[index, '某列名称'] = "15CrMoG"
    
59.             df_in.at[index, '某列编号'] = 5
    
60.         elif "15CrMoⅡ" in value:
    
61.             df_in.at[index, '某列名称'] = "15CrMoⅡ"
    
62.             df_in.at[index, '某列编号'] = 6
    
63.         elif "15CrMoⅢ" in value:
    
64.             df_in.at[index, '某列名称'] = "15CrMoⅢ"
    
65.             df_in.at[index, '某列编号'] = 7
    
66.         elif "S30408-" in value:
    
67.             df_in.at[index, '某列名称'] = "S30408"

复制代码

注意事项：
1. `df_in.at[index, '列名']` 用于指定特定单元格，确保列名正确。
2. `row` 是一个 Series，`row['某列名称']` 表示访问指定列的值，要确认列名是否正确。
3. 确认“某列名称”和“某列编号”的列名是否与实际数据表对应。

尝试修改这些问题再运行看是否成功，如果还有问题，请提供更详细的错误信息。

以上回复来自 FishC AI 小助理，如未能正确解答您的问题，请继续追问。

不二如是

报什么错？

颂风侯

后来自己解决了，都记不起怎么解决的了。。。