нужно решить эту задачу
Hi
I don’t see any file attached and also include your expected output
so it will easy to understand the scenario
Regards
пока не могу прикрепить файл я новичек
try below steps
- Use read Range workbook activity
- Use remove duplicate rows activity
- Use Assign activity to sum the values
Create a variable Total of type string
dt1.AsEnumerable().Sum(Function(s) Cdbl(s("ColumnName").Tostring())).ToString
instead of columnName give your column name as per screen shot like “Cymma”
- Use Add data row to add line with total value
{"","","Total",Total}
- Use write range to write the result data to excel
Refer to above screen shot to get some clarity
also find the xaml file but you have change accordingly
JoinDataTables.xaml (28.0 KB)
Regards
а есть видео? я так вспе равно не понял тонкости?
Yes it was for my sheet you can not directly use the flow as it is make changes as per my previous post
Use below one
dt1.AsEnumerable().Sum(Function(s) Cdbl(s("Cymma").Tostring())).ToString
Check again is it “Cymma”
for add datarow activity replace as per below
{"","","Total",Total}
Regards
Здравствуйте. Вроде получилось исправить все ошибки. Как теперь посмотреть результат?
Выполнение робот завершено in: 00:00:01. Вот что в выводе ошибок нету и исходный файл не изменился
can you check their should be one more sheet added to you initial file named “SumD”
in that sheet you can find the results
Regards
спасибо вам огромное, удалось с вашей помошьюрешить проблемму
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.