src/openpyxl/worksheet/formula.py
1# Copyright (c) 2010-2024 openpyxl
2
3from openpyxl.compat import safe_string
4
5class DataTableFormula:
6
7
8 t = "dataTable"
9
10 def __init__(self,
11 ref,
12 ca=False,
13 dt2D=False,
14 dtr=False,
15 r1=None,
16 r2=None,
17 del1=False,
18 del2=False,
19 **kw):
20 self.ref = ref
21 self.ca = ca
22 self.dt2D = dt2D
23 self.dtr = dtr
24 self.r1 = r1
25 self.r2 = r2
26 self.del1 = del1
27 self.del2 = del2
28
29
30 def __iter__(self):
31 for k in ["t", "ref", "dt2D", "dtr", "r1", "r2", "del1", "del2", "ca"]:
32 v = getattr(self, k)
33 if v:
34 yield k, safe_string(v)
35
36
37class ArrayFormula:
38
39 t = "array"
40
41
42 def __init__(self, ref, text=None):
43 self.ref = ref
44 self.text = text
45
46
47 def __iter__(self):
48 for k in ["t", "ref"]:
49 v = getattr(self, k)
50 if v:
51 yield k, safe_string(v)