I would like to total up all values/cells of a specific column and store the sum in a variable to keep on working with it.
So far I implemented this:
String_var = excel_original.AsEnumerable.Sum(Function(x)Convert.ToDecimal(x(10))).ToString
The problem is that this code does not consider the commas which are the decimal separators.
So in the case below
… the result should actually be 13. But it’s 130 since the comma is not considered.
Can someone please help?