Source code

Download source archive ↓

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)