Sep-08-2023, 12:29 PM
Sep-08-2023, 12:36 PM
In the future, post error messages as code, not screenshots please. Supply more information about what you did to get this error. Is this code you wrote, or code you downloaded from somewhere? What version of python are you using?
Sep-08-2023, 12:44 PM
(Sep-08-2023, 12:36 PM)deanhystad Wrote: [ -> ]In the future, post error messages as code, not screenshots please. Supply more information about what you did to get this error. Is this code you wrote, or code you downloaded from somewhere? What version of python are you using?
Got it and apologize. This is code that someone wrote that left their job. I'm using Python 3.11. The code seemed to be working fine until I updated the excel file it reads.
Sep-08-2023, 01:02 PM
My guess would be that the excel file has a column that is supposed to be all integers, but you entered something that is not a number. When the datatype for a column cannot be discerned by the contents, the default is to treat the data as strings. Somewhere in the program there is a comparison made between two columns, or values from two columns, and it could not be done because the datatype for the columns are not compatable.
Can you post the code?
Can you post the code?