Getting error in delete sheet of modern design experience activity

[Gayathri_Mk]

Hi Team,
I am getting below error when I try to delete the sheet using delete sheet activity of modern design experience.

Delete Sheet: Unable to get the Delete property of the Worksheet class

[mkankatala (Mahesh Kankatala)]

Hi @Gayathri_Mk

Have you encapsulate the delete sheet activity in Use excel file activity. If not, Drag the delete sheet activity and drop it in the inside of the use excel file activity.

In another case, if the sheet is protected by any password, it unable to delete the sheet and make ensure the sheet exist in workbook.

Hope it helps!!

[Gayathri_Mk]

I am using inside use excel file activity only

[mkankatala (Mahesh Kankatala)]

@Gayathri_Mk Could you please provide the workflow. Then it will be easier to make things easier.

Check the Sheet is protected and sheet is exist in the workbook or not.