C
Chris Withers
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:
.... for row in rows:
.... for value in row:
.... print value,
.... print
R1C0 R1C1
There's also some help for values that are dates or times:
.... 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
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:
.... for row in rows:
.... for value in row:
.... print value,
R0C0 R0C1R0C0from xlutils.view import View, Row, Col
print_data(view['Sheet1'][:2, :1])
R1C0print_data(view['Sheet1'][Row(1):Row(2), Col('A'):Col('B')])
R1C0 R1C1
There's also some help for values that are dates or times:
.... for value in row:for row in View(join(test_files,'date.xls'))[0]:
.... 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