On Nov 26, 6:40 am, Frank <[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
> I use pyExcelerator and am quite happy with it, except: I cannot find a option
> for setting the zoom of a particular worksheet. I am using pyExcelerator
> 0.6.3a which is the latest as far as i know
Hi everybody,
I use pyExcelerator and am quite happy with it, except: I cannot find a option
for setting the zoom of a particular worksheet. I am using pyExcelerator
0.6.3a which is the latest as far as i know.
I already contacted the developer of pyExcelerator, he says there is a zoom
A_H wrote:
Hi, I'm using PyExcelerator, and it's great,
If you are using the latest released version, it's not, IMO. Reading the
fixed-later bug reports on Sourceforge may prompt you to get the latest
version from svn. Reading the unfixed bug reports on Sourceforge may
promp
On Mar 1, 5:59 pm, Cyril.Liu <[EMAIL PROTECTED]> wrote:
> I use pyExcelerator to generat Excel files in my project. it works good
> before I found this bug:
> run this code:
>
> from pyExcelerator import *
> wb = Workbook()
> ws = wb.add_sheet("sheet")
>
Cyril.Liu wrote:
> I use pyExcelerator to generat Excel files in my project. it works good
> before I found this bug:
> run this code:
>
> from pyExcelerator import *
> wb = Workbook()
> ws = wb.add_sheet("sheet")
> for i in xrange(1):
> ws
I use pyExcelerator to generat Excel files in my project. it works good
before I found this bug:
run this code:
from pyExcelerator import *
wb = Workbook()
ws = wb.add_sheet("sheet")
for i in xrange(1):
ws.write(i,0, 10474224.6)
wb.save(r'd:\error_float.xls')
open d:\er
I use pyExcelerator to generat Excel files in my project. it works good
before I found this bug:
run this code:
from pyExcelerator import *
wb = Workbook()
ws = wb.add_sheet("sheet")
for i in xrange(1):
ws.write(i,0, 10474224.6)
wb.save(r'd:\error_float.xls')
open d:\er
On Feb 1, 4:37 am, Stephen Brown <[EMAIL PROTECTED]> wrote:
> Yes indeed, pyExcelerator does support reading data from excel
> spreadsheets.
I presume this is an orphaned and belated reply to the 3-message
thread in July 2006 with the same subject.
> An example of how to do this
Yes indeed, pyExcelerator does support reading data from excel
spreadsheets. An example of how to do this is included in the file
xls2csv-gerry.py under the directory ... pyExcelerator/examples/tools
Syntax is pretty straight forward. extract_all = parse_xls(filename, CP
= None) where CP
On Jan 19, 7:46�am, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I was just curious if there was a �built-in or a more efficient way to
> do take multiple rows of information and write them into excel using
> pyExcelerator. �This is how I resolved the problem:
>
> from pyExcelera
Hi all,
I was just curious if there was a built-in or a more efficient way to
do take multiple rows of information and write them into excel using
pyExcelerator. This is how I resolved the problem:
from pyExcelerator import *
data = [[1,2,3],[4,5,'a'],[''
On Jun 12, 10:58 am, [EMAIL PROTECTED] wrote:
> I'm using pyExcelerator to take a folder of CSV files and create Excel
> workbooks for all of them, then generate an Excel workbook with the
> data from all of them.
>
> Everything up until here works great; next, I make a secon
I'm using pyExcelerator to take a folder of CSV files and create Excel
workbooks for all of them, then generate an Excel workbook with the
data from all of them.
Everything up until here works great; next, I make a second worksheet
on the last workbook which has summary details regardin
Good evening!
say, please, as in *.xls to insert an unscreened picture?
example: image.py
but a picture in OpenOficce is not represented :(
OS - windows XP, debian etch
pyExcelerator 0.6.3a-1
#!/usr/bin/env python
# -*- coding: windows-1251 -*-
# Copyright (C) 2005 Kiseliov Roman
__rev_id__
John,
I'd be delighted to try xlwt (does it work under Python 2.4 and 2.5?)
I followed the link to ...svn/xlwt/trunk and found a collection of
files, but no Windows installer. How do I install xlwt?
Thanks in advance
Thomas Philips
--
http://mail.python.org/mailman/listinfo/python-list
rd column of the
>> spreadsheet. Is this a known bug?
[looks like my (earlier) reply to the original post didn't make it to
c.l.py]
This may well be a manifestation of the RK bug that is reported in two
bug reports (1509223 and 1596642) on the pyExcelerator sourceforge site.
However
On May 16, 4:42 pm, [EMAIL PROTECTED] wrote:
> My program creates three lists: the first has dates expressed as
> strings, the second has floats that are strictly positive, and the
> third has floats that are strictly negative. I have no trouble writing
> the data in these lists to a .csv file usin
= file(fn + '.csv','wb')
writer = csv.writer(outfile)
for i in range(len(dateList)):
writer.writerow([dateList[i], posVals[i], negVals[i]])
outfile.close()
However, when I try to write to an Excel file using pyExcelerator (see
code below), the third list is not always wr
En Mon, 12 Feb 2007 01:46:51 -0300, susan <[EMAIL PROTECTED]>
escribió:
>> > $ python ./pyExcelerator/setup.py install
>>
>> Try this instead:
>> $ cdpyExcelerator
>> $ python ./setup.py install
> I still wonder why my way didn't work. I think
On Feb 11, 11:22 pm, Samuel Karl Peterson
<[EMAIL PROTECTED]> wrote:
> "susan" <[EMAIL PROTECTED]> on 11 Feb 2007 16:55:35 -0800 didst
> step forth and proclaim thus:
>
> > Hi,
> > I'm new of Python, and this problem stucked me whole day but can't be
> > solved.
>
> [snip]
>
> > anybody can tell me
gt; I use python 2.4.3, which is download from cygwin packages.
>
> Is your Python installation working properly for you with other
> things, or is installingpyExceleratorthe first thing that you have
> tried?
>
> > Then I
> > downloadedpyexcelerator-0.5.3a, unzip it,
>
>
"susan" <[EMAIL PROTECTED]> on 11 Feb 2007 16:55:35 -0800 didst
step forth and proclaim thus:
> Hi,
> I'm new of Python, and this problem stucked me whole day but can't be
> solved.
[snip]
> anybody can tell me where's wrong please? Thanks in advance!
What are the contents of sys.path from an i
r you with other
things, or is installing pyExcelerator the first thing that you have
tried?
> Then I
> downloaded pyexcelerator-0.5.3a, unzip it,
Is that "5" a typo? The latest version is 0.6.3a
>
> $ python ./pyExcelerator/setup.py install
Try this instead:
$ cd pyExcelera
Hi,
I'm new of Python, and this problem stucked me whole day but can't be
solved.
I use python 2.4.3, which is download from cygwin packages. Then I
downloaded pyexcelerator-0.5.3a, unzip it,
$ python ./pyExcelerator/setup.py install
running install
running build
running build_py
pa
On 9/02/2007 6:36 PM, Chris wrote:
> I'm sitting with a bit of an issue with pyExcelerator and creating an
> Excel file with certain cells protected while the rest of the
> spreadsheet is password protected.
>
> The Protection class under Formatting has 2 variables f
I'm sitting with a bit of an issue with pyExcelerator and creating an
Excel file with certain cells protected while the rest of the
spreadsheet is password protected.
The Protection class under Formatting has 2 variables for cell_locked
and formula_hidden, tbh I only need to alter cell_lock
John Machin wrote:
> Here's a possible replacement -- I say possible because you have been
> rather coy about what you are actually trying to do.
>
> value = values[(row_idx, col_idx)])
> if isinstance(value, float):
> v = repr(value)
> else:
> v = unicode(value)
>
> HTH
> John
My final re
Gacha wrote:
> Thank you, the repr() function helped me a lot.
>
> v = unicode(values[(row_idx, col_idx)])
> if v.endswith('e+12'):
> v = repr(values[(row_idx, col_idx)])
That endswith() looks rather suspicious ... what if it's +11 or +13,
and shouldn't it have a zero in it, like "+012" ??
H
Thank you, the repr() function helped me a lot.
v = unicode(values[(row_idx, col_idx)])
if v.endswith('e+12'):
v = repr(values[(row_idx, col_idx)])
--
http://mail.python.org/mailman/listinfo/python-list
On Jan 10, 12:30 am, "Gacha" <[EMAIL PROTECTED]> wrote:
> I use pyExcelerator to import some data from xml file. One column
> contains integer values like:
> 4750456000708
> 4750456000715
> 4750456000333
I think you must mean "xls", not "xml&
I use pyExcelerator to import some data from xml file. One column
contains integer values like:
4750456000708
4750456000715
4750456000333
...
But when I do import the pyExcelerator converts them to something like
this:
4.7504560002e+12
4.7504560007e+12
4.7504560007e+12
4.7504560003e+12
How I
Gerry wrote:
> I'd like some cell to be a Blue "ABCDE".
>
> Here's come code thatv tries various values for pattern_for_colour and
> font.colour_index, to no avail.
>
> Can anyone suggest the right way to set colours?
>
> Thanks!
>
> Gerry
>
&
I'd like some cell to be a Blue "ABCDE".
Here's come code thatv tries various values for pattern_for_colour and
font.colour_index, to no avail.
Can anyone suggest the right way to set colours?
Thanks!
Gerry
==
from pyExcelerator import *
w
Thanks!!!
Looks great. Works for me. I'll try to submit the patch.
Gerry
--
http://mail.python.org/mailman/listinfo/python-list
Gerry wrote:
> I'd like to word wrap some cells, but not others, in an Excel
> spreadsheet, using pyExcelerator and Excel 2003, SP1, under XP.
>
> The code below creates the spreadsheet, but both cells are
> word-wrapped.
>
> As far as I can tell, the second call to XFS
I'd like to word wrap some cells, but not others, in an Excel
spreadsheet, using pyExcelerator and Excel 2003, SP1, under XP.
The code below creates the spreadsheet, but both cells are
word-wrapped.
As far as I can tell, the second call to XFStyle() overwrites a GLOBAL
wrap setting, and af
John> Check out my "xlrd" package.
John> http://cheeseshop.python.org/pypi/xlrd/0.5.2
Very nice. Thanks for the pointer. I threw away about 75% of the
xls-to-csv converter I wrote using pyExcelerator. And it worked with Python
2.3 without having to comment out al
John> Check out my "xlrd" package.
John> http://cheeseshop.python.org/pypi/xlrd/0.5.2
...
John,
Thank you. I wasn't aware of it. I'd seen mention of pyExcelerator a few
times recently. All I need is to read Excel spreadsheets anyway. I will
check it
I might get date floats which are offset from 1904-01-01 (I think that
> was the traditional Mac start-of-epoch) or are they normalized to all be
> offsets from 1899-12-31?
>
> I noticed that there are two items on the pyExcelerator to-do list. Number
> one is "documentation&quo
t's too late for me to do any more poking around. Does anyone know
if I might get date floats which are offset from 1904-01-01 (I think that
was the traditional Mac start-of-epoch) or are they normalized to all be
offsets from 1899-12-31?
I noticed that there are two items on the pyExcelerato
I'm experimenting with pyExcelerator and am reading an XLS file which
contains dates. In Excel on my Mac they look like "09/13/06". After
parsing them out of the .XLS file they are floats, e.g. 38973.0. I assume
that's an offset in days. Doing a little date math I come up
[EMAIL PROTECTED] wrote:
> I'm looking forward to the release IronPython, primarily for its IDE. I
> currently use scipy and pyExcelerator to crunch numbers and write them
> to Excel: does can these packages be used with IronPython as well?
>
> Thanks in advance
You could
[EMAIL PROTECTED] wrote:
> I'm looking forward to the release IronPython, primarily for its IDE. I
> currently use scipy and pyExcelerator to crunch numbers and write them
> to Excel: does can these packages be used with IronPython as well?
>
> Thanks in advance
>
>
I'm looking forward to the release IronPython, primarily for its IDE. I
currently use scipy and pyExcelerator to crunch numbers and write them
to Excel: does can these packages be used with IronPython as well?
Thanks in advance
Thomas Philips
--
http://mail.python.org/mailman/listinfo/p
/xlrd.htm
It works fines as far as reading Excel is concerned.
Greetings,
Richard Sharp
Gregory Piñero wrote:
> No, by it I meant pyExcelerator :-)
>
> On 7/11/06, Larry Bates <[EMAIL PROTECTED]> wrote:
> > If by "it" you mean Excel's COM interface, it most certa
No, by it I meant pyExcelerator :-)
On 7/11/06, Larry Bates <[EMAIL PROTECTED]> wrote:
> If by "it" you mean Excel's COM interface, it most certainly will.
> With COM you call all the same functions/methods that Microsoft
> calls to open, save, and manipulate the s
emplate)
> > 2. and add some data to it
> > 3. and save it under a different name afterwards.
> >
> > To me it seems, that pyExcelerator does not support the reading for
> > modification of an Excel-sheet. It allows only the "parse_xls" but I
> > wo
Marco Aschwanden wrote:
>
> Hi
>
> I would like to
> 1. import an existing Excel-sheet (a template)
> 2. and add some data to it
> 3. and save it under a different name afterwards.
>
> To me it seems, that pyExcelerator does not support the reading for
> modi
Hi
I would like to
1. import an existing Excel-sheet (a template)
2. and add some data to it
3. and save it under a different name afterwards.
To me it seems, that pyExcelerator does not support the reading for
modification of an Excel-sheet. It allows only the "parse_xls&q
On 3/06/2006 3:39 AM, [EMAIL PROTECTED] wrote:
> I write data to Excel files using PyExcelerator 0.6.3.a and have done
> so successfully for small files (10-15 cells). I'm experiencing an
> error when writing a big chunk of data (10,000 cells) to Excel. By way
> of comparison, the
I write data to Excel files using PyExcelerator 0.6.3.a and have done
so successfully for small files (10-15 cells). I'm experiencing an
error when writing a big chunk of data (10,000 cells) to Excel. By way
of comparison, the same data writes perfectly well to a csv file using
Python'
't find
| how to do this with PyExcelerator neither with COM. Any clue?
Nearly always, a good starting point for doing this
kind of thing with COM (obviously doesn't apply for
PyExcelerator) is to record a Macro in Excel itself
which does what you want, and then to translate the
co
Hi, I just want that a number like 1234.123 appear in excel as 1,234.12In excel I just select some cells, then right click on them and select "Cell Formatting" then select Number, and check "Use thounsands separator" and 2 decimal places. I can't find how to do this with P
John,
I had spelled PyExcelerator with a capital P, but it worked just fine.
I then checked the directory it was installed in, and found it read
C:\Python24\Lib\site-packages\PyExcelerator. As soon as I changed the
directory name to C:\Python24\Lib\site-packages\pyExcelerator, my
programs stopped
On 10/05/2006 7:57 AM, [EMAIL PROTECTED] wrote:
> I use PyExcelerator to write data into Excel files, and repeatedly call
> the function writeData with different filenames fn from my main
> routine. Unfortunately, only one file - the last one - is created. The
> problem seems to lie w
I use PyExcelerator to write data into Excel files, and repeatedly call
the function writeData with different filenames fn from my main
routine. Unfortunately, only one file - the last one - is created. The
problem seems to lie with the fact that I do not close the existing
file before calling the
Hi,
i have a question with the pyexcelerator Modul. I´m using the Version
0.6.3a.
Now I want to know how I can change the Colour Palette of Excel. I want
to have my own colours for pattern_fore_colour and things like this.
I want to build the colours dynamically. I have the RGB values for the
I would agree with the author, pyExcelerator is good at writing Excel
but xlrd is better at reading. I was recently forced to use them in
tandem because pyExcelerator had problems reading an Excel sheet and
xlrd had no problems.
greetings,
Richard Sharp
John Machin wrote:
> On 23/03/2006 9
On 23/03/2006 9:01 AM, [EMAIL PROTECTED] wrote:
> I have just installed PyExcelerator, and now want to use it to read
> Excel spreadsheets with a variable number of rows and columns and with
> multiple sheets. Unfortunately, no documentation seems to accompany
> PyExcelerator. Does an
I have just installed PyExcelerator, and now want to use it to read
Excel spreadsheets with a variable number of rows and columns and with
multiple sheets. Unfortunately, no documentation seems to accompany
PyExcelerator. Does anyone know of a good source of documentations
and/or examples? The
[EMAIL PROTECTED] wrote:
> I downloaded PyExcelerator.zip as I need to write some data into Excel
> files, and tried unsuccessfully to install it. I unzipped the files
> into C:/Python24/Lib/site-packages/PyExcelerator
You should unzip to somewhere else, the install step will put the
Thanks!!! I had a good laugh at myself after i got it working.
--
http://mail.python.org/mailman/listinfo/python-list
[EMAIL PROTECTED] wrote:
> I downloaded PyExcelerator.zip as I need to write some data into Excel
> files, and tried unsuccessfully to install it. I unzipped the files
> into C:/Python24/Lib/site-packages/PyExcelerator, and in a python
> command line window typed
>
> >>&g
I downloaded PyExcelerator.zip as I need to write some data into Excel
files, and tried unsuccessfully to install it. I unzipped the files
into C:/Python24/Lib/site-packages/PyExcelerator, and in a python
command line window typed
>>>os.chdir("C:/Python24/Lib/site-packages
a
> sheet use "!" charater: Data!A1
>
Right you are. It "changed" somehow... anyhow, even if you change it, it
will choke on the same line. I received an answer... a workaround which
doesn't make me happy, but it is, as it is!
[...]
This is not a bug. This is
mishandling and I will gladly retreat my bug report.
>
> In a formula, I would like to point to a field on another worksheet.
> pyExcelerator chokes on these references!
>
>
>
> import pyExcelerator
>
> wb = pyExcelerator.Workbook()
> ws_summary = wb.add_sheet('Summa
.
In a formula, I would like to point to a field on another worksheet.
pyExcelerator chokes on these references!
import pyExcelerator
wb = pyExcelerator.Workbook()
ws_summary = wb.add_sheet('Summary')
ws_data = wb.add_sheet('Data')
ws_summary.write(0,0, pyExcelerator.Form
67 matches
Mail list logo
