Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41302

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

Show all headers | View raw

s.arun316@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.

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Im fetching data from excel using python code.. i could see some junk value also with it. s.arun316@gmail.com - 2013-03-15 04:33 -0700
  Re: Im fetching data from excel using python code.. i could see some junk value also with it. dieter <dieter@handshake.de> - 2013-03-16 07:50 +0100
  Re: Im fetching data from excel using python code.. i could see some junk value also with it. Joel Goldstick <joel.goldstick@gmail.com> - 2013-03-16 15:49 -0400

csiph-web