Search code examples
c#.netepplus

EPPlus not loading cells correctly

I have an excel with 3 worksheets. Every worksheet has around 100 columns.

There are some values that exist in the excel, but when I try to access them with EPPlus it returns no text.

What could be the problem?

To load the excel I do this:

byte[] bytes = Convert.FromBase64String(validarExcelDto.ExcelBase64);
using MemoryStream memoryStream = new(bytes);
using ExcelPackage package = new(memoryStream);
ExcelWorkbook workbook = package.Workbook;

For example, in cell CG3 of the third sheet the text is "Hello". When I try to load it with EPPlus with this line workbook.Worksheets[2].Cells["CG3"] the text is "".

Solution

  • The problem was the file itself. It was corrupt.