I had a situation in which I need to read a string of numbers separated by ‘;’ and convert it to a string of array.
The following script will read a string from excel and will convert in to string array
var a = readData.Split(';').Select(s => s.Trim()).Where(s=>!string.IsNullOrWhiteSpace(s)).ToList();
I had shared previously on how to read data from excel.
Hope it helps 🙂