pyexcel.Sheet.paste

Sheet.paste(topleft_corner, rows=None, columns=None)

Paste a rectangle shaped data after a position

Parameters:topleft_corner (slice) – the top left 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)
>>> # cut  1<= row < 4, 1<= column < 5
>>> data = s.cut([1, 1], [4, 5])
>>> s.paste([4,6], rows=data)
>>> 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 | 22 | 23 | 24 | 25 |
+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    | 32 | 33 | 34 | 35 |
+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    | 42 | 43 | 44 | 45 |
+----+----+----+----+----+----+----+----+----+----+
>>> s.paste([6,9], columns=data)
>>> 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 | 22 | 23 | 24 | 25 |    |    |
+----+----+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    | 32 | 33 | 34 | 35 |    |    |
+----+----+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    | 42 | 43 | 44 | 22 | 32 | 42 |
+----+----+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    |    |    |    | 23 | 33 | 43 |
+----+----+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    |    |    |    | 24 | 34 | 44 |
+----+----+----+----+----+----+----+----+----+----+----+----+
|    |    |    |    |    |    |    |    |    | 25 | 35 | 45 |
+----+----+----+----+----+----+----+----+----+----+----+----+