Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41326

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

Show all headers | 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