Epplus excelrange.text return wrong text for date and datetime

Benjamin Chew 41 Reputation points

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?

An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,390 questions
{count} votes