I have a peculiar issue where I am trying to read values from excel into a dataset in c#.
Some of my excel cell contains a line break like this. (Press Alt+ Enter in a cell to include line break within a cell)
While reading this excel in my program through Fill Command. This line break is read as "_".
How do i address this scenario? Either I want to clean up all the escape sequence before importing from excel.