Change Excel's column type

Help Activities
, , ,
1

Hi guys. I ve a problem. I ve three columns in my datatable. I used the formula for the sum of columns A and B to create column C. So I wrote =A+B in the first row of column C and applied it for all rows. However, due to another problem I’m having, I need to store the numbers in column C as numerical values instead of formulas. For this reason, I used the “Copy Paste Range” activity. But when I type the CopyItems option as Value in this activity, there is a Monetary value. I want to buy it as a double instead of a monetary value. How will I do it? I dont want to use for each

2

Hi @Ali_Osman_Kaya ,
You can format cell after finish write

image
image771×366 14.8 KB

regards,

3

I got an error. "Activity is valid only inside the “Use Excel File”. But ı used excel application scope

4

Hi @Ali_Osman_Kaya ,
You need read more about it
https://docs.uipath.com/activities/other/latest/productivity/format-range-x
it need inside ‘Use excel file’

image
image570×565 14.1 KB

5

image
and

image
image487×518 19.2 KB

you need change format, your path file, your range,…
regards,

6

@Ali_Osman_Kaya

Try this Linq

yourDataTable.AsEnumerable().ToList().ForEach(Sub(row) row.SetField(Of Double)(“C”, CDbl(row(“C”))))

Cheers…!

7

@Ali_Osman_Kaya

yourDataTable.AsEnumerable().ToList().ForEach(Sub(row) row(“C”) = CDbl(row(“C”).ToString().Replace(“$”, “”).Replace(“,”, “”)))

cheers…!