pyexcel.Sheet.cut¶
-
Sheet.
cut
(topleft_corner, bottomright_corner)¶ Get a rectangle shaped data out and clear them in position
Parameters: - topleft_corner (slice) – the top left corner of the rectangle
- bottomright_corner (slice) – the bottom right corner of the rectangle
example:
>>> import pyexcel as pe >>> data = [ ... # 0 1 2 3 4 5 6 ... [1, 2, 3, 4, 5, 6, 7], # 0 ... [21, 22, 23, 24, 25, 26, 27], ... [31, 32, 33, 34, 35, 36, 37], ... [41, 42, 43, 44, 45, 46, 47], ... [51, 52, 53, 54, 55, 56, 57] # 4 ... ] >>> s = pe.Sheet(data) >>> s pyexcel sheet: +----+----+----+----+----+----+----+ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | +----+----+----+----+----+----+----+ | 21 | 22 | 23 | 24 | 25 | 26 | 27 | +----+----+----+----+----+----+----+ | 31 | 32 | 33 | 34 | 35 | 36 | 37 | +----+----+----+----+----+----+----+ | 41 | 42 | 43 | 44 | 45 | 46 | 47 | +----+----+----+----+----+----+----+ | 51 | 52 | 53 | 54 | 55 | 56 | 57 | +----+----+----+----+----+----+----+ >>> # cut 1<= row < 4, 1<= column < 5 >>> data = s.cut([1, 1], [4, 5]) >>> s pyexcel sheet: +----+----+----+----+----+----+----+ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | +----+----+----+----+----+----+----+ | 21 | | | | | 26 | 27 | +----+----+----+----+----+----+----+ | 31 | | | | | 36 | 37 | +----+----+----+----+----+----+----+ | 41 | | | | | 46 | 47 | +----+----+----+----+----+----+----+ | 51 | 52 | 53 | 54 | 55 | 56 | 57 | +----+----+----+----+----+----+----+