Invoke code: Exception has been thrown by the target of an invocation / 2-digits-after-the-decimal-point

[Soudios (Sou)]

Hi @prasath_S

How to have a rounding to 2 digits after the decimal point in excel

@prasath17 it will not takes a lot of time ? because il have 200.000 rows on my excel file

i use this invoke code and it was working
dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Somme de Ratio”)= Math.round(cdbl(row(“Somme de Ratio”)),2))

but now i have this error :

i think its because i have empty cell now

[prasath_S]

Hi @Soudios

Please try this,

dt.asenumerable.Where(function(row) not String.IsNullOrEmpty(row("Somme de Ratio").ToString)).ToList().ForEach(Sub(row) row(“Somme de Ratio”)= Math.round(cdbl(row(“Somme de Ratio”)),2))

It is similar to this one,

Skip Empty Row in DataTable

Hello, I Have this scenario. I have DT, and I want to convert the value on the specific column from string to Decimal. it’s working fine if all the row is not empty, but it went to error when some row is empty. I’m using invoke code to convert the row dt.asenumerable.tolist.foreach(sub(row) row(Col)= CDec(row(Col))) [image] Thanks,

Thanks

[Soudios (Sou)]

Thank you @prasath_S as usual its perfect

[prasath_S]

Glad that helped🙂