Epplus excelrange.text return wrong text for date and datetime

Benjamin Chew 41

In my site user will upload an excel file with some data to be saved to the system. I am using EPPlus for extracting data from excel file. I am encountering an issue for date and datetime data. Eg: if user enter 30/03/2021 in the excel file, the code will only read that particular cell text as 30. How do i fix this?

Timon Yang-MSFT 9,586

@Benjamin Chew
Could you please show your code with this problem?
I used this code for testing, but there is no problem.

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;  
  
            using (var pck = new ExcelPackage(new System.IO.FileInfo(@"C:\...\1.xlsx")))  
            {  
                var ws = pck.Workbook.Worksheets[0];  
  
                var test1 = ws.Cells["A1"].Value;  
         
                Console.WriteLine(test1);  
            }

Timon Yang-MSFT 9,586 Reputation points

2021-09-09T05:59:55.647+00:00

@Benjamin Chew
I have not heard from you for a couple of days. Please let me know if there is anything that I can help here

Share via

Epplus excelrange.text return wrong text for date and datetime