Please findout the error,,

[mukeshreddy4569]

Im trying Sum of Entire Column in excel ,but i getting this error,

[mukeshreddy4569]

linQ:

Excel_dt.AsEnumerable.Sum(Function(x) CDbl(x(“Cname”).ToString.Trim))

[lrtetala (Lakshman Reddy)]

Hi @mukeshreddy4569

Can you show the error, meanwhile try to delete the Read Range Workbook activity output and Reassign it. It must be datatype of System.Data.DataTable

Regards,

[Anil_G (Anil Gorthi)]

@mukeshreddy4569

You need to provide error screenshot in order for us to give resolution.

also as per read range error looks like excel_dt might not be a datatable

cheers

[bavyaravu133]

@mukeshreddy4569

Read Range: Change Variable type “System.Data.DataTable”

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @mukeshreddy4569

The variable you have created in the output field of read range workbook activity called Excel_dt which should be system.data.datatable datatype, open the variables panel and change the Excel_dt datatype to System.data.datatable.

This will sort your issue.

Hope you understand!!