How to split up a row of a specific excel column by "new line"?

[manjula_rajendran]

Hi,

1. First read your excel to datatable.
2. open for each row loop
3. Trim the column title like row(“category”).trim
4. Split by new line as
   arr = row(“category”).tostring.Split(Environment.NewLine.TocharArray)
5. Now assign arr(0) to category and arr(1) to title