Split values in a cell and segregate them in different rows

Hi @Palaniyappan , what is the datatype of out_valuearray ?

1 Like

its a variable of type string array
Cheers @shikharno.7


I am getting error.
option strict on disallows implicit conversions from ā€˜stringā€™ to ā€˜integerā€™

is this inside a for each row loop
or try with row(0).ToString.Split(Environment.Newline.ToArray())
Cheers @shikharno.7

actually it should be in a for each row loop
as the variable row is from that loop only
row(ā€œcolumn1ā€).ToString.Split(Environment.Newline.ToArray())
Cheers @shikharno.7

1 Like

were we able to get now buddy
Cheers @shikharno.7

1 Like

hey hi @ HareeshMRā€¦!!!
In my case I having data in any of the cellā€¦screen shoot given belowā€¦


it will not start from the first cell all the timeā€¦can you please help me outā€¦?