Excellent (v0.0.1)
Python library for writing CSV and XLS files from list of OrderedDict or just a list of lists containing 2-item tuples.
Installing
pip install excellent
Writing Excel files
from collections import OrderedDict
from excellent import Writer, XL
output = open("superhero-database.xls", "wb")
sheet_manager = XL()
excel = Writer(sheet_manager, output)
sheet_manager.use_sheet("Weaknesses")
excel.write([
OrderedDict([('Superhero', 'Superman'), ('Weakness', 'Kryptonite')]),
OrderedDict([('Superhero', 'Spiderman'), ('Weakness', 'Maryjane')]),
])
sheet_manager.use_sheet("Special Powers")
excel.write([
OrderedDict([('Superhero', 'Superman'), ('Super Powers', 'X-Ray vision')]),
OrderedDict([('Superhero', 'Spiderman'), ('Super Powers', 'Release web')]),
OrderedDict([('Superhero', 'Batman'), ('Super Powers', 'Money')]),
])
sheet_manager.use_sheet("Weaknesses")
excel.write([
OrderedDict([('Superhero', 'Batman'), ('Weakness', 'Social Interactions')]),
])
# save it
excel.save()
# now open superhero-database.xls and be happy
Writing CSV files
from collections import OrderedDict
from excellent import Writer, CSV
output = open("pokemon-database.csv", "w")
csv = Writer(CSV(delimiter=';'), output)
csv.write([
OrderedDict([('Name', 'Pikachu'), ('Type', 'Electric')]),
OrderedDict([('Name', 'Jigglypuff'), ('Type', 'Normal')]),
OrderedDict([('Name', 'Mew'), ('Type', 'Psychic')]),
])
# save it
csv.save()
# now open pokemon.csv and be happy
pokemon-database.csv:
Name;Type
Pikachu;Electric
Jigglypuff;Normal
Mew;Psychic
Hacking
Install dependencies
pip install -r requirements.txt
Run the tests
make unit
make functional
Licensing
Please check the COPYING file distributed with this library