質問編集履歴
3
一部コード変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -116,6 +116,6 @@
|
|
|
116
116
|
|
|
117
117
|
|
|
118
118
|
|
|
119
|
-
wb_move.save(filename = 'C:/Users/
|
|
119
|
+
wb_move.save(filename = 'C:/Users/copy_製造データシート.xlsm')
|
|
120
120
|
|
|
121
121
|
```
|
2
完成系にしました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -98,26 +98,24 @@
|
|
|
98
98
|
|
|
99
99
|
#貼り付け
|
|
100
100
|
|
|
101
|
-
r
|
|
101
|
+
def write_list(ws,ws_move, start_row, start_col,row_list):
|
|
102
102
|
|
|
103
|
-
for row in row_list:
|
|
103
|
+
for y, row in enumerate(row_list):
|
|
104
104
|
|
|
105
|
-
|
|
105
|
+
for x, cell in enumerate(row):
|
|
106
106
|
|
|
107
|
-
ws_move.
|
|
107
|
+
ws_move.cell(row=start_row + y,
|
|
108
108
|
|
|
109
|
-
|
|
109
|
+
column=start_col + x,
|
|
110
|
+
|
|
111
|
+
value=row_list[y][x])
|
|
110
112
|
|
|
111
113
|
|
|
112
114
|
|
|
113
|
-
w
|
|
115
|
+
write_list(ws,ws_move, start_row, start_col,row_list)
|
|
114
|
-
|
|
115
|
-
```
|
|
116
116
|
|
|
117
117
|
|
|
118
118
|
|
|
119
|
-
|
|
119
|
+
wb_move.save(filename = 'C:/Users/takamatsu-k/Desktop/homicon/copy_製造データシート.xlsm')
|
|
120
120
|
|
|
121
|
-
|
|
122
|
-
|
|
123
|
-
|
|
121
|
+
```
|
1
実際のシートの写真を添付しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -113,3 +113,11 @@
|
|
|
113
113
|
wb_move.save(filename = 'C:/Users/データシート.xlsx')
|
|
114
114
|
|
|
115
115
|
```
|
|
116
|
+
|
|
117
|
+
|
|
118
|
+
|
|
119
|
+
|
|
120
|
+
|
|
121
|
+
|
|
122
|
+
|
|
123
|
+
> 
|