Im fetching data from excel using python code.. i could see some junk value also with it.
dieter at handshake.de
Sat Mar 16 07:50:34 CET 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