Excel column 256 limit

jmcnamara13 at gmail.com jmcnamara13 at gmail.com
Sat Mar 30 17:43:19 CET 2013


On Monday, 18 March 2013 15:28:46 UTC, Ana Dionísio  wrote:
> Is there some way to go around this limit? I need to import data from python to excel and I need 1440 columns for that.

Hi,

The 256 column limit is an Excel limitation for XLS files.

Try XlsxWriter, it supports Excel's XLSX limits of 1,048,576 rows x 16,384 columns:

    http://pypi.python.org/pypi/XlsxWriter/
    https://xlsxwriter.readthedocs.org/

John



More information about the Python-list mailing list