Control the column order when write the data output

[chfw]

pyexcel will try to do this:

C,A,B
1,2,3

==>

A,B,C
2,3,1

[doudz]

Up

records = [{'C':1, 'A':2, 'B':3}]
sheet = pyexcel.get_sheet(records=records)
sheet
pyexcel_sheet1:
+---+---+---+
| A | B | C |
+---+---+---+
| 2 | 3 | 1 |
+---+---+---+

it would be cool to be able to choose the column order

[jmpsf]

Is still no way to do this?

[chfw]

https://github.com/pyexcel/pyexcel/blob/dev/pyexcel/sheet.py#L480

records = [{'C':1, 'A':2, 'B':3}]
sheet = pyexcel.get_sheet(records=records)
sheet = sheet.project(['B', 'C', 'A'])
sheet
pyexcel_sheet1:
+---+---+---+
| B | C | A |
+---+---+---+
| 3 | 1 | 2 |
+---+---+---+