1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
import tablib
headers = ('first_name', 'last_name', 'gpa')
data = [
('John', 'Adams', 4.0),
('George', 'Washington', 2.6),
('Henry', 'Ford', 2.3)
]
data = tablib.Dataset(*data, headers=headers)
data.append(['Kenneth' ,'Reitz', 4.3])
#print '***WITH HEADERS***'
#print 'First Names:\n',
#print data['first_name']
#print '\nYAML:'
#print data.yaml
#
#print 'JSON:'
#print data.json
#
#print '\nCSV:'
#print data.csv
#
#
#print '***AND WITHOUT HEADERS***'
#
#data.headers = None
#
#print '\nYAML:'
#print data.yaml
#
#print 'JSON:'
#print data.json
#
#print '\nCSV:'
#print data.csv
book = tablib.DataBook()
book.add_book(data)
book.add_book(data)
print book.xls
|
