How to sum through linq query

Help Activities
, ,
1

Hi How can i write LINQ query to sum all different excel columns data separately and paste the total below them
in excel i have four diff columns data
Please find sample data for u r reference
format excel.xlsx (8.4 KB)

2

You can use LINQ select to manipulate the data while returning it.
Take a look at Enumerable.Select Method (System.Linq) | Microsoft Learn
This example its a good one:

IEnumerable<int> squares =
    Enumerable.Range(1, 10).Select(x => x * x);

foreach (int num in squares)
{
    Console.WriteLine(num);
}
/*
 This code produces the following output:

 1
 4
 9
 16
 25
 36
 49
 64
 81
 100
*/
3

Hi @T_Y_Raju

Try this

Dt.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Amont1")).ToString

Regards,

4

that is only for 1 column how about other columns like Bill Tax Bill invoice no

5

@T_Y_Raju

Same like that only you have to change column names

6

@T_Y_Raju

For 1 column, i am given same you can try for other columns

image
image829×580 29.6 KB

Amount1=DT.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Amont1")).ToString

"A"+(DT.RowCount+2).ToString

Output:

image
image568×531 6.97 KB

Regards,

7

for second column we have to write in the same query or different query
can u write how can we write for 2 columns

8

@T_Y_Raju

image
image829×791 45.6 KB

Amount1=DT.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Amont1")).ToString

"A"+(DT.RowCount+2).ToString

Bill=DT.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Bill ")).ToString

"B"+(DT.RowCount+2).ToString

Output:

image

Regards,

9

Check here → LINQ Sum Function to Sum up Collection Items - Tutlane

10

thank you very much for your help

11

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