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

Joel Goldstick joel.goldstick at gmail.com
Sat Mar 16 20:49:08 CET 2013


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

> s.arun316 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20130316/8ac2ae87/attachment.html>


More information about the Python-list mailing list