Re: xlrd 1.0.0 released!

2016-06-07 Thread derek
Gmail and the Gmail Digest only ever show the 0.9.4 tag - not sure if this a big issue or not (but I know I would like to the 1.0.0 tag to be proudly displayed!) On Friday, 3 June 2016 03:57:35 UTC+2, Chris Withers wrote: > > Ugh, and once again, this time with a corrected title... > > > On 02

Re: xlrd 0.9.4 released!

2015-07-15 Thread Karim
On 15/07/2015 08:27, Chris Withers wrote: Hi All, I'm pleased to announce the release of xlrd 0.9.4: http://pypi.python.org/pypi/xlrd/0.9.4 This release includes the following changes: - Automated tests are now run on Python 3.4 - Use ElementTree.iter() if available, not deprecated getiter

Re: xlrd Can't find workbook in OLE2 compound document

2014-09-17 Thread dieter
Andi Vaganerd writes: > I'm trying to open an excel file (.xlsx) using python module xlrd. > And I'm getting this error over here: > > "Can't find workbook in OLE2 compound document" I interprete this message as follows: the excel content in your file is wrapped in an atypical way (an OLE2 compou

Re: [pyxl] Re: xlrd 0.9.2 released!

2013-04-29 Thread Neil Cerutti
On 2013-04-29, Chris Withers wrote: > There aren't any, because there are no changes. Applications > written for 0.6.x will still work without change when using > 0.9.2. The Python 3 support is greatly appreciated. I've started using the xlrd package recently, and it's made the life of a few of m

Re: [pyxl] Re: xlrd 0.9.2 released!

2013-04-29 Thread Chris Withers
On 26/04/2013 20:37, Ondrej Ján wrote: If users have python-xlrd installed, package maintainer should release only updates, which are API compatible with older versions. Right, the only API change between 0.6 and 0.9 is the removal of the 'pickleable' parameter to open_workbook. However, th

Re: [pyxl] Re: xlrd 0.9.2 released!

2013-04-26 Thread Ondrej Ján
Hello, Fedora is an Linux distribution maintained by Red Hat. (www.fedoraproject.org). EPEL are packages fro Red Hat Enterprise Linux and CentOS Linux distribution. As an maintainer I am creating and updating packages available for these distributions. If users have python-xlrd installed, pac

Re: [pyxl] Re: xlrd 0.9.2 released!

2013-04-26 Thread Chris Withers
Hi Ondrej, I don't know what a Fedora/EPEL update is. If you're going to have two versions, I would suggest: 0.7.9 - for backwards compatibility with Python 2.5 and less, and older 0.6 and 0.7 xlrd releases. 0.9.2 - for Python 3 support, and with the latest and greatest features. cheers, C

Re: xlrd 0.9.2 released!

2013-04-23 Thread Karim
Thx ! I will update my 0.6 version! Cheers Karim On 09/04/2013 21:38, Chris Withers wrote: Hi All, I'm pleased to announce the release of xlrd 0.9.2: http://pypi.python.org/pypi/xlrd/0.9.2 This release includes the following changes: - Fix some packaging issues that meant docs and examples

Re: xlrd 0.9.2 released!

2013-04-23 Thread Ondrej Ján
Hello. Can you please tell me, how compatible is this version with older versions? In Fedora/CentOS we have versions 0.7 and 0.6. Can I release and Fedora/EPEL update to 0.9.2? Thank you. SAL Dňa utorok, 9.

Re: xlrd 0.9.2 released!

2013-04-10 Thread nn
On Apr 9, 3:38 pm, Chris Withers wrote: > Hi All, > > I'm pleased to announce the release of xlrd 0.9.2: > > http://pypi.python.org/pypi/xlrd/0.9.2 > > This release includes the following changes: > > - Fix some packaging issues that meant docs and examples were missing > from the tarball. > > - F

Re: xlrd 0.8.0 released!

2012-08-22 Thread Chris Withers
On 22/08/2012 15:03, Hubert Holin wrote: I would like to keep up with the development but would like to know which is the repo to follow. The Python-Excel website points to https://github.com/python-excel/xlrd, but that one does not have a 0.8.0 tag (or at least did not have one when I looked a f

Re: xlrd 0.8.0 released!

2012-08-22 Thread Hubert Holin
La Défense, le 22/08/2012 Hi Congratulations for the work well done, and thanks for the help xlrd brings to my work. I would like to keep up with the development but would like to know which is the repo to follow. The Python-Excel website points to https://github.com/python-excel/xlrd, but th

Re: xlrd 0.8.0 released!

2012-08-03 Thread pruebauno
On Wednesday, August 1, 2012 11:01:56 AM UTC-4, Chris Withers wrote: > Hi All, > > > > I'm pleased to announce the release of xlrd 0.8.0: > > > > http://pypi.python.org/pypi/xlrd/0.8.0 > > > > This release finally lands the support for both .xls and .xlsx files. > > Many thanks to John Ma

Re: xlrd 0.7.6 released!

2012-04-06 Thread Karim
Le 07/04/2012 04:07, Keith Medcalf a écrit : Karim wrote in news:mailman.1309.1333529851.3037.python-l...@python.org: This release manage the '.xlsx' format? http://packages.python.org/openpyxl/ Ah Keith, I just check this is only for xlsx format so I will make 2 code branches so I don't

Re: xlrd 0.7.6 released!

2012-04-06 Thread Keith Medcalf
Karim wrote in news:mailman.1309.1333529851.3037.python-l...@python.org: > This release manage the '.xlsx' format? http://packages.python.org/openpyxl/ -- http://mail.python.org/mailman/listinfo/python-list

Re: xlrd 0.7.6 released!

2012-04-05 Thread Chris Withers
On 04/04/2012 20:26, Karim wrote: By the way, I reported an issue to you in this mailing list some time ago about unicode data. I have no recollection of this. If you experience any bugs, the correct place to report them is: https://github.com/python-excel/xlrd/issues cheers, Chris -- Simp

Re: xlrd 0.7.6 released!

2012-04-04 Thread Chris Withers
On 04/04/2012 09:57, Karim wrote: Hello, This release manage the '.xlsx' format? No, that is planned for the 0.8 release. cheers, Chris -- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.uk -- http://mail.python.org/mailman/listin

Re: xlrd 0.7.6 released!

2012-04-04 Thread Karim
Le 04/04/2012 09:24, Chris Withers a écrit : And the goat sacrifice continues... On 03/04/2012 08:34, Chris Withers wrote: On 03/04/2012 08:04, Chris Withers wrote: I'm pleased to announce the release of xlrd 0.7.4. I've just release a 0.7.5 that fixes this. Except it didn't, I've just rele

Re: [pyxl] Re: xlrd 0.7.4 released!

2012-04-04 Thread Chris Withers
On 03/04/2012 21:46, Josh English wrote: When I try to import xlrd, I get an error IOError: [Errno 2] No such file or directory: 'C:\\Users\\josh\\Desktop\\Portable Python\\App\\lib\\site-packages\\xlrd-0.7.5-py2.7.egg\\xlrd\\version.txt' *sigh* I hate python packaging, I'll get a 0.7.6 releas

Re: [pyxl] Re: xlrd 0.7.4 released!

2012-04-03 Thread Adrian Klaver
On 04/03/2012 01:46 PM, Josh English wrote: Maybe it's just me, but I tried to upgrade my previous versions of xlrd, xlwt, an xlutils and now some of the modules aren't loading properly. I am currently using Portable Python 2.7 at this workstation. I ran "easy_install --upgrade xlrd" and the re

Re: xlrd 0.7.4 released!

2012-04-03 Thread Josh English
Maybe it's just me, but I tried to upgrade my previous versions of xlrd, xlwt, an xlutils and now some of the modules aren't loading properly. I am currently using Portable Python 2.7 at this workstation. I ran "easy_install --upgrade xlrd" and the result said it had updated. If I try to update

Re: xlrd 0.7.4 released!

2012-04-03 Thread Lukas Graf
Hey Chris, On Tuesday, April 3, 2012 9:04:43 AM UTC+2, Chris Withers wrote: > > Hi All, > > I'm pleased to announce the release of xlrd 0.7.4. > There seems to have been a mistake during release of 0.7.4: version.txt referenced in setup.py:24 is missing (forgot MANIFEST?) and therefore the pack

Re: xlrd+excel determine decimal separator

2009-09-17 Thread John Machin
On Sep 17, 8:40 pm, peter wrote: > i want to ask you if somebody knows how can I determine, with a help > of xlrd, what kind of decimal separator (. or ,) does the user have. It's nothing to do with xlrd. It reads files and gives you the numbers as Python floats. Note that a user of locale A (us

Re: xlrd - insert column?

2009-07-28 Thread John Machin
On Jul 29, 6:05 am, LeeRisq wrote: > Does xlrd have the capability to insert a column? No. If there was anything in the PyPI description, the README, or the docs that gave you the faintest hope that xlrd does anything other than read Excel files, please raise a documentation bug-fix request. Sta

Re: xlrd - insert column?

2009-07-28 Thread Tino Wildenhain
LeeRisq wrote: Does xlrd have the capability to insert a column? rd means ReaD, so there is nothing it could insert something to. Of course once you have read the data you can manipulate its structure how you like it. The counterpart is xlwt and it can write excel files however you like it. R

Re: xlrd cell background color

2008-08-14 Thread patrick . waldo
Thank you very much. I did not know there was a python-excel group, which I will certainly take note of in the future. The previous post answered my question, but I wanted to clarify the difference between xf.background.background_colour_index, xf.background.pattern_colour_index, and book.colour_

Re: xlrd cell background color

2008-08-13 Thread John Machin
On Aug 14, 6:03 am, [EMAIL PROTECTED] wrote in news:comp.lang.python thusly: > Hi all, > > I am trying to figure out a way to read colors with xlrd, but I did > not understand the formatting.py module. It is complicated, because it is digging out complicated info which varies in somewhat arbitrary

Re: xlrd

2008-08-04 Thread John Machin
On Aug 4, 11:08 pm, [EMAIL PROTECTED] wrote: > here is working code that will read & display contents of all rows & columns > in all the sheets, you need xlrd 0.6.1 > > import xlrd, os, sys > > book = xlrd.open_workbook(sys.argv[1]) > print "The number of worksheets is", book.nsheets > for shx in

Re: xlrd

2008-08-04 Thread Edwin . Madari
sh.row_values(rx)[cx]) except: print xlrd.cellname(rx, cx), 'Exception - could not read' print -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Herron Sent: Monday, August 04, 2008 5:01 AM Cc: python-list@python.org Su

Re: xlrd

2008-08-04 Thread John Machin
Yeats uol.com.br> writes: > > > Hi, > > Years ago i use xlrd to read data from > excel and now I need again, but i get strange result. The code is: > > from xlrd import * > > Planilha = > open_workbook('C:\\Resultados.xls')Resultados = > Planilha.sheet_by_name('Resultados')c = > (Resu

Re: xlrd

2008-08-04 Thread Gary Herron
Yeats wrote: Hi, Years ago i use xlrd to read data from excel and now I need again, but i get strange result. The code is: from xlrd import * Planilha = open_workbook('C:\\Resultados.xls') Resultados = Planilha.sheet_by_name('Resultados') c = (Resultados.cell_value(2,2)) print c and the

Re: xlrd: error open_workbook

2008-07-29 Thread M.-A. Lemburg
On 2008-07-28 22:22, Fabio Oikawa wrote: Hello. I am trying to open an .xls (excel) file using xlrd, but an error message occurs when I open the workbook. I can open any other .xls file made by myself (either by MS Excel 2003 SP3 in Windows Vista or by OpenOffice 2.0 in Debian) using the *open_

Re: xlrd and cPickle.dump

2008-04-02 Thread John Machin
[EMAIL PROTECTED] wrote: >> FWIW, it works here on 2.5.1 without errors or warnings. Ouput is: >> 2.5.1 (r251:54863, Apr 18 2007, 08:51:08) [MSC v.1310 32 bit (Intel)] >> 0.6.1 > > I guess it's a version issue then... I say again: Don't guess. > > I forgot about sorted! Yes, that would make sen

Re: xlrd and cPickle.dump

2008-04-02 Thread patrick . waldo
>FWIW, it works here on 2.5.1 without errors or warnings. Ouput is: >2.5.1 (r251:54863, Apr 18 2007, 08:51:08) [MSC v.1310 32 bit (Intel)] >0.6.1 I guess it's a version issue then... I forgot about sorted! Yes, that would make sense! Thanks for the input. On Apr 2, 4:23 pm, [EMAIL PROTECTED]

Re: xlrd and cPickle.dump

2008-04-02 Thread Konstantin Veretennicov
On Wed, Apr 2, 2008 at 5:23 PM, <[EMAIL PROTECTED]> wrote: > Still no luck: > > Traceback (most recent call last): > File "C:\Python24\Lib\site-packages\pythonwin\pywin\framework > \scriptutils.py", line 310, in RunScript >exec codeObject in __main__.__dict__ > File "C:\text analysis\pickle_

Re: xlrd and cPickle.dump

2008-04-02 Thread patrick . waldo
Still no luck: Traceback (most recent call last): File "C:\Python24\Lib\site-packages\pythonwin\pywin\framework \scriptutils.py", line 310, in RunScript exec codeObject in __main__.__dict__ File "C:\text analysis\pickle_test2.py", line 13, in ? cPickle.dump(Data_sheet, pickle_file, -1)

Re: xlrd and cPickle.dump

2008-04-01 Thread John Machin
On Apr 2, 7:19 am, [EMAIL PROTECTED] wrote: > > How many megabytes is "extremely large"? How many seconds does it take > > to open it with xlrd.open_workbook? > > The document is 15mb ad 50,000+ rows (for test purposes I will use a > smaller sample), 15 Mb is not large. E.g. 120 Mb is large. > bu

Re: xlrd and cPickle.dump

2008-04-01 Thread patrick . waldo
> How many megabytes is "extremely large"? How many seconds does it take > to open it with xlrd.open_workbook? The document is 15mb ad 50,000+ rows (for test purposes I will use a smaller sample), but my computer hangs (ie it takes a long time) when I try to do simple manipulations and the documen

Re: xlrd and cPickle.dump

2008-04-01 Thread John Machin
[EMAIL PROTECTED] wrote: > Hi all, > > Sorry for the repeat I needed to reform my question and had some > problems...silly me. Indeed. Is omitting the traceback part of the "reformation"? > > The xlrd documentation says: > "Pickleable. Default is true. In Python 2.4 or earlier, setting to > fa

Re: xlrd question

2007-08-06 Thread John Machin
On Aug 4, 10:48 am, [EMAIL PROTECTED] wrote: > I ran your code which gave me this: > > >>> import sys, xlrd; print sys.version; print xlrd.__file__ > > 2.3.5 (#1, Jan 30 2006, 13:30:29) > [GCC 3.3 20030304 (Apple Computer, Inc. build 1819)] > /System/Library/Frameworks/Python.framework/Versions/2.3

Re: xlrd question

2007-08-06 Thread John Machin
On Aug 5, 7:31 pm, has <[EMAIL PROTECTED]> wrote: > > Nope, DistUtils will copy all modules to site-packages as part of the > installation procedure. If you're a developer you'll probably want to > keep the original distribution around as it'll contain documentation, > examples, etc. which you'll

Re: xlrd question

2007-08-06 Thread has
On 5 Aug, 19:43, jay <[EMAIL PROTECTED]> wrote: > So if I'm understanding this correctly, it really only > installs something in '/Library/Python/2.3/site-packages' Correct. > (as well as > an alias to it from '/System/Library/Frameworks/Python.framework/ > Versions/2.3/lib/python2.3/site-pa

Re: xlrd question

2007-08-05 Thread jay
Hi Has, >> 2.3.5 (#1, Jan 30 2006, 13:30:29) >> [GCC 3.3 20030304 (Apple Computer, Inc. build 1819)] >> /System/Library/Frameworks/Python.framework/Versions/2.3/lib/ >> python2.3/site -packages/ >> xlrd/__init__.pyc > > Note that: > > /System/Library/Frameworks/Python.framework/Versions/2.3/lib/

Re: xlrd question

2007-08-05 Thread has
On Aug 4, 1:48 am, [EMAIL PROTECTED] wrote: > I ran your code which gave me this: > > >>> import sys, xlrd; print sys.version; print xlrd.__file__ > > 2.3.5 (#1, Jan 30 2006, 13:30:29) > [GCC 3.3 20030304 (Apple Computer, Inc. build 1819)] > /System/Library/Frameworks/Python.framework/Versions/2.3

Re: xlrd question

2007-08-03 Thread John Machin
On Aug 4, 1:22 am, [EMAIL PROTECTED] wrote: > When running 'python setup.py install' to install items for xlrd to work, > does anybody know > what items are > installed and where items are installed at on a Mac (OS 10.4)? I'm assuming > it mainly uses > things out of the xlrd > folder, but was c

Re: XLRD Python 2.51 Question

2007-05-08 Thread John Machin
On May 9, 1:36 am, Carsten Haese <[EMAIL PROTECTED]> wrote: > On Tue, 2007-05-08 at 08:26 -0700, [EMAIL PROTECTED] wrote: > > CompDocError: MSAT extension: accessing sector 1717046 but only 2887 > > in file > > > I am not sure what this means at all > > At least superficially that sounds like the f

Re: XLRD Python 2.51 Question

2007-05-08 Thread Carsten Haese
On Tue, 2007-05-08 at 08:26 -0700, [EMAIL PROTECTED] wrote: > CompDocError: MSAT extension: accessing sector 1717046 but only 2887 > in file > > I am not sure what this means at all At least superficially that sounds like the file you're trying to open is truncated or otherwise corrupted to the p

Re: xlrd number of rows in worksheet (was: Re: Pre-defining an action to take when an expected error occurs)

2006-09-19 Thread John Machin
Tempo wrote: > It worked. Those two functions (usefulness_of_cells & > number_of_good_rows) seem to work flawlessly...knock on wood. I have > run a number of different Excel spreadsheets through the functions, and > so far the functions have a 100% acuracy rating. The acuracy rating is > based on

Re: xlrd number of rows in worksheet (was: Re: Pre-defining an action to take when an expected error occurs)

2006-09-19 Thread Tempo
It worked. Those two functions (usefulness_of_cells & number_of_good_rows) seem to work flawlessly...knock on wood. I have run a number of different Excel spreadsheets through the functions, and so far the functions have a 100% acuracy rating. The acuracy rating is based on the functions' returned