質問編集履歴
2
誤字
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -50,7 +50,7 @@
|
|
|
50
50
|
|
|
51
51
|
File "excel_form.py", line 14, in <module>
|
|
52
52
|
|
|
53
|
-
if
|
|
53
|
+
if rowG.value in rowN.value:
|
|
54
54
|
|
|
55
55
|
TypeError: argument of type 'NoneType' is not iterable
|
|
56
56
|
|
1
ソースコードを全文記載しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -9,6 +9,18 @@
|
|
|
9
9
|
|
|
10
10
|
|
|
11
11
|
```python
|
|
12
|
+
|
|
13
|
+
|
|
14
|
+
|
|
15
|
+
book = openpyxl.load_workbook(file_path)
|
|
16
|
+
|
|
17
|
+
sheet = book.worksheets[0]
|
|
18
|
+
|
|
19
|
+
|
|
20
|
+
|
|
21
|
+
match_list = []
|
|
22
|
+
|
|
23
|
+
|
|
12
24
|
|
|
13
25
|
#エクセルシートからG列の値にN列のセルの値が部分一致している値を抽出
|
|
14
26
|
|