質問編集履歴
3
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -224,7 +224,7 @@
|
|
224
224
|
|
225
225
|
|
226
226
|
|
227
|
-
folder_path = r"C:\Users\
|
227
|
+
folder_path = r"C:\Users\Desktop\new_dir"
|
228
228
|
|
229
229
|
|
230
230
|
|
2
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -220,7 +220,7 @@
|
|
220
220
|
|
221
221
|
import openpyxl
|
222
222
|
|
223
|
-
|
223
|
+
import os
|
224
224
|
|
225
225
|
|
226
226
|
|
@@ -254,36 +254,38 @@
|
|
254
254
|
|
255
255
|
# 以下コピー先のファイルでelse内の処理を行う
|
256
256
|
|
257
|
+
PE_path = provisional_path + "\" + os.path.basename(check_file_path)
|
258
|
+
|
259
|
+
process(PE_path)
|
260
|
+
|
261
|
+
else:
|
262
|
+
|
263
|
+
print("成功")
|
264
|
+
|
257
265
|
process(check_file_path)
|
258
266
|
|
267
|
+
|
268
|
+
|
269
|
+
|
270
|
+
|
271
|
+
|
272
|
+
|
273
|
+
|
274
|
+
|
275
|
+
def recursive_file_check(path):
|
276
|
+
|
277
|
+
if os.path.isdir(path):
|
278
|
+
|
279
|
+
# directoryだったら中のファイルに対して再帰的にこの関数を実行
|
280
|
+
|
281
|
+
files = os.listdir(path)
|
282
|
+
|
283
|
+
for file in files:
|
284
|
+
|
285
|
+
recursive_file_check(path + "\" + file)
|
286
|
+
|
259
287
|
else:
|
260
288
|
|
261
|
-
print("成功")
|
262
|
-
|
263
|
-
process(check_file_path)
|
264
|
-
|
265
|
-
|
266
|
-
|
267
|
-
|
268
|
-
|
269
|
-
|
270
|
-
|
271
|
-
|
272
|
-
|
273
|
-
def recursive_file_check(path):
|
274
|
-
|
275
|
-
if os.path.isdir(path):
|
276
|
-
|
277
|
-
# directoryだったら中のファイルに対して再帰的にこの関数を実行
|
278
|
-
|
279
|
-
files = os.listdir(path)
|
280
|
-
|
281
|
-
for file in files:
|
282
|
-
|
283
|
-
recursive_file_check(path + "\" + file)
|
284
|
-
|
285
|
-
else:
|
286
|
-
|
287
289
|
# Excelファイルだったら処理
|
288
290
|
|
289
291
|
if path[-5:] == ".xlsx":
|
1
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -220,10 +220,6 @@
|
|
220
220
|
|
221
221
|
import openpyxl
|
222
222
|
|
223
|
-
path = r"C:\Users\Desktop\関連性可視化_20211207-1719.xlsx"
|
224
|
-
|
225
|
-
wb = openpyxl.load_workbook(path)
|
226
|
-
|
227
223
|
|
228
224
|
|
229
225
|
|