Im fetching data from excel using python code.. i could see some junk value also with it.
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list