How do I clear an incorrect error message using openpyxl?

58 views
Skip to first unread message

Richard David

unread,
Apr 24, 2023, 10:55:44 AM4/24/23
to openpyxl-users

I'm using openpyxl to write a formula to an Excel workbook. The formula generates the error Formula Omits Adjacent Cells. It does omit the adjacent cells, but that is intentional. How do I use openpyxl to ignore the error?

I see there's an error module an https://openpyxl.readthedocs.io/en/latest/api/openpyxl.worksheet.errors.html but I don't know how to use it.

Simplified example:

ws["A1"].value = "=sum(C1:E1)"

Reply all
Reply to author
Forward
0 new messages