Variable type(Write Range activity)

[mini9301]

Hi,

First, I created a variable, ‘오늘날짜시트’ for the ‘Reference new sheet name’ of Insert Sheet acticity.

Second, I tried to use the variable created for the sheet name of Write Range activity, but, had an error as below.

I guess, it is because the type of the variable created(ISheetRef) and required type(String) of sheet name of Write Range activity are different.

How should I fix the source in this case?

Please advice…

[mkankatala (Mahesh Kankatala)]

Hi @mini9301

The Variable of Reference is in ISheetRef Datatype, If you want to get the sheet name from that then give like this, Variable.Name

Check the below image for better understanding,

Hope it helps!!

[Parvathy (PS Parvathy)]

Hi @mini9301

You need to pass the SheetName within Double quotes or if you passing it through variable it datatype is System.String.

Regards

[mini9301]

Oh, good, It worked!

Thank you for your advice…

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @mini9301

Happy Automation!!