output Excel
Add the extracted data in another dataTable and then use write range to write the data table into another Excel file.
Hope it helps,
2 Likes
Hello @Manju_Reddy_Kanughula ,
Please share the screenshot of the Write range Activity.
(Make sure after reading you assigned to DataTable variable and you have used DataTable variable in write range as well)
Regards,
Rohith
I Could read the data also
You are reading column values and storing the data in IEnumerable
and while writing u need to loop through these items (to update 1 value per cell.
Use for loop and loop through items of OT_Rate (IEnumerable)
and inside for loop use write cell to write each item in a cell.
Let me know if you need an example for this.
Regards,
Rohith
what should I type in variable section
Hello @Manju_Reddy_Kanughula ,
Use Write cell instead of Write Range.
It coming blank
@Manju_Reddy_Kanughula - Make sure you have used the correct Index (As you have mentioned Column U in your code).
Also you have to increment the int_RowIndex value, while updating the value in next cell else it will over write in the same cell.
Try using write line and print the value of item.ToString and int_RowIndex+5.
Every Time U5 only it is taking
@Manju_Reddy_Kanughula
In for each Create a Index variable (Type Int32)
In Wrote cell use : āUā+(Index+2).ToString
as given in below image it will work for you.
Excel file where i need to write but it is not writing
For eac h activity
able to read the data & Row
@Manju_Reddy_Kanughula - Everything looks good here, even the cell index and values are printing.
just verify the file name / path is correct and it is the one which you are referring now.
(Put a message box and print)