I want to write line by line data into new excel and then 2 row data how i can do this
Split lines using Environment.Newline
add them using add data row to datatable and use write range
or loop through the extracted data after split
and use write cell to write the data and variablize your cell reference
You can use Append Range activity @Kuldeep_Pandey
I dont know why same data is writting in excel in 2 row also
Show what you are doing I guess you did not change the string
its running in a loop what should i change
in loop how are you writing is it through array? or are you looping on the strings directly?
what loop is it
its taking input data from another excel and creating output file
great…so in loop what are you doing…what are you looping on…without those details how would anyone know what you are trying to do
The steps of reading excel and creating output can be done in n ways…which way did you choose?