Excel column 256 limit

Neil Cerutti neilc at norwich.edu
Wed Mar 20 10:17:09 EDT 2013


On 2013-03-19, Ian Kelly <ian.g.kelly at gmail.com> wrote:
> On Tue, Mar 19, 2013 at 8:44 AM, Tim Chase
><python.list at tim.thechases.com> wrote:
>> On 2013-03-19 14:07, Neil Cerutti wrote:
>>> On 2013-03-18, Ana Dion?sio <anadionisio257 at gmail.com> wrote:
>>> > But I still get the error and I use Excel 2010.
>>> >
>>> > I'm trying to export data in a list to Excel
>>>
>>> xlrd: Library for developers to extract data from Microsoft Excel
>>> (tm).
>>>
>>> It is for *reading* Excel files, not writing them.
>>
>> There's xlrd[1] for reading and xlwt[2] for writing native XLS
>> files. If the OP needs greater control over things like
>> formatting and formula-cells, I'd suggest xlwt, as CSV
>> restricts you to shoveling around the data, not its
>> formatting.
>
> xlwt however only writes .xls files, not the newer .xlsx files,
> so it is still subject to the 256-column limit no matter what
> version of Excel you use to open the workbook.

It's also Python 2.3-2.7 only. :(

-- 
Neil Cerutti



More information about the Python-list mailing list