Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41435 > unrolled thread

Excel column 256 limit

Back to article view | Back to comp.lang.python

Contents

  Excel column 256 limit Ana Dionísio <anadionisio257@gmail.com> - 2013-03-18 08:28 -0700
    Re: Excel column 256 limit Dave Angel <davea@davea.name> - 2013-03-18 11:48 -0400
      Re: Excel column 256 limit Grant Edwards <invalid@invalid.invalid> - 2013-03-18 16:28 +0000
    Re: Excel column 256 limit Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-03-18 15:50 +0000
      Re: Excel column 256 limit "Michael Ross" <gmx@ross.cx> - 2013-03-18 18:38 +0100
        Re: Excel column 256 limit Ana Dionísio <anadionisio257@gmail.com> - 2013-03-18 12:00 -0700
          Re: Excel column 256 limit Christian Gollwitzer <auriocus@gmx.de> - 2013-03-18 20:04 +0100
          Re: Excel column 256 limit Neil Cerutti <neilc@norwich.edu> - 2013-03-19 14:07 +0000
            Re: Excel column 256 limit "Michael Ross" <gmx@ross.cx> - 2013-03-19 15:22 +0100
            Re: Excel column 256 limit Tim Chase <python.list@tim.thechases.com> - 2013-03-19 09:44 -0500
            Re: Excel column 256 limit Ian Kelly <ian.g.kelly@gmail.com> - 2013-03-19 16:09 -0600
              Re: Excel column 256 limit Neil Cerutti <neilc@norwich.edu> - 2013-03-20 14:17 +0000
        Re: Excel column 256 limit Ana Dionísio <anadionisio257@gmail.com> - 2013-03-18 12:00 -0700
      Re: Excel column 256 limit Rotwang <sg552@hotmail.co.uk> - 2013-03-19 15:25 +0000
    Re: Excel column 256 limit Dietmar Schwertberger <maillist@schwertberger.de> - 2013-03-18 18:00 +0100
    Re: Excel column 256 limit jmcnamara13@gmail.com - 2013-03-30 09:43 -0700

#41435 — Excel column 256 limit

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.

[toc] | [next] | [standalone]

#41436

On 03/18/2013 11:28 AM, 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.
>

Doesn't sound like a Python question.  But one answer is Libre Office 
Calc, which seems to have a 1024 column limit.


-- 
DaveA

[toc] | [prev] | [next] | [standalone]

#41438

On 2013-03-18, Dave Angel <davea@davea.name> wrote:
> On 03/18/2013 11:28 AM, 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.
>
> Doesn't sound like a Python question.  But one answer is Libre Office 
> Calc, which seems to have a 1024 column limit.

[I don't see how something with a 1024 column limit is one answer for
a requirement of 1440 columns.]

IMO, if 256 columns isn't enough, then a spreadsheet probably isn't
the right tool.  If you need 1440 columns then I can't even imagine a
case where a spreadsheet is the right tool.

I've seen people spend weeks trying to do something with excel that
would have taken a few hours using Numpy/Scipy/Scientific-Python.

-- 
Grant Edwards               grant.b.edwards        Yow! I want to kill
                                  at               everyone here with a cute
                              gmail.com            colorful Hydrogen Bomb!!

[toc] | [prev] | [next] | [standalone]

#41437

On Mon, 18 Mar 2013 08:28:46 -0700, 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.

That's an Excel question, it has nothing to do with Python.

Have you considered using something other than Excel? As I understand it, 
OpenOffice, LibreOffice, and Gnumeric do not have a 256 column limit. 
Gnumeric is Linux-only, but the other two are available for Windows and 
Mac, and they are all free, open source software, and they all will read 
and write Excel spreadsheets.


http://openoffice.org/
http://www.libreoffice.org/
http://projects.gnome.org/gnumeric/index.shtml



-- 
Steven

[toc] | [prev] | [next] | [standalone]

#41443

On Mon, 18 Mar 2013 16:50:21 +0100, Steven D'Aprano  
<steve+comp.lang.python@pearwood.info> wrote:

> On Mon, 18 Mar 2013 08:28:46 -0700, 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.
>
> That's an Excel question, it has nothing to do with Python.
>
> Have you considered using something other than Excel? As I understand it,
> OpenOffice, LibreOffice, and Gnumeric do not have a 256 column limit.

Just for completeness:
Excel in it's "Office 2010" version does not have a 256 column limit  
either.
I can use > 2000 columns without problem.

[toc] | [prev] | [next] | [standalone]

#41449

But I still get the error and I use Excel 2010.

I'm trying to export data in a list to Excel

[toc] | [prev] | [next] | [standalone]

#41451

Am 18.03.13 20:00, schrieb Ana Dionísio:
> But I still get the error and I use Excel 2010.
>
> I'm trying to export data in a list to Excel
>
Unless you tell *how exactly* do you export the data into excel format, 
we probably can't help you. You could try to write a .csv ASCII file, 
for instance.

	Christian

[toc] | [prev] | [next] | [standalone]

#41498

On 2013-03-18, Ana Dion?sio <anadionisio257@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. To get data
into Excel use the csv module and create the file using the
default 'excel-csv' format. Then load the file using Excel.

Creating an Excel file directly in Python is possible, but I
think it will require use of the Pywin32 extensions.

-- 
Neil Cerutti

[toc] | [prev] | [next] | [standalone]

#41507

On Tue, 19 Mar 2013 15:07:54 +0100, Neil Cerutti <neilc@norwich.edu> wrote:

> On 2013-03-18, Ana Dion?sio <anadionisio257@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. To get data
> into Excel use the csv module and create the file using the
> default 'excel-csv' format. Then load the file using Excel.
>
> Creating an Excel file directly in Python is possible, but I
> think it will require use of the Pywin32 extensions.
>

I use and recommend http://pythonhosted.org/openpyxl/ for creating Excel  
files from Python.
No trouble so far.

[toc] | [prev] | [next] | [standalone]

#41510

On 2013-03-19 14:07, Neil Cerutti wrote:
> On 2013-03-18, Ana Dion?sio <anadionisio257@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.

-tkc


[1]
https://pypi.python.org/pypi/xlrd

[2]
https://pypi.python.org/pypi/xlwt

[toc] | [prev] | [next] | [standalone]

#41541

On Tue, Mar 19, 2013 at 8:44 AM, Tim Chase
<python.list@tim.thechases.com> wrote:
> On 2013-03-19 14:07, Neil Cerutti wrote:
>> On 2013-03-18, Ana Dion?sio <anadionisio257@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.

[toc] | [prev] | [next] | [standalone]

#41594

On 2013-03-19, Ian Kelly <ian.g.kelly@gmail.com> wrote:
> On Tue, Mar 19, 2013 at 8:44 AM, Tim Chase
><python.list@tim.thechases.com> wrote:
>> On 2013-03-19 14:07, Neil Cerutti wrote:
>>> On 2013-03-18, Ana Dion?sio <anadionisio257@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

[toc] | [prev] | [next] | [standalone]

#41450

But I still get the error and I use Excel 2010.

I'm trying to export data in a list to Excel

[toc] | [prev] | [next] | [standalone]

#41521

On 18/03/2013 15:50, Steven D'Aprano wrote:
> [...]
>
> Gnumeric is Linux-only

No it isn't. I use it on Windows 7 with no problem.


-- 
I have made a thing that superficially resembles music:

http://soundcloud.com/eroneity/we-berated-our-own-crapiness

[toc] | [prev] | [next] | [standalone]

#41453

Am 18.03.2013 16:28, schrieb Ana Dionísio:
> 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.

There are many versions of Excel. The recent ones can handle more than
256 columns. If your version doesn't, then Python won't help you to
increase this limit...
There are many ways to get data from Python into Excel. If you have any
specific problems, you should provide more details.

Regards,

Dietmar

[toc] | [prev] | [next] | [standalone]

#42341

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web