[email protected] 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