Calculate sum, max, min for multiple columns in excel( Issue with studio)

Help
, ,
1

Hi all,
Actually, I have a issue with [studio]. I need to calculate sum,max and min for multiple columns in excel(attached is query which i have posted couple of days back in forum)

Calculate sum,maxi and mini for the multiple columns in excel sheet?RPA Developers

Hi all, I need to calculate sum,maximum and minimum for all the columns in the attached excel sheet. Can you please help me out with this ASAP. [image]

The solution given by them is ok and its working fine but When i’m giving the expression ‘dt.AsEnumerable…’ in assign activity in a normal sequence its working and the ‘.sum’ function is visible but when i invoke the sequence and do the same, ‘.sum(func…’ is not working after i type ‘dt.AsEnumerable.’
This is happening only on my desktop\studio whereas its working in any other desktop.I have tried uninstalling [studio] and re installed. and done workaround as mentioned here : AsEnumerable is not a member of ‘System.Data.Datatable’
but still can’t access ‘.sum’(or ‘.max’ (or) ‘.min’) functions inside the invoked sequence.
Can anyone please look into this issue?
Thank you in advance.

2 Likes
2

if you have system.linq, system.linq.expressions in your project import section than you are good to go, uninstall/reinstall studio should not be done for only this problem…

4 Likes
3

Thanks a lot :heart_eyes: @bcorrea That’s working now !!!

2 Likes
4

@bcorrea Btw do i need to add these imports manually everytime when i deal with invoking sequences? If so what are all the basic and essential imports that are to be in a workflow to avoid such queries in future?

5

to be honest those ones should be there by default, i know i never did put them in manually in uipath…

6

Yes, I have opened a new REFramework now and checked if these imports are available by default but no. :disappointed:

7

there must be some package that when you use it puts them there is guess, or you have old version?

8

May be but I’m using the latest version of Uipath 19.12.0-beta.61.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.