Hi,
I used a “Get Text” and created a Variable as Output.
Then I used an “Excel Application Scope” and to create a .xlsx file, but with this path I get an error:
"C:\Users\NewFile - "+ Variable.ToString + “.xlsx”
And this is the error:
Any idea how to fix this?
Thanks,
Diego
hi @495713 ,
Before this : "C:\Users\NewFile - "+ Variable.ToString + “.xlsx”
Take a If and verify that variable is not null by using - String.IsNullorEmpty(Variable.tostring) - If Null - Assign a Default value to variable say- ExcelName else use Variable.ToString.
Also , After the getText - you can check if the output variable is null - Try Getting the text by OCR or other Techniques.
–
Mukesh
Hi @mukeshkala ,
I tried and the variable is fine, it is not null, but the error is still there.
Any idea?
Thanks,
Diego
Can you print this path in a write line and verify what are you getting ?
C:\Users\NewFile - "+ Variable.ToString + “.xlsx”
Hello,
I actually find out it is working properly, i get an error when I get the text in a Workflow but using that data in a second Workflow I invoke.
Any idea why?
In the first Workflow the data is stored in an Out_Argument and in the second one in a In_Argument.
Thanks,
Diego
mz3bel
(Mohssine HILAL)
May 9, 2020, 10:59pm
6
Hello @495713
Check if you pass the data correctly when you invoke your workflow…
Seema_S
(Seema S)
May 10, 2020, 2:37am
7
@495713
go to the argument panel of the 2nd workflow and give the same variable name which u have given in the 1st workflow.
I am sure it will work.
If you have already resolved it , mark this thread as resolved
Hi,
I converted the Var1 in the Workflow1 into an Argument and imported it in the Workflow2.
Does it need other actions?
Thanks,
Diego