Excel column 256 limit

Ian Kelly ian.g.kelly at gmail.com
Tue Mar 19 23:09:24 CET 2013


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.



More information about the Python-list mailing list