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 "".
The problem was the file itself. It was corrupt.