How to use rename sheet activity

Hello,

i need to rename exscel sheet.
i have new sheet name in item variable of for each and old sheet nsame is sheet1 and sheet 2 and to write values i am just writing sheet+varable which chnage to 1 and 2.
using rename sheet activity.
which is not accepting string data.
image
accepts only sheet ref
image

how can i pass sheet+variable?
help me on same.

Hi @Mathkar_kunal

You need to specify the From (Which will be the target sheet) like this & then you will be able to update the sheet.

image

Hope this helps,
Best Regards.

ok can i use this in normal excel aplication scope? rename sheet activity

@Mathkar_kunal

This activity is only valid inside the Use Excel activity, and thus cannot be used with Excel Application Scope.

Best Regards.

ok i will try

In Addition to

We will use the sheet name with Excel.Sheet(“YourSheetName”).Name statement
grafik

1 Like

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