Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #57980 > unrolled thread

xlutils 1.7.0 released!

Back to article view | Back to comp.lang.python

Contents

  xlutils 1.7.0 released! Chris Withers <chris@simplistix.co.uk> - 2013-10-29 23:26 +0000

#57980 — xlutils 1.7.0 released!

Hi All,

I'm pleased to announce the release of xlutils 1.7.0:

http://pypi.python.org/pypi/xlutils/1.7.0

This release features a handy new view module that lets you do things like:

 >>> def print_data(rows):
...     for row in rows:
...         for value in row:
...             print value,
...         print

 >>> from xlutils.view import View, Row, Col
 >>> print_data(view['Sheet1'][:2, :1])
R0C0
R1C0
 >>> print_data(view['Sheet1'][Row(1):Row(2), Col('A'):Col('B')])
R0C0 R0C1
R1C0 R1C1

There's also some help for values that are dates or times:

 >>> for row in View(join(test_files,'date.xls'))[0]:
...     for value in row:
...         print repr(value)
datetime.datetime(2012, 4, 13, 0, 0)

Please have a play and let me know what you think.

Full docs here:

http://pythonhosted.org/xlutils/

Details of all things Python and Excel related can be found here:

http://www.python-excel.org/

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
             - http://www.simplistix.co.uk

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web