Re: pyExcelerator question

2006-12-19 Thread Gerry
Thanks!!! Looks great. Works for me. I'll try to submit the patch. Gerry -- http://mail.python.org/mailman/listinfo/python-list

Re: pyExcelerator question

2006-12-18 Thread John Machin
Gerry wrote: > I'd like to word wrap some cells, but not others, in an Excel > spreadsheet, using pyExcelerator and Excel 2003, SP1, under XP. > > The code below creates the spreadsheet, but both cells are > word-wrapped. > > As far as I can tell, the second call to XFStyle() overwrites a GLOBAL >

pyExcelerator question

2006-12-18 Thread Gerry
I'd like to word wrap some cells, but not others, in an Excel spreadsheet, using pyExcelerator and Excel 2003, SP1, under XP. The code below creates the spreadsheet, but both cells are word-wrapped. As far as I can tell, the second call to XFStyle() overwrites a GLOBAL wrap setting, and affects

Re: pyExcelerator question - dates map to floats?

2006-09-10 Thread skip
John> Check out my "xlrd" package. John> http://cheeseshop.python.org/pypi/xlrd/0.5.2 Very nice. Thanks for the pointer. I threw away about 75% of the xls-to-csv converter I wrote using pyExcelerator. And it worked with Python 2.3 without having to comment out all the decorators. Skip

Re: pyExcelerator question - dates map to floats?

2006-09-10 Thread skip
John> Check out my "xlrd" package. John> http://cheeseshop.python.org/pypi/xlrd/0.5.2 ... John, Thank you. I wasn't aware of it. I'd seen mention of pyExcelerator a few times recently. All I need is to read Excel spreadsheets anyway. I will check it out. I'm up for reading a go

Re: pyExcelerator question - dates map to floats?

2006-09-09 Thread John Machin
[EMAIL PROTECTED] wrote: > skip> Doing a little date math I come up with a base date of > skip> approximately (though not quite) 1900-01-01: > ... > > Reading the code in BIFFRecords.py I saw this docstring: > > This record specifies the base date for displaying date values. All >

Re: pyExcelerator question - dates map to floats?

2006-09-09 Thread skip
skip> Doing a little date math I come up with a base date of skip> approximately (though not quite) 1900-01-01: ... Reading the code in BIFFRecords.py I saw this docstring: This record specifies the base date for displaying date values. All dates are stored as count o

pyExcelerator question - dates map to floats?

2006-09-09 Thread skip
I'm experimenting with pyExcelerator and am reading an XLS file which contains dates. In Excel on my Mac they look like "09/13/06". After parsing them out of the .XLS file they are floats, e.g. 38973.0. I assume that's an offset in days. Doing a little date math I come up with a base date of ap