Hello Everyone I’m still new in UIPATH programming and trying to programm a robot , which count the Data in a specific excel Column and store the number as a message box in another excel file within a specific range .Can any one help with how to store the number of data ??
Hi @Abx9,
It would be great if you could attach sample input/Output excel files in order to understand and give best solution.
Thanks,
1 Like
i would like to count the number of data in column C (down the pic ) and store it in another excel file within a specific range
and store it in this range
If you want to get count of items/rows present in first excel file,
- Read excel file using read range activity. Store data in InputDT variable.
- Get item count using InputDT.Rows.Count
- Write count (InputDT.Rows.Count) in 2nd excel using write Cell activity
Thanks,
1 Like
i wrote a programm and reached till here
could you please demonstrate how to save this message box in another excel file
You can use Write Cell Activity
to update count in 2nd excel file.
1 Like
Could u Please demonstrate how to do it step by step , Sorry for the many questions but I’m still new
Mappe1.xlsx (5.4 MB)
here is the Excel file i’m working on
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.