Hello Everyone
I need help with simple task I have excel sheet and I need to copy just row 2 to another sheet in the same file called “completed”
when the data copy I want make sure to copy to an empty row or the next available so does not delete or overwrite existing data
Thank You
Fine
Hope these steps would help you resolve this
—use excel application scope and pass the file path as input
—Inside the scope use a read range activity where mention the sheetname as sheet1, range as “” and get the output with a variable of type datatable named dt
—and again use another read range with sheetname as “completed” and range as “” and get the output with a variable of type datatable named Finaldt
—to pass row 2 alone to completed sheet then use a ADD DATAROW activity and mention the datarow as dt.Rows(0) and in the datatable mention as Finaldt
—so now the datatable Finaldt will be appended with the row 2 from dt datatable
—now use a write range activity and pass the sheet name as “completed” and datatable as Finaldt and make sure that add headers property is enabled in the property panel of write range activity
Kindly try this and let know for any queries or clarification
Cheers @BeasantyBrayne
mkankatala
sandyarpa767
Nam_Hoang
nayeem732
Vidhi_Patel
Shruthika_r