System.FormatException: Input string was not in a correct format

[Leonidars]

Hello

I have a problem with this script. Whats is wrong with it?

Please Login or Register  to view this content.

The error message is

{returnCode=200;sessionId=61388600-3ed8-42f6-b502-d59efe08aabd;exception=System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at dotNETWebActions_RunScript.RunScriptFromFile.Execute(ActionRequest req, ISession s, IActionRegistry reg)
at com.iconclude.agent.ActionProxy.Execute(ActionRequest cmd, ISession s, IActionRegistry reg);}

Why not in correct format ? everything looks fine.

Best regards
L

[davesexcel]

This could be the problem.
Change to

Please Login or Register  to view this content.

Why do you have it as a function?

[Leonidars]

I'm using software to run a script on a Windows Remote Server. I wan to run this script there. And my soft needs this to run this as function.

I've changed this as you mentioned but it failed with the same error

[davesexcel]

You might have to attach a sample with the offending code

[Leonidars]

Sample.zip Done.

[royUK]

It looks like you are looking for the text "ok" & deleting the rows containing it. This should not be a Function, but maybe this will work

Please Login or Register  to view this content.