I noticed that when using the “Write Range” command, UiPath automatically creates a sheet if it doesn’t already exist in the destination Excel file.
How can I make it stop that?
I am currently copy+pasting from one Excel workbook (let’s say Excel1) with multiple sheets to another (say Excel2). Excel 2 contains mainly the same sheets as Excel 1, so I am using “For Each” and “.GetSheets” commands.
However, in some instances Excel1 contains sheets that don’t exist in Excel2. Excel2 however is the standard format so I don’t want UiPath to add sheets to it…
Would appreciate your help!