Error reading excel cell with line break into Data

2019-08-23 22:40发布

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)

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 "_".

enter image description here

How do i address this scenario? Either I want to clean up all the escape sequence before importing from excel.

0条回答
登录 后发表回答