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 > > 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. 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. -- http://mail.python.org/mailman/listinfo/python-list