xlrd read number as string

python xlrd
Virgil Balibanu picture Virgil Balibanu · Aug 20, 2015 · Viewed 12.3k times · Source

I am trying to read from an xls file a long number (6425871003976) but python keeps trunking it before it reads it as a number not a string (6.42587100398e+12). Is there any method to read it directly as a string even thou in the xls file it is a number?

values = sheet.row_values(rownum)

in values it appears correctly (6425871003976.0) but when I try values[0] it is already switched to the incorrect value.

Solution:

This was my solution using repr():

if type(values[1]) is float:  
    code_str = repr(values[1]).split(".")[0]
else:
    code_str = values[1]
product_code = code_str.strip(' \t\n\r')

Answer

Dunes picture Dunes · Aug 20, 2015

It's the same value. All that's different is how the value is being printed to screen. The scientific notation you get is because to print the number str is called on it. When you print the list of values the internal __str__ method of the list calls repr on each of its elements. Try print(repr(values[0])) instead.

Related questions

Create a .csv file with values from a Python list

I am trying to create a .csv file with the values from a Python list. When I print the values in the list they are all unicode (?), i.e. they look something like this [u'value 1', u'value 2', ...] If I …

Read More
Read Excel File in Python

I've an Excel File Arm_id DSPName DSPCode HubCode PinCode PPTL 1 JaVAS 01 AGR 282001 1,2 2 JaVAS 01 AGR 282002 3,4 3 JaVAS 01 AGR 282003 5,6 I want to save a string in the form Arm_id,DSPCode,Pincode. This format is configurable, i.e. it might change to …

Read More
writing to existing workbook using xlwt

I am unable to find examples where xlwt is used to write into existing files. I have a existing xls file that I need to write to. When I use xlrd to read the file, I cant seem to figure …

Read More