Epplus excelrange.text return wrong text for date and datetime

Question

Epplus excelrange.text return wrong text for date and datetime

Benjamin Chew 42

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,606

@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,606 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

Your answer

Timon Yang-MSFT 9,606 Reputation points

2021-08-17T09:09:49.493+00:00

@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,606 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

Your answer