Only visible cells excel

[muhammet.sezer2 (Muhammet Sezer)]

Input.xlsx (9.5 KB)
Hello, I need your support on an issue. Thank you for the answers.

The data in the price column will be copied to columns B and C.
Details:
*The values ​​in the price column are irregular and will be converted to Turkish lira.
*Negative (-) values ​​will be copied to the overcharge column.
*Positive (+) values ​​will be copied to the undercharge column.
*Once the data is copied, the data under the Price column will be deleted.

The result should be as follows ;

*The total field should be the sum operation that backs up each other.

[postwick (Paul Ostwick)]

- Use Excel File
- - For Each Excel Row
- - - If CDbl(CurrentRow("PRICE").ToString) < 0
- - - - Then Assign CurrentRow("UNDERCHARGE") = CurrentRow("PRICE").ToString
- - - - Else Assign CurrentRow("OVERCHARGE") = CurrentRow("PRICE").ToString
- - - End If
- - Assign CurrentRow("PRICE") = ""

[mkankatala (Mahesh Kankatala)]

Hi @muhammet.sezer2

You can use the Excel activities to do the Excel Manipulations as your requirement. Check the below workflow for better understanding,
Sequence4.xaml (20.3 KB)

Hope it helps!!

[postwick (Paul Ostwick)]

It would be much simpler (and probably faster) to just use Assign CurrentRow(“PRICE”) etc instead of all those Write Cell activities.

[muhammet.sezer2 (Muhammet Sezer)]

Hi,Thanks for Answers.