I am using BalaReva Excel activities version 17.0.0 to rename few worksheets in 2-3 workbooks and copying all worksheets to a new workbook. while generating the workbook1 and workbook2 I am using rename worksheet activity and changed all the sheet names in Workbook1 and workbook2.
But when I am trying to copy these two workbook sheets to a new workbook I am getting the below error.
Copy To File : That name is already taken. Try a different one.
Getting this error for the second workbook.
Workbook1: ASheet1, BSheet1, CSheet1
Workbook1: ASheet2, BSheet2, CSheet2
Excel_Report_Consolidation_New has thrown an exception
Source: Copy To File
Message: That name is already taken. Try a different one.
Exception Type: COMException
System.Runtime.InteropServices.COMException (0x800A03EC): That name is already taken. Try a different one.
at BalaReva.Excel.Sheets.CopyToFile.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)