Division between two number

Help Studio
1

How can I write into the “KOMADA” column the result obtained by dividing the “saldoeura” colimn by 1.9?

image
image134×476 2.62 KB

2

Hey @dvojinovic ,

Follow the steps

  1. Read the excel file and store the value in dt_input
  2. Create a intCounter variable and assign with 2
  3. Take for each row in data table activity and pass the dt_input
  4. Inside the for each row in data table take one assign activity and pass the value like this DoubleInputValue = Cdbl(CurrentRow("saldoeura").ToString.Trim.Replace(",",""))
  5. Now divide the value like this DoubleResult = DoubleInputValue / 1.9
  6. Use Write cell activity and in the cell pass "M"+intCounter.ToString and value you can pass the DoubleResult.ToString
  7. increment the counter after the for writecell activity like this intCounter=inCounter+1

Everything should happen in a loop

That’s all

3

The image shows an automation workflow for processing Excel data, where it reads data from a specified sheet, performs a calculation on each row, and writes the result back to the sheet in a specified column. (Captioned by AI)
The image shows an automation workflow for processing Excel data, where it reads data from a specified sheet, performs a calculation on each row, and writes the result back to the sheet in a specified column. (Captioned by AI)560×943 22.7 KB

Expressions for Write Cell activity :

What to write:
(CDbl( CurrentRow("saldoeura").ToString)/1.9).ToString()

Where to write: Excel.Sheet("Sheet1").Cell("M"+dt_inputdata.Rows.IndexOf(CurrentRow)+2).ToString())

1 Like
4

Hi @dvojinovic

You can make use of invoke code

The image shows a workflow involving a "Read Range Workbook" activity to read data from "Inputfile.xlsx" on "Sheet1" and an "Invoke Code" activity that iterates through data rows to modify a "KOMADA" column by rounding values from the "saldoeura" column. (Captioned by AI)
The image shows a workflow involving a "Read Range Workbook" activity to read data from "Inputfile.xlsx" on "Sheet1" and an "Invoke Code" activity that iterates through data rows to modify a "KOMADA" column by rounding values from the "saldoeura" column. (Captioned by AI)592×393 10 KB

image
image854×113 5.55 KB

For Each row As DataRow In YourDataTable.Rows
    row("KOMADA") = Math.Round(CDbl(row("saldoeura").ToString.Replace("," , ".")) / 1.9, 2)
Next

Here in the Komodo column the “,” is replaces as decimal (.)

If you want to ignore the “,”

For Each row As DataRow In YourDataTable.Rows
    row("KOMADA") = Math.Round(CDbl(row("saldoeura").ToString.Replace("," , "")) / 1.9, 2)
Next

Hope this helps!

5

@dvojinovic,

Just use write cell activity to write the formula in M2 cell. Then use Fill Range activity to fill the remaining column with the formula at M2 cell.

1 Like
6

@dvojinovic

  1. Write cell formula activity with formula as =L2/9 in M2 cell
  2. Auto fill range to fill formula down

Cheers

1 Like
7

Hi @dvojinovic

Use the below formula in Fill Range activity:

"=SUBSTITUTE(A2,"","",""."")/1.9"

The image shows an automation process in a software interface designed to fill a range of cells in an Excel file with a formula that substitutes characters in cell A2 on Sheet4. (Captioned by AI)
The image shows an automation process in a software interface designed to fill a range of cells in an Excel file with a formula that substitutes characters in cell A2 on Sheet4. (Captioned by AI)740×709 30.7 KB

Hope it helps!!

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.