We are facing a very odd issue in our production environment. The service using the EPPlus library to generate an excel file with multi tab works fine, but randomly it throws an error message complaining about “Table Table1 Column ColumnName does not have a unique name'”. I have checked the code Mutiple times, and all looks good. I copied my production database to our development environment and the code runs fine whereas failed on production dataset.

functions in columns I and J show result “0” while the sum is 0 or the cells in column H is empty