Write range0

I want to write line by line data into new excel and then 2 row data how i can do this

Hi @Kuldeep_Pandey

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

cheers

You can use Append Range activity @Kuldeep_Pandey

I dont know why same data is writting in excel in 2 row also
image

Hi @Kuldeep_Pandey

Show what you are doing I guess you did not change the string

cheers

its running in a loop what should i change

@Kuldeep_Pandey

in loop how are you writing is it through array? or are you looping on the strings directly?

what loop is it

cheers

its taking input data from another excel and creating output file

@Kuldeep_Pandey

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?

cheers