質問編集履歴
3
一部コード変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -57,5 +57,5 @@
|
|
|
57
57
|
|
|
58
58
|
write_list(ws,ws_move, start_row, start_col,row_list)
|
|
59
59
|
|
|
60
|
-
wb_move.save(filename = 'C:/Users/
|
|
60
|
+
wb_move.save(filename = 'C:/Users/copy_製造データシート.xlsm')
|
|
61
61
|
```
|
2
完成系にしました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -48,15 +48,14 @@
|
|
|
48
48
|
row_list.append(value_list)
|
|
49
49
|
|
|
50
50
|
#貼り付け
|
|
51
|
-
|
|
51
|
+
def write_list(ws,ws_move, start_row, start_col,row_list):
|
|
52
|
-
for row in row_list:
|
|
52
|
+
for y, row in enumerate(row_list):
|
|
53
|
-
|
|
53
|
+
for x, cell in enumerate(row):
|
|
54
|
-
|
|
54
|
+
ws_move.cell(row=start_row + y,
|
|
55
|
-
|
|
55
|
+
column=start_col + x,
|
|
56
|
+
value=row_list[y][x])
|
|
56
57
|
|
|
57
|
-
|
|
58
|
+
write_list(ws,ws_move, start_row, start_col,row_list)
|
|
58
|
-
```
|
|
59
59
|
|
|
60
|
-
|
|
61
|
-
|
|
62
|
-
|
|
60
|
+
wb_move.save(filename = 'C:/Users/takamatsu-k/Desktop/homicon/copy_製造データシート.xlsm')
|
|
61
|
+
```
|
1
実際のシートの写真を添付しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -55,4 +55,8 @@
|
|
|
55
55
|
row_num = row_num + 1
|
|
56
56
|
|
|
57
57
|
wb_move.save(filename = 'C:/Users/データシート.xlsx')
|
|
58
|
-
```
|
|
58
|
+
```
|
|
59
|
+
|
|
60
|
+
|
|
61
|
+
|
|
62
|
+
> 
|