Convert number text to number in excel and how to sum up the column?

@kieranwong

  1. First use Read Range activity to read the data from Excel and will give you output as Datatable and say DT.

  2. And then try below expression.

             String sumOfColumn = DT.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“ColumnName”).ToString.Trim) ).ToString
    
  3. And then write into excel file.

5 Likes