INVOKE CODE ERROR CORRECTION


((IsNothing(x(“Description”)) OrElse String.IsNullOrEmpty(x(“Description”).ToString.Trim)) AndAlso x(“Description”).ToString.Contains(“TDS”))
(CurrentRow.Field(Of Double)(“Amount”)* -1)
(CurrentRow.Field(Of Double)(“SIGN”)* 10)
(CurrentRow.Field(Of Double)(“PERCENT”) - CurrentRow.Field(Of Double)(“SIGN”))
(Datediff(DateInterval.Day,DateTime.ParseExact(CurrentRow(1).ToString,{“dd.MM.yyyy hh:mm:ss”,“MM/dd/yyyy hh:mm:ss”,“MM-dd-yyyy”,“dd-MM-yyyy”},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None),now).ToString)

PLEASE HELP IN THIS INVOKE CODE

Hi,

For now, can you try to modify argument name and type as the following?

Regards,


Still getting error

Can you share what you expect by this code? It seems wrong syntax.

Regards,

RPA.xlsx (15.3 KB)

From “Sheet 1” to “Final Sheet”
Using INVOKE CODE

Hi @Krishan_Rapswal,
it seems syntax is wrong. can you tell me what you are expecting by using this syntax.

Regards,
Arivu

I Have to change in excel using invoke code

RPA.xlsx (15.3 KB)

INPUT - SHEET 1

OUTPUT - FINAL

I am using Assign value in INVOKE CODE

Sample.xaml (11.0 KB)
Please try but don’t know what the logic is with a due date

Can we short this method using if condition

Yes, you can.


what i am doing wrong


i want to loop Invoke Code what i am doing

  1. Your If condition does not have a condition specified. It’s just “If” followed by a set of assignments. Under what condition do you want row(“SIGN”) = “Amount”?
  2. “Amount”*(-1) is wrong because “Amount” is a String. I presume you want “Amount” to be a variable containing some number.

Could you describe in words what you plan to do for each row in dt_AsEnumerable?

Sample.xaml (11.2 KB)

I Have to short this Invoke Code Using LOOPING

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