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

dieter dieter at handshake.de
Sat Mar 16 02:50:34 EDT 2013


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
>
> 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.




More information about the Python-list mailing list