"Get Text" + "Excel Application Scope"

Help Studio
#1

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:
1

Any idea how to fix this?

Thanks,
Diego

#2

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

#3

Hi @mukeshkala,

I tried and the variable is fine, it is not null, but the error is still there.

Any idea?

Thanks,
Diego

#4

Can you print this path in a write line and verify what are you getting ?

C:\Users\NewFile - "+ Variable.ToString + “.xlsx”

#5

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

#6

Hello @495713

Check if you pass the data correctly when you invoke your workflow…

#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

#8

Hi,

I converted the Var1 in the Workflow1 into an Argument and imported it in the Workflow2.

Does it need other actions?

Thanks,
Diego