Re: Im fetching data from excel using python code.. i could see some junk value also with it.

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder7.xlned.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<joel.goldstick@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.002
X-Spam-Evidence	'H': 1.00; 'S': 0.00; '16,': 0.03; 'binary': 0.05; 'versions,': 0.05; 'completeness': 0.07; 'python': 0.09; 'agree,': 0.09; 'get.': 0.09; 'subject:using': 0.09; 'undocumented': 0.09; 'cc:addr:python-list': 0.10; 'subject:python': 0.11; 'sat,': 0.15; '"features"': 0.16; 'it..': 0.16; 'reliably': 0.16; 'subject: \n ': 0.16; 'xlrd': 0.16; 'wrote:': 0.17; 'fix': 0.17; 'module': 0.19; 'back.': 0.22; 'engineering,': 0.22; 'simpler': 0.22; 'cc:2**0': 0.23; '>': 0.23; "python's": 0.23; 'cc:addr:python.org': 0.25; 'header:In- Reply-To:1': 0.25; 'am,': 0.27; '(such': 0.27; 'message- id:@mail.gmail.com': 0.27; 'options': 0.27; 'subject:some': 0.29; 'writes:': 0.29; 'url:mailman': 0.29; 'skip:& 10': 0.29; 'mode': 0.30; 'code': 0.31; 'url:python': 0.32; 'file': 0.32; 'could': 0.32; 'url:listinfo': 0.32; 'extract': 0.33; 'subject:data': 0.33; 'true.': 0.33; 'values.': 0.33; 'problem': 0.33; 'excel': 0.33; 'tutorial': 0.33; 'skip:& 20': 0.33; 'received:google.com': 0.34; 'received:209.85.220': 0.35; 'received:209.85': 0.35; 'url:org': 0.36; 'subject:with': 0.36; 'author': 0.37; 'two': 0.37; 'received:209': 0.37; 'data': 0.37; 'subject:: ': 0.38; 'some': 0.38; 'things': 0.38; 'takes': 0.39; 'google': 0.39; 'url:mail': 0.40; 'think': 0.40; 'your': 0.60; 'remove': 0.61; 'export': 0.62; 'between': 0.63; 'email addr:gmail.com': 0.63; 'reverse': 0.65; 'you:': 0.75; '2013': 0.84; 'subject:.. ': 0.84; 'subject:value': 0.84; 'joel': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=F/A9BC0ciPSw9nJPrkWCpbGVZZfJd9Dfc9d7IvB4LNs=; b=mrTcqrUI8oKTTZCd2pFsWyo0L0dhva6cHu2U5SEqr0v61bR7QkxLXV7WT4KLuNQLC/ AxGjGIIjLldpASqEKINxrQz0MS4wicdF3rqk7G7BdaMfSBG8EyZnrF5RfJdB0CQROYil mvEQGlRdc0Gld4HhCVMgnQqCbNYyMZAj0E+pIEOhd9qsPCApGJkaR60kJuI/jZ+70fcs FfRv0O/B3woCwsjfu2HDnlcYt4PEKp8uEqCj1qQz2e+BXVKUZovwstlpWLSoxYTzCPgH kT6c1cTdhrBdPmOTlmE8WDJpjN4m5gtUXql/RDZl/1NE/Pd1fZf7897bAv0JtbuyYZGs UOkw==
MIME-Version	1.0
X-Received	by 10.52.178.161 with SMTP id cz1mr10957496vdc.7.1363463348581; Sat, 16 Mar 2013 12:49:08 -0700 (PDT)
In-Reply-To	<87boajaldx.fsf@handshake.de>
References	<0fa3b412-b9e8-4312-8cb4-db3ba3b3b2ca@googlegroups.com> <87boajaldx.fsf@handshake.de>
Date	Sat, 16 Mar 2013 15:49:08 -0400
Subject	Re: Im fetching data from excel using python code.. i could see some junk value also with it.
From	Joel Goldstick <joel.goldstick@gmail.com>
To	dieter <dieter@handshake.de>
Content-Type	multipart/alternative; boundary=bcaec519644b8eb93104d8100c81
Cc	"python-list@python.org" <python-list@python.org>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
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.3371.1363463351.2939.python-list@python.org> (permalink)
Lines	107
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1363463351 news.xs4all.nl 6881 [2001:888:2000:d::a6]:40352
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:41326

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

On Sat, Mar 16, 2013 at 2:50 AM, dieter <dieter@handshake.de> wrote:

> s.arun316@gmail.com writes:
>
> > Hi im fetching data from excel using python code.. i could see some junk
> value also with it. like [text:u
>

I used the xlrd module some time back.  I think if you google for tutorial
on it you will find your answer

> >
> > How to remove it.. below is the code
>
> It is very difficult to extract data reliably from an undocumented binary
> format (such as "excel" files): things can change between versions,
> some "features" may be used only in particular situations
> difficult to get at by reverse engineering,
> lacking a complete documentation completeness is difficult to get.
>

This isn't true.  The xlrd module takes care of this

>
> I see two options for you:
>
>   *  send a problem report with your data to the "xlrd" author
>
>      He may know how to fix it.
>
>   *  Tell "excel" to export the file to "csv" and
>      use Python's "csv" mode to read the values.
>

I agree, that this is a simpler aproach

>
> --
> http://mail.python.org/mailman/listinfo/python-list
>



-- 
Joel Goldstick
http://joelgoldstick.com

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

Thread

Im fetching data from excel using python code.. i could see some junk value also with it. s.arun316@gmail.com - 2013-03-15 04:33 -0700
  Re: Im fetching data from excel using python code.. i could see some junk value also with it. dieter <dieter@handshake.de> - 2013-03-16 07:50 +0100
  Re: Im fetching data from excel using python code.. i could see some junk value also with it. Joel Goldstick <joel.goldstick@gmail.com> - 2013-03-16 15:49 -0400

csiph-web