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 -- https://mail.python.org/mailman/listinfo/python-list
