UiPath Community Forum
Need to copy value and need to paste in column till the rows ends
Help
Studio
copy
,
date
,
excel-tables
,
datatable
,
excel-automation
,
uiautomation
,
activities
,
excel
,
studio
Dimple
(Dimple P)
January 8, 2025, 2:14pm
4
Read the sheet and name as dtdata.
Now use assign activity and assign strIndex (string type) = (dtdata.rowcount+1).ToString
Next use Fill range - where to write - Excel.Sheet(“Sheet Name”).Range(“J2:J”+ strIndex)
what to write - “23/12/2024”.
show post in topic
Related topics
Topic
Replies
Views
Activity
How to copy the same value in excel
Studio
datatable
,
excel
,
data_manipulation
10
1195
August 17, 2020
Copy upto Certain rows before a particular name comes
Studio
studio
,
question
,
activities_panel
7
1037
December 28, 2021
Copy specific column from one excel to another excel last row with specific column
Something Else
datatable
,
excel
,
studio
,
feedback
10
1996
March 21, 2022
Copy Paste in column under last not empty cell
Academy Feedback
datatable
,
excel
,
uiautomation
,
activities
,
question
3
1373
March 23, 2020
Copy pasting from excel to another sheet
Help
9
1158
August 18, 2019