Multiply column in excel with 50 using LINQ query

Help Activities
, , ,
1

Hello,

I am trying to multiply column “A” with 50 and write the result in “Result” Column.

With the total of the Result .

image

can any one help me how i can do that with LINQ Query

Thank you

1 Like
2

Hi @coder

Try this

[HowTo] - First Start with LINQ (VB.Net)

Thanks
Ashwin.S

1 Like
3

Hey @coder

Please find the demo below,

nmnithinkrishna_AddInUpdateXLCol.zip (9.7 KB)

Hope that helps.

Thanks
#nK

1 Like
4

Thank you @AshwinS2

5

Thank you @Nithinkrishna

1 Like
6

Cool @coder :slight_smile: :+1:

7

@Nithinkrishna could you please explain to me what you are doing in the assign?

Thank you

1 Like
8

Could you please show me the snap to check which Assign you are saying ?

1 Like
9

@Nithinkrishna Sure,

`

dt_Data.AsEnumerable.Select(Function(row) dt_DataCopy.Rows.Add(row.ItemArray.Take(dt_Data.ColumnCount - 1).ToArray.Concat(if(String.IsNullOrEmpty(row(“A”).ToString.Trim),{string.Empty},{CStr(CInt(row(“A”).ToString)*50)})).ToArray)).CopyToDataTable

And this

dt_DataCopy.Rows(dt_Data.RowCount-1).Item(dt_Data.ColumnCount-1)

=

dt_DataCopy.AsEnumerable.Select(Function(row) CInt(if(String.IsNullOrEmpty(row.ItemArray.Last().ToString),0,row.ItemArray.Last))).Sum

1 Like
10

Okay in the first Assign we are recreating the Data Table by updating the output column with calculation.

Second assign is to update the total value of it in the last row last column.

11

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