xlrd 1.1.0 and xlwt 1.3.0 released!

2017-08-21 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 1.1.0 and xlwt 1.3.0. Please consult their change logs on readthedocs.org to see what's new. As before, I will be upfront and say you should no longer be using these unless libraries unless you have a particular need to work

Re: xlrd 1.0.0 released!

2016-06-07 Thread derek
t; > > On 02/06/2016 18:56, Chris Withers wrote: > > Hi All, > > > > Well, I've finally called it and tagged current master of xlrd as 1.0.0: > > > > http://pypi.python.org/pypi/xlrd/1.0.0 > > > > This release includes the following changes

xlrd 1.0.0 released!

2016-06-02 Thread Chris Withers
Ugh, and once again, this time with a corrected title... On 02/06/2016 18:56, Chris Withers wrote: Hi All, Well, I've finally called it and tagged current master of xlrd as 1.0.0: http://pypi.python.org/pypi/xlrd/1.0.0 This release includes the following changes since the last re

xlrd 0.9.4 released!

2016-06-02 Thread Chris Withers
Hi All, Well, I've finally called it and tagged current master of xlrd as 1.0.0: http://pypi.python.org/pypi/xlrd/1.0.0 This release includes the following changes since the last release: - Official support, such as it is, is now for 2.6, 2.7, 3.3+ - Fixes a bug in looking up non-lowe

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 depre

xlrd 0.9.4 released!

2015-07-14 Thread Chris Withers
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 getiterator() when parsing xlsx files.

Re: Python xlrd

2015-05-03 Thread Dan Sommers
On Sun, 03 May 2015 10:33:25 -0700, lbertolotti wrote: > lucas@lucas-K55VD:~$ dpkg -l python-xlrd > Desired=Unknown/Install/Remove/Purge/Hold > | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend > |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad

Re: Python xlrd

2015-05-03 Thread lbertolotti via Python-list
lucas@lucas-K55VD:~$ dpkg -l python-xlrd Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description

Re: Python xlrd

2015-05-02 Thread Ervin Hegedüs
hi, On Sat, May 02, 2015 at 03:12:46PM -0700, lbertolotti via Python-list wrote: > Ubuntu terminal gives me: > > import xlrd > > I get "ImportError: No module named xlrd" > > Any ideas? I installed it by: > > sudo apt-get install python-xlrd what&#

Python xlrd

2015-05-02 Thread lbertolotti via Python-list
Ubuntu terminal gives me: import xlrd I get "ImportError: No module named xlrd" Any ideas? I installed it by: sudo apt-get install python-xlrd -- https://mail.python.org/mailman/listinfo/python-list

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 i

xlrd Can't find workbook in OLE2 compound document

2014-09-17 Thread Andi Vaganerd
Hello, 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" Is there anybody here already got this problem? How do you resolve it? I've a very simple python pro

Re: need help in adding xlrd file to the dictionary.

2014-04-27 Thread Steven D'Aprano
On Sun, 27 Apr 2014 00:16:41 -0700, uma mahesh wrote: > Hello guys, > > I am new to python scripting. I am trying to take data from excel sheet. > > To do this I understand that xlrd need to add to the dictionary. I was > unable to do this. I have downloaded the fi

need help in adding xlrd file to the dictionary.

2014-04-27 Thread uma mahesh
Hello guys, I am new to python scripting. I am trying to take data from excel sheet. To do this I understand that xlrd need to add to the dictionary. I was unable to do this. I have downloaded the file and stuck there. Please let me know how can I do this. tell me the procedure. Regards

xlrd 0.9.3 released!

2014-04-10 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.9.3: http://pypi.python.org/pypi/xlrd/0.9.3 This release includes the following changes: - Github issue #49 - Github issue #64 - skip meaningless chunk of 4 zero bytes between two otherwise-valid BIFF records - Github issue #61

How to copy hyperlinks using xlrd, xlwt and xlutils?

2013-10-17 Thread Sameer Gupta
. *Note:* I had used here some default example for hyperlinks. I will be using this information for my other program where I am suppose to edit excel sheet with many sheets and every sheet containing hyperlinks at multiple places. *Code: * from xlwt import * import xlrd as xr import os from

Re: unable to read combo boxes in excel by xlrd package in python

2013-09-27 Thread Neil Cerutti
On 2013-09-27, Neil Cerutti wrote: > On 2013-09-27, somesh g wrote: >> Hi..there >> >> I want to read the combo box in excel by using "xlrd" but in >> the output it is showing empty message, its not reading the >> combo box can u guys help me how

Re: unable to read combo boxes in excel by xlrd package in python

2013-09-27 Thread Neil Cerutti
On 2013-09-27, somesh g wrote: > Hi..there > > I want to read the combo box in excel by using "xlrd" but in > the output it is showing empty message, its not reading the > combo box can u guys help me how to read the combo box in excel > by "xlrd" &

unable to read combo boxes in excel by xlrd package in python

2013-09-27 Thread somesh g
Hi..there I want to read the combo box in excel by using "xlrd" but in the output it is showing empty message, its not reading the combo box can u guys help me how to read the combo box in excel by "xlrd" code written like this workbook = xlrd.open_workbook('pat

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 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_workboo

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

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 feature

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 doc

Re: xlrd 0.9.2 released!

2013-04-23 Thread Ondrej Ján
. apríla 2013 21:38:30 UTC+2 Chris Withers napísal(-a): > > 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 doc

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

xlrd 0.9.2 released!

2013-04-09 Thread Chris Withers
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. - Fixed a small but serious regression that caused pro

xlrd 0.9.1 released!

2013-04-05 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.9.1: http://pypi.python.org/pypi/xlrd/0.9.1 This release includes the following changes: - A tonne of bugs when used with Python 3 were fixed thanks to John Machin. - Extra byte data in hyperlink records now records a warning rather

xlrd 0.9.0 released, now with Python 3 support!

2013-01-31 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.9.0: http://pypi.python.org/pypi/xlrd/0.9.0 This release means the supported versions of Python supported by xlrd are 2.6, 2.7, 3.2 and 3.3! Very exciting stuff, and a massive thank you to Thomas Kluyver (@takluyver on GitHub) for

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented

2012-09-02 Thread python-excel
Albert-Jan Roskam wrote: > Hi, > > As a work-around, you could use the CRAN R package XLConnect, using > RPy or RPy2, to do what you want. IIRC it's based on Java, so it's not > extremely fast. > http://cran.r-project.org/web/packages/XLConnect/vignettes/XLConnect.pdf > This is another package I

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented

2012-08-31 Thread Albert-Jan Roskam
what have the Romans ever done for us? ~~  > > From: "python-ex...@raf.org" >To: python-ex...@googlegroups.com; Python List >Sent: Thursday, August 30, 2012 4:57 AM >S

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented

2012-08-30 Thread Chris Withers
On 30/08/2012 03:57, python-ex...@raf.org wrote: hopefully the intention that xlrd not support formats in xlsx files will change one day into an intention to support them. :-) The intention is there, sadly the time to work on it is not. John Machin would be the person best placed to do the

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not implemented

2012-08-29 Thread python-excel
he cell might have had. :-) apart from that, it does give access to number formats so your suggestion would work for simpler spreadsheets. hopefully the intention that xlrd not support formats in xlsx files will change one day into an intention to support them. :-) until then my users can kee

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not imlemented

2012-08-29 Thread John Yeung
> is there any other way to tell how many digits excel would round to > when displaying a floating point number? that's my only reason for > needing formatting_info=True. I have not personally used it, but OpenPyXL is another option for working with .xlsx files, and it might provide the formatting

xlrd-0.8.0 .xlsx formatting_info=True not imlemented

2012-08-28 Thread python-excel
hi, i just tried xlrd-0.8.0 so as to be able to read xlsx files only to discover: NotImplementedError: formatting_info=True not yet implemented there's a post from 2009 stating that the current intention is to not support formatting_info: https://groups.google.com/forum/?fromgroups=#!

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

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

Re: [pyxl] xlrd 0.8.0 released!

2012-08-18 Thread Brent Marshall
My compliments to John and Chris and to any others who contributed to the new xlsx capability. This is a most welcome development. Thank you. Brent -- http://mail.python.org/mailman/listinfo/python-list

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 .x

Re: [pyxl] xlrd 0.8.0 released!

2012-08-01 Thread Matthew Smith
Thank you guys so much! I am so excited to finally have xlsx so my users don't have extra steps! On Wed, Aug 1, 2012 at 11:01 AM, 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<http

xlrd 0.8.0 released!

2012-08-01 Thread Chris Withers
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 Machin for all his work on making this happen. Opening of .xlsx files is seamless, just use xlrd a

xlrd 0.7.9 released!

2012-06-20 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.9: http://pypi.python.org/pypi/xlrd/0.7.9 This release fixes an annoying merge bug on my part that resulted in a "NameError: global name 'BYTES_X00' is not defined" error where opening certain Excel files. B

xlrd 0.7.8 released!

2012-06-07 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.8: http://pypi.python.org/pypi/xlrd/0.7.8 This release features the following changes: - Compatibility with Python 2.1 and 2.2 is restored. - Fix for github issue #7: assertion error when reading file with xlwt-written bitmap

xlrd 0.7.7 released!

2012-04-13 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.7: http://pypi.python.org/pypi/xlrd/0.7.7 This release features the following changes: - Google Spreadsheet doesn't write the undefined-contents byte at the end of a NOTE record. Excel doesn't care. Now xlrd does

Re: xlrd 0.7.6 released!

2012-04-06 Thread Karim
ches so I don't have to modify the xlrd one for xls binary file. I will use both in the same program. Many thanks Cheers Karim -- http://mail.python.org/mailman/listinfo/python-list

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

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&#x

xlrd 0.7.6 released!

2012-04-04 Thread Chris Withers
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 released 0.7.6, which will

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'

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 --upgrad

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 u

Re: [pyxl] xlrd 0.7.4 released!

2012-04-03 Thread Lukas Graf
On Tuesday, April 3, 2012 9:34:27 AM UTC+2, Chris Withers wrote: > As pointed out, I stuffed up the release by not including a new file in > the MANIFEST. My bad. > > I've just release a 0.7.5 that fixes this. > Works! Thanks for the quick reaction! Regards, Lukas -- http://mail.python.o

Re: [pyxl] xlrd 0.7.4 released!

2012-04-03 Thread Chris Withers
On 03/04/2012 08:04, Chris Withers wrote: Hi All, I'm pleased to announce the release of xlrd 0.7.4. *sigh* As pointed out, I stuffed up the release by not including a new file in the MANIFEST. My bad. I've just release a 0.7.5 that fixes this. cheers, Chris -- Simplistix

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

xlrd 0.7.4 released!

2012-04-03 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.4. This release features the following changes: - Fixed a bug where xlrd was silently truncating long text formula results - Avoid parsing STYLE records when formatting_info=False - More tolerance of out-of-spec files. -

xlrd 0.7.3 released!

2012-02-28 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.3. This release just brings in some documentation updates that were missed for 0.7.2. cheers, Chris -- Simplistix - Content Management, Batch Processing & Python Consulting - http://www.simplistix.co.u

Re: [pyxl] xlrd 0.7.2 released!

2012-02-23 Thread Chris Withers
On 23/02/2012 14:40, xlstime wrote: Hi, i want to learn pyxl please help me... kindly send useful information about pyxl I would suggest: - using your real name when posting - reading the tutorial at http://www.python-excel.org/ cheers, Chris -- Simplistix - Content Management, Batch Pro

Re: [pyxl] xlrd 0.7.2 released!

2012-02-23 Thread xlstime
Hi, i want to learn pyxl please help me... kindly send useful information about pyxl *Thank you in Advance* XLS S :) On Thu, Feb 23, 2012 at 4:45 AM, wrote: > Chris Withers wrote: > > > On 22/02/2012 00:37, python-ex...@raf.org wrote: > > >was good for previous versions. two reasons that sp

Re: [pyxl] xlrd 0.7.2 released!

2012-02-23 Thread Chris Withers
On 22/02/2012 23:17, Adrian Klaver wrote: I can see where that would be preferred when managing multiple versions of Python, but not when using a single version. Sorry, I don't agree. It is *never* a good idea to install packages globally. Using virtualenv or similar (buildout, etc) gives you

Re: [pyxl] xlrd 0.7.2 released!

2012-02-22 Thread Adrian Klaver
nstaller is non-trivial. Assuming a Windows installer is not in the offing, the OP might find it easier to use the Python packaging from here on out. For an example, to find out information on a package: aklaver@tucker:~/.pip$ pip search xlrd xlutils - Utilities for working

Re: [pyxl] xlrd 0.7.2 released!

2012-02-22 Thread python-excel
Chris Withers wrote: > On 22/02/2012 00:37, python-ex...@raf.org wrote: > >was good for previous versions. two reasons that spring to mind > >immediately are: > > > > - it makes it much easier to tell what version is installed > > - it makes it much easier to uninstall the package > > > >i know

Re: [pyxl] xlrd 0.7.2 released!

2012-02-22 Thread Chris Withers
On 22/02/2012 00:37, python-ex...@raf.org wrote: was good for previous versions. two reasons that spring to mind immediately are: - it makes it much easier to tell what version is installed - it makes it much easier to uninstall the package i know that both of these are things that the pyth

Re: [pyxl] xlrd 0.7.2 released!

2012-02-21 Thread python-excel
Chris Withers wrote: > Hi All, > > I'm pleased to announce the release of xlrd 0.7.2. This release, > like the xlwt release, is long overdue and has been over 2.5 years > in the making! > [...snip...] > > I've currently only put up .tar.gz sdists, if anyon

xlrd 0.7.2 released!

2012-02-21 Thread Chris Withers
Hi All, I'm pleased to announce the release of xlrd 0.7.2. This release, like the xlwt release, is long overdue and has been over 2.5 years in the making! The highlights: - All messaging and debug logging is now written to the logfile provided to open_workbook. - Tolerant handling of

Re: Porblem with xlutils/xlrd/xlwt

2010-01-10 Thread John Machin
> > > > > what could be the problem? > > > > > Does rb = xlrd.open_workbook('somesheet.xls', on_demand=True) work by > > > > itself? > > > > Yes it does. The problem is with line: wb =  copy(rb) > > > here I am getting the error: Att

Re: Porblem with xlutils/xlrd/xlwt

2010-01-10 Thread pp
mand=True) work by > > > itself? > > > Yes it does. The problem is with line: wb =  copy(rb) > > here I am getting the error: AttributeError: 'Book' object has no > > attribute 'on_demand' > > Please replace the first 4 lines of your script by these 6

Re: Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread John Machin
rb) > here I am getting the error: AttributeError: 'Book' object has no > attribute 'on_demand' Please replace the first 4 lines of your script by these 6 lines: import xlrd assert xlrd.__VERSION__ == "0.7.1" from xlwt import easyxf from xlutils.copy import copy

Re: Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread pp
t; AttributeError: 'Book' object has no attribute 'on_demand' > > > > WARNING: Failure executing file: > > > > > Why is it so?? > > > > > from xlrd import open_workbook > > > > from xlwt import easyxf > > > > fro

Re: Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread Jon Clements
mand' > > > WARNING: Failure executing file: > > > > Why is it so?? > > > > from xlrd import open_workbook > > > from xlwt import easyxf > > > from xlutils.copy import copy > > > rb =  open_workbook('source.xls',formatting_in

Re: Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread pp
On Jan 9, 3:42 am, Jon Clements wrote: > On Jan 9, 10:24 am, pp wrote: > > > > > Whenever i run the code below I get the following error: > > > AttributeError: 'Book' object has no attribute 'on_demand' > > WARNING: Failure executi

Re: Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread Jon Clements
On Jan 9, 10:24 am, pp wrote: > Whenever i run the code below I get the following error: > > AttributeError: 'Book' object has no attribute 'on_demand' > WARNING: Failure executing file: > > Why is it so?? > > from xlrd import open_workbook > fro

Porblem with xlutils/xlrd/xlwt

2010-01-09 Thread pp
Whenever i run the code below I get the following error: AttributeError: 'Book' object has no attribute 'on_demand' WARNING: Failure executing file: Why is it so?? from xlrd import open_workbook from xlwt import easyxf from xlutils.copy import copy rb = open_

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

xlrd+excel determine decimal separator

2009-09-17 Thread peter
Hi experts, 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. Thx in advance. Rg, Peter -- http://mail.python.org/mailman/listinfo/python-list

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 requ

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

xlrd - insert column?

2009-07-28 Thread LeeRisq
Does xlrd have the capability to insert a column? -- http://mail.python.org/mailman/listinfo/python-list

[xlrd] sanitize the output and store in a 2d arrays

2009-01-27 Thread Jay Jesus Amorin
Hi gurus, Script: #!/usr/bin/python import xlrd, sys def main(toParse): workBook = xlrd.open_workbook(toParse) mySheet = workBook.sheet_by_index(0) for rownum in range(mySheet.nrows): print mySheet.row_values(rownum) if __name__ == '__main__': if len(sys

Re: getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getb

2008-12-10 Thread JodyGnumeric
[EMAIL PROTECTED]> wrote: > > > > > En Fri, 05 Dec 2008 02:31:01 -0200, pk sahoo <[EMAIL PROTECTED]>   > > > > escribió: > > > > > > hallo everybody, > > > > > when i am running the following command > > > > > >

Re: getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getb

2008-12-08 Thread John Machin
31:01 -0200, pk sahoo <[EMAIL PROTECTED]>   > > > escribió: > > > > > hallo everybody, > > > > when i am running the following command > > > > >>>> import xlrd > > > >>>> book=xlrd.open_workbook("C:\\a.xls") >

Re: getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getb

2008-12-08 Thread JodyGnumeric
; hallo everybody, > > > when i am running the following command > > > >>>> import xlrd > > >>>> book=xlrd.open_workbook("C:\\a.xls") > > > > i am getting the following error.. > > > > *Traceback (most recent call last): > >

Re: getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getb

2008-12-08 Thread John Machin
On Dec 8, 6:48 pm, "Gabriel Genellina" <[EMAIL PROTECTED]> wrote: > En Fri, 05 Dec 2008 02:31:01 -0200, pk sahoo <[EMAIL PROTECTED]>   > escribió: > > > > > hallo everybody, > > when i am running the following command > > >>>>

Re: getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getbo

2008-12-07 Thread Gabriel Genellina
En Fri, 05 Dec 2008 02:31:01 -0200, pk sahoo <[EMAIL PROTECTED]> escribió: hallo everybody, when i am running the following command import xlrd book=xlrd.open_workbook("C:\\a.xls") i am getting the following error.. *Traceback (most recent call last): File "&qu

getting error...... Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlrd\__init__.py", line 370, in open_workbook biff_version = bk.getbof(XL

2008-12-04 Thread pk sahoo
hallo everybody, when i am running the following command >>> import xlrd >>> book=xlrd.open_workbook("C:\\a.xls") i am getting the following error.. *Traceback (most recent call last): File "", line 1, in File "C:\Python25\Lib\site-packages\xlr

Re: xlrd cell background color

2008-08-14 Thread patrick . waldo
olour_map does not make much sense to me since the numbers change without an apparent pattern. Could you clarify? Best, Patrick Revised Code: import xlrd filenames = {} filenames.setdefault('GREEN',[]) filenames.setdefault('RED',[]) book = xlrd.open_workbook("/home/pwaldo

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

xlrd cell background color

2008-08-13 Thread patrick . waldo
Hi all, I am trying to figure out a way to read colors with xlrd, but I did not understand the formatting.py module. Basically, I want to sort rows that are red or green. My initial attempt discovered that >>>print cell text:u'test1.txt' (XF:22) text:u'test2.txt'

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 work

Re: xlrd

2008-08-04 Thread Edwin . Madari
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 range(book.nsheets): sh = book.

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')Resulta

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

xlrd

2008-08-04 Thread Yeats
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 t

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

xlrd: error open_workbook

2008-07-28 Thread Fabio Oikawa
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_workbook*function: wb

Re: Importing xlrd

2008-06-03 Thread Chanman
On Jun 2, 5:48 pm, John Machin <[EMAIL PROTECTED]> wrote: > On Jun 3, 8:23 am, Chanman <[EMAIL PROTECTED]> wrote: > > > This is probably a simple question to most of you, but here goes. > > I've downloaded the xlrd (version 0.6.1) module and placed in in the >

Re: Importing xlrd

2008-06-02 Thread John Machin
On Jun 3, 8:23 am, Chanman <[EMAIL PROTECTED]> wrote: > This is probably a simple question to most of you, but here goes. > I've downloaded the xlrd (version 0.6.1) module and placed in in the > site-packages folder. Now, when I write a script, I type: > > import sys &g

Re: Importing xlrd

2008-06-02 Thread Gary Herron
Chanman wrote: This is probably a simple question to most of you, but here goes. I've downloaded the xlrd (version 0.6.1) module and placed in in the site-packages folder. Now, when I write a script, I type: import sys import xlrd When I run it, there is an import error saying there

Importing xlrd

2008-06-02 Thread Chanman
This is probably a simple question to most of you, but here goes. I've downloaded the xlrd (version 0.6.1) module and placed in in the site-packages folder. Now, when I write a script, I type: import sys import xlrd When I run it, there is an import error saying there is no module named

  1   2   >