On Sat, Mar 16, 2013 at 2:50 AM, dieter <die...@handshake.de> wrote: > s.arun...@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
-- http://mail.python.org/mailman/listinfo/python-list
