Re: Excel column 256 limit

2013-03-30 Thread jmcnamara13
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

Re: Excel column 256 limit

2013-03-20 Thread Neil Cerutti
On 2013-03-19, Ian Kelly ian.g.ke...@gmail.com wrote: On Tue, Mar 19, 2013 at 8:44 AM, Tim Chase python.l...@tim.thechases.com wrote: On 2013-03-19 14:07, Neil Cerutti wrote: On 2013-03-18, Ana Dion?sio anadionisio...@gmail.com wrote: But I still get the error and I use Excel 2010. I'm

Re: Excel column 256 limit

2013-03-19 Thread Neil Cerutti
On 2013-03-18, Ana Dion?sio anadionisio...@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

Re: Excel column 256 limit

2013-03-19 Thread Michael Ross
On Tue, 19 Mar 2013 15:07:54 +0100, Neil Cerutti ne...@norwich.edu wrote: On 2013-03-18, Ana Dion?sio anadionisio...@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

Re: Excel column 256 limit

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

Re: Excel column 256 limit

2013-03-19 Thread Rotwang
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 --

Re: Excel column 256 limit

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

Excel column 256 limit

2013-03-18 Thread 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. -- http://mail.python.org/mailman/listinfo/python-list

Re: Excel column 256 limit

2013-03-18 Thread Dave Angel
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. --

Re: Excel column 256 limit

2013-03-18 Thread Steven D'Aprano
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

Re: Excel column 256 limit

2013-03-18 Thread Grant Edwards
On 2013-03-18, Dave Angel da...@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,

Re: Excel column 256 limit

2013-03-18 Thread Michael Ross
On Mon, 18 Mar 2013 16:50:21 +0100, Steven D'Aprano steve+comp.lang.pyt...@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

Re: Excel column 256 limit

2013-03-18 Thread 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 -- http://mail.python.org/mailman/listinfo/python-list

Re: Excel column 256 limit

2013-03-18 Thread Dietmar Schwertberger
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

Re: Excel column 256 limit

2013-03-18 Thread Christian Gollwitzer
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.