Uipath에서 엑셀로 값을 수정하는 방법 좀 알려주세요

Help Studio
, ,
1

image
Price에 있는 값들을 ,를 제외한 int형(예 : 600000)으로 바꾸는 방법을 알려주세요.

2

Hi @toto6343

Try this:

Save to: dt
Value to Save: (From row In dt.AsEnumerable()
     Let productName = row.Field(Of String)("Product")
     Let price = (row.Field(Of Double)("Price")).ToString.Replace(",", "")
     Select dt.Clone().Rows.Add({productName, CInt(price)})).CopyToDataTable()

Hope it helps!!

3

Hi @toto6343

=> Read Range Workbook
image
Output-> dt

=> Use the below syntax in Assign:

Save to: dt
Value to Save: (From row In dt.AsEnumerable()
     Let productName = row.Field(Of String)("Product")
     Let price = (row.Field(Of Double)("Price")).ToString.Replace(",", "")
     Select dt.Clone().Rows.Add({productName, CInt(price)})).CopyToDataTable()

=> Write Range Workbook dt
image

image
image860×558 73.8 KB

Hope it helps!!

1 Like