EPPlus Shows System Argument Exception

Question

I am having issue reading in some worksheet from a workbook using C# and EPPlus.

Error Message

name contains invalid characters

Even after multiple checks on the worksheet name, file name and column headers within the workbook to make sure there is no invalid characters, I am still facing the same error.

However, when I move the worksheet that i need from that same workbook to a new Excel file and save it with the same file name and worksheet name, I have no error while reading in.

Does anybody know how to solve or even encounter this problem?

Code

 using (ExcelPackage xlPackage = new ExcelPackage(mStream))
 {
    //WorksheetId = 5
    var ws = xlPackage.Workbook.Worksheets[WorksheetId]; //This is the part that is causing error

      for (int i = 1; i <= ws.Dimension.End.Column; i++)
      {
         dt2.Columns.Add((i - 1).ToString());
      }
 }

Answer 1

Came across this LINK and realized this is actually a bug in EPPlus for version 4.5.2.2 onward.

After reverting back to the older version, everything works fine.