Integers from excel files become floats?

by

Excel treats all numbers as floats. In general, it doesn’t care whether your_number % 1 == 0.0 is true or not.

Example: A1 = 63.0, B1 = 63, C1 = INT(A1), A2 = TYPE(A1), B2 = TYPE(B1), C2 = TYPE(C1)
You’l see that TYPE() returns 1 in each case.

From the Excel Help:

If value is   TYPE returns 
Number        1 
Text          2 
Logical value 4 
Error value   16 
Array         64

xlrd reports what it finds. xlrd doesn’t mangle its input before exposing it to you. Converting a column from (62.9, 63.0, 63.1, etc) to (62.9, 63, 63.1, etc) would seem like a pointless waste of CPU time to me.

More Related Contents:

  1. GroupBy results to dictionary of lists
  2. Create a .csv file with values from a Python list
  3. Preserving styles using python’s xlrd,xlwt, and xlutils.copy
  4. writing to existing workbook using xlwt [closed]
  5. Pandas: Looking up the list of sheets in an excel file
  6. python xlrd unsupported format, or corrupt file.
  7. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  8. Get formula from Excel cell with python xlrd
  9. Error: Unsupported format, or corrupt file: Expected BOF record
  10. Convert date from excel in number format to date format python [duplicate]
  11. How to obtain sheet names from XLS files without loading the whole file?
  12. Python xlwt – accessing existing cell content, auto-adjust column width
  13. xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]
  14. Insert row into Excel spreadsheet using openpyxl in Python
  15. Python Creating Dictionary from excel data
  16. Edit existing excel workbooks and sheets with xlrd and xlwt
  17. Identifying Excel Sheet cell color code using XLRD package
  18. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  19. How to rename many files in many folders with python? [duplicate]
  20. Modifying list while iterating [duplicate]
  21. Why does this UnboundLocalError occur (closure)? [duplicate]
  22. Numpy array assignment with copy
  23. Read file data without saving it in Flask
  24. Unzipping and the * operator
  25. Random is barely random at all?
  26. System-wide mutex in Python on Linux
  27. What does version name ‘cp27’ or ‘cp35’ mean in Python?
  28. How to validate more than one field of a Pydantic model?
  29. get the DST boundaries of a given timezone in python
  30. BeautifulSoup: get css classes from html

Leave a Comment