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

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<gallium.arsenide@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.019
X-Spam-Evidence	'H': 0.96; 'S': 0.00; 'url:pypi': 0.03; 'subject:: [': 0.03; 'formatting': 0.07; 'subject:skip:f 10': 0.09; 'subject:not': 0.11; 'need:': 0.16; 'number?': 0.16; 'to:name:python list': 0.16; 'url:packages': 0.16; 'subject:] ': 0.19; 'received:209.85.214.174': 0.21; 'to:2**1': 0.23; 'header :In-Reply-To:1': 0.25; 'message-id:@mail.gmail.com': 0.27; 'point': 0.31; 'url:python': 0.32; 'info': 0.32; 'subject: .': 0.33; 'to:addr:python-list': 0.33; 'excel': 0.33; 'another': 0.33; 'received:google.com': 0.34; 'received:209.85': 0.35; 'there': 0.35; 'but': 0.36; 'url:org': 0.36; 'option': 0.37; 'received:209': 0.37; 'to:addr:python.org': 0.39; 'received:209.85.214': 0.39; 'subject:-': 0.40; 'header:Received:5': 0.40; 'john': 0.60; 'personally': 0.61; 'url:5': 0.61; 'url:index': 0.61; 'needing': 0.62; 'provide': 0.62; 'subject:True': 0.93
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=v4UQAZNaDrfw/fpyfKWJVRwUHtPkkv6bNe8H05klIiQ=; b=srpk7SBTVfSauZEjQ3wKdqxwV3LyLN/6RnNvR3YO4uGUCfgUX4qmWK6ToEtMWsfP+y AmPBDUZjoOHzHDcpxvRyIpDxsDu+OFYEI1ngi3Cm338LOoGkMN58W1cLCJg/YkrZClI/ ACq6EI49FzDQMaGVwXfm2cJuY1dB80dr3c4SXJU507O7rPBBGqmq0IylReXoUi8S3UOC By6S2h7wvYro6DKOmLZaKsy2YzpJ5IlEoggCiGwvZFYs6Clp63wmcFhSoFsCX2XJZeUS Ad/OAhPHXNm5mQCw2qve6yqdq9e6Hn3DzLFewOVTlFPNxjpSVTzU6jg6nAIIdKR8eHsk gvNw==
MIME-Version	1.0
In-Reply-To	<20120829021646.GA8163@raf.org>
References	<501944E4.2090902@simplistix.co.uk> <CA+GpVts=-cmJutJxM2KYC-oZ3+FyKpZ5WLzubtUiOY9Nu7Mxiw@mail.gmail.com> <5c84fd3b-c899-4703-867d-ddbc5d1746de@googlegroups.com> <20120829021646.GA8163@raf.org>
Date	Wed, 29 Aug 2012 09:27:01 -0400
Subject	Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not imlemented
From	John Yeung <gallium.arsenide@gmail.com>
To	python-excel@googlegroups.com, Python List <python-list@python.org>
Content-Type	text/plain; charset=ISO-8859-1
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.3935.1346246824.4697.python-list@python.org> (permalink)
Lines	12
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1346246824 news.xs4all.nl 6886 [2001:888:2000:d::a6]:49771
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:28065

Show key headers only | View raw

> 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 info you
need:

  http://packages.python.org/openpyxl/index.html
  http://pypi.python.org/pypi/openpyxl/1.5.8

John Y.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: [pyxl] xlrd-0.8.0 .xlsx formatting_info=True not imlemented John Yeung <gallium.arsenide@gmail.com> - 2012-08-29 09:27 -0400

csiph-web