Error Message: TypeError: expected <class ‘openpyxl.styles.fills.fill’>
Error Explanation: This error occurs when a function or method in the code expects an object of the class ‘openpyxl.styles.fills.fill’, but receives an object of a different class or a different type altogether. In other words, the expected object is not compatible with the actual object being provided.
Example: Let’s consider a scenario where we have a function that expects a fill object from the openpyxl library, but accidentally receives a string instead. This will result in a TypeError with the message mentioned above.
from openpyxl.styles.fills import PatternFill
def apply_fill(fill):
if isinstance(fill, PatternFill):
print("Fill applied successfully!")
else:
raise TypeError("Expected fill of type 'PatternFill', received " + str(type(fill)) + " instead.")
fill = 'Solid Fill'
apply_fill(fill)
In the above example, the function apply_fill expects a fill object of type PatternFill from the openpyxl.styles.fills module. However, we mistakenly pass a string 'Solid Fill' instead of a PatternFill object.
When running this code, a TypeError will be raised with the message: TypeError: expected <class 'openpyxl.styles.fills.fill'>, received <class 'str'> instead.
To resolve this error, make sure you are passing the correct object type to the function that expects it. In this case, you should pass a PatternFill object instead of a string.