-
Notifications
You must be signed in to change notification settings - Fork 1
/
homework_8_sol.py
44 lines (29 loc) · 1.34 KB
/
homework_8_sol.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
from openpyxl import load_workbook
word_wb = load_workbook("words.xlsx")
word_ws = word_wb.get_sheet_by_name("words")
print("{:-^20}".format(" problem 1 "))
problem1_ws = word_wb.create_sheet("problem1")
for row_i, word in enumerate(word_ws["A"]):
problem1_ws.cell(row=row_i + 1, column=1, value=word.value)
#word_wb.save("problem1.xlsx")
print("{:-^20}".format(" problem 2 "))
problem2_ws = word_wb.create_sheet("problem2")
for row_i, row in enumerate(word_ws.iter_rows()):
en_word = row[0].value
insert_en_word = en_word[0] + "_" * (len(en_word) - 1)
problem2_ws.cell(row=row_i + 1, column=1, value=row[1].value)
problem2_ws.cell(row=row_i + 1, column=2, value=insert_en_word)
word_wb.save("problem2.xlsx")
print("{:-^20}".format(" problem 3 "))
problem3_ws = word_wb.create_sheet("problem3")
for row_i, row in enumerate(word_ws.iter_rows()):
problem3_ws.cell(row=row_i + 1, column=1, value=row[4].value)
en_sentence = row[3].value
word_lst = []
for word in en_sentence.split():
if word[-1] == "." or word[-1] == ",":
word_lst.append(word[0] + "_" * (len(word) - 2) + word[-1])
else:
word_lst.append(word[0] + "_" * (len(word) - 1))
problem3_ws.cell(row=row_i + 1, column=2, value=" ".join(word_lst))
word_wb.save("problem3.xlsx")