Workaround for Python to decimal numbers when reading Excel data using XLRD

When Python reads Excel data using XLRD, integers become decimals:

Workaround:

1. One of the simple things is to add a comma in English before the cell contents of the number and date. If the data is more, you can also batch add commas prefix (online there are methods). (This is relatively suitable when the amount of data is relatively small, if the amount of data is relatively large, we recommend that you use Method 2)

2. The CType of the contents of the cell is determined by the program code to resolve

Instance:

For I in range (rows):

    If i==0:
        Continue
    Row_content = []
    For j in Range (COLS-1):
        CType = Sheet.cell (i, J). CType  # Table data type
        Cell = Sheet.cell_value (i, J)

        If CType = = 2 and cell% 1 = = 0.0:  # CType is 2 and floating point
            cell = Int (cell)  # Floating-point to Integer


        Print (cell)

After successful execution:

Workaround for Python to decimal numbers when reading Excel data using XLRD