Copy every line from text file and writing whole line in the Cell of excel file

I have a use case in which I have to copy every line from text file and write it in a Cell of Excel file.
I have attached sample text file

image

Hi @Deepak_M

Use read text file activity and use string var=StrText.split("",String split options.none)

Thanks
Ashwin.S

Hi @AshwinS2
Do you have any sample workflow.
I am getting error in above command.

hi @Deepak_M

Use Read Text File

Create a string array variable

String arr1=StrInput.Split(CChar(VbCrlf))

arr1(0).ToString.trim

Thanks
Ashwin S