How to write data to multiple excel sheets with different names?
Solved! Go to Solution.
You can use the "Set Active Excel Worksheet" action to switch between the Excel sheets using their names or index and then use the "Write to Excel Worksheet" activity to write the data for each.
You can use the "Set Active Excel Worksheet" action to switch between the Excel sheets using their names or index and then use the "Write to Excel Worksheet" activity to write the data for each.