openpyxl convert data to float

[deanhystad]

i have one more question what if my first second row is =====, how to able to implement, like this:
[inline]
atettime Tput Tput2
====== ===== ========
20221018.165317.401555 0.000545 0.000545
20221018.165327.401723 0.001422 0.000545
[/inline]
i run it occur error:
ValueError: could not convert string to float: '===='

This is why you don't want to use a solution where you assume certain cells will have certain values. My example doesn't care if you add columns or a row of "====" into the mix. It will pass the "====" through as text. If you don't want that in the spreadsheet, skip it.

    with open(src, "r") as src:
        # First line is column headings
        line = next(src).split()
        sheet.append(line)
        # Next line is thrown away
        next(src)