I assessed both the libraries for exporting data to excel. "python-excel" is far better in terms of features. "tablib" doesn't have any feature for formatting of cells (such as fore/back color, font, border, etc.) Syntax of python-excel is more human-readable (especially the "easysf" class in it).
I communicated regarding the cell-formatting issue with "Kenneth Reitz", the originator of tablib. His reply is reproduced below:-- ===== You can't do any of those things :-/ You might have more luck with http://pypi.python.org/pypi/xlwt ===== So, better to use python-excel (in my opinion). Cheers! :-) On Jul 26, 1:09 pm, Vineet <[email protected]> wrote: > Sure. > I will post here my observations after trying out the 2 excel > libraries. > > Cheers :-) > > On Jul 26, 12:26 pm, Kenneth Lundström <[email protected]> > wrote: > > > > > > > > > Please let us know which one you found to be better. I m going to need > > to switch away from CSV to a "real" Excel format in a couple of months. > > > Kenneth > > > > @selecta, > > > thanks for directing to 'tablib'. > > > It is also a good choice. > > > I am assessing whether to use 'excel-python' or 'tablib'. > > > :-| > > > > On Jul 25, 1:52 pm, Ant nio Ramos<[email protected]> wrote: > > >> How about a video tutorial exporting to excel? > > > >> 2011/7/25 selecta<[email protected]> > > > >>> Have a look at > > >>>http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/view... > > >>>http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/view... > > >>> they use tablib (which includes xlwt, ...) > > >>>http://docs.tablib.org/en/latest/index.html-Hidequoted text - > > >> - Show quoted text -- Hide quoted text - > > > - Show quoted text -
