質問編集履歴
3
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -10,4 +10,10 @@
|
|
|
10
10
|
print(col)
|
|
11
11
|
|
|
12
12
|
wb.save(test_name)
|
|
13
|
-
```
|
|
13
|
+
```
|
|
14
|
+
|
|
15
|
+
#追記
|
|
16
|
+
ブック全体の値取得の方法は知っているのですが、
|
|
17
|
+
指定範囲のセルの値を取得したいと考えております。
|
|
18
|
+
何か良い方法がございましたらご教授いただければ幸いです。
|
|
19
|
+
よろしくお願いいたします。
|
2
誤記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
wb = openpyxl.load_workbook(test_name)
|
|
7
7
|
sheet1 = wb[sheet_name1]
|
|
8
8
|
|
|
9
|
-
for col in sheet1.iter_cols(min_col = 13, max_col = 24, min_row = 2, max_row =
|
|
9
|
+
for col in sheet1.iter_cols(min_col = 13, max_col = 24, min_row = 2, max_row = 50, values_only=True):
|
|
10
10
|
print(col)
|
|
11
11
|
|
|
12
12
|
wb.save(test_name)
|
1
誤記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -6,7 +6,8 @@
|
|
|
6
6
|
wb = openpyxl.load_workbook(test_name)
|
|
7
7
|
sheet1 = wb[sheet_name1]
|
|
8
8
|
|
|
9
|
-
for col in sheet1.iter_cols(min_col = 13, max_col = 24, min_row = 2, max_row =
|
|
9
|
+
for col in sheet1.iter_cols(min_col = 13, max_col = 24, min_row = 2, max_row = 1000, values_only=True):
|
|
10
|
+
print(col)
|
|
10
11
|
|
|
11
12
|
wb.save(test_name)
|
|
12
13
|
```
|