Anyone having solution of my problem

Help AI Center
,
1

i want extract the data from multiple excel sheet to one sheet and in multiple sheet having the numbers they can add and only total of particular number write to the

2

image
image1366×768 90.1 KB

in that type i have multiple sheet and having sum of the hours in perticular sheet add them and write in new sheet any one help me for that

3

Hi @Shubham_Bidwai

You can try with this LINQ expression

(From d in dtData.AsEnumerable Where Not (isNothing(d("Hours")) OrElse String.IsNullorEmpty(d("Hours").toString.Trim)) Select v = CDbl(d("Hours").toString.Trim)).Sum(Function (x) x)

Check out the thread

Regards
Gokul

4

image
image1366×768 131 KB

error is shown
can you write the expression i told you my file name and data table also

5

@Gokul001 Plz help me for the solution

6

HI @Shubham_Bidwai

Check out the XAML file

SumExcelColumn.xaml (16.1 KB)

image
image943×352 27.3 KB

Regards
Gokul

7

hi @Gokul001 can you provide ref video for me i will fallow that video

8

I don’t have any video. Have you check the XAML file? @Shubham_Bidwai

9

ya check that but i did not understand

10

i am new in RPA (UI Path)

11

Hi @Shubham_Bidwai

Check out this XAML file It will be start forward as simple

SumUsingLINQ.xaml (8.8 KB)

image
image883×377 18.3 KB

Regards
Gokul

12

thanks @Gokul001 i will try the same procedure

13

@Gokul001 i want sum of number of hours in excel sheet not from built data table
i have number of excel sheet and i want the only total number of hours in each excel sheet

14

Hi @Shubham_Bidwai

Instead of Build data table Use Excel Read Range activity and try it bro. It is only for your reference XAML file. Based on that you can build your automation.

Regards
Gokul

15

Okay thank you @Gokul001 i will create boat definitely from your guidance

16

image
image1366×768 111 KB

@Gokul001 can you explain the error

17

In the excel file the Sheet name 14 is not exist. Can you check the Input excel file whether the Sheet 14 is exist or not?