pyexcel.Sheet.project

Sheet.project(new_ordered_columns, exclusion=False)

Rearrange the sheet.

Variables:

• new_ordered_columns – new columns
• exclusion – to exlucde named column or not. defaults to False

Example:

>>> sheet = Sheet(
... [["A", "B", "C"], [1, 2, 3], [11, 22, 33], [111, 222, 333]],
... name_columns_by_row=0)
>>> sheet.project(["B", "A", "C"])
pyexcel sheet:
+-----+-----+-----+
|  B  |  A  |  C  |
+=====+=====+=====+
| 2   | 1   | 3   |
+-----+-----+-----+
| 22  | 11  | 33  |
+-----+-----+-----+
| 222 | 111 | 333 |
+-----+-----+-----+
>>> sheet.project(["B", "C"])
pyexcel sheet:
+-----+-----+
|  B  |  C  |
+=====+=====+
| 2   | 3   |
+-----+-----+
| 22  | 33  |
+-----+-----+
| 222 | 333 |
+-----+-----+
>>> sheet.project(["B", "C"], exclusion=True)
pyexcel sheet:
+-----+
|  A  |
+=====+
| 1   |
+-----+
| 11  |
+-----+
| 111 |
+-----+