-
Notifications
You must be signed in to change notification settings - Fork 0
/
sum_colsum.py
46 lines (38 loc) · 1.27 KB
/
sum_colsum.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
45
46
class ColSumResult(object):
"""
列求和
"""
def __init__(self):
# 求和结果-列下标
self.result_index = -1
# 求和元素-列下标
self.operator_index = -1
# 求和元素-行开始
self.rowstart_index = -1
# 求和元素-行结束
self.rowend_index = -1
def set_index(self, start_row, end_row, operator_index, result_index):
self.set_rowstartindex(start_row)
self.set_rowendindex(end_row)
self.set_operatorindex(operator_index)
self.set_resultindex(result_index)
def set_resultindex(self, i):
self.result_index = i
def set_operatorindex(self, i):
self.operator_index = i
def set_rowstartindex(self, i):
self.rowstart_index = i
def set_rowendindex(self, i):
self.rowend_index = i
def get_sumstr_by_index(self, helper, startindex, endindex):
self.set_rowstartindex(startindex)
self.set_rowendindex(endindex)
return self.get_sumstr(helper)
def get_sumstr(self, helper):
if self.operator_index != -1:
beginstr = helper.get_rowcol_2_str(self.rowstart_index,
self.operator_index)
endstr = helper.get_rowcol_2_str(self.rowend_index, self.operator_index)
result = f"=SUM({beginstr}:{endstr})"
return result
return ""