If I am using GUI SPY what should i be using to add the data in the different sheets but in one excel file, is there any way ?
Yes, this can be done.
Instead of using GUI Spy for writing data, it is recommended to use Microsoft Excel Writer, which is more stable and efficient.
In Microsoft Excel Writer:
-
Specify the same Excel file path.
-
Mention the required Sheet Name in the configuration.
-
You can write data to different sheets by changing the sheet name accordingly.
If the sheet name needs to be created dynamically, you can:
-
Pass the sheet name as a parameter.
-
Use Workflow Executor and pass the sheet name dynamically.
Using Excel Writer is preferred over GUI Spy for Excel operations because it avoids UI dependency and improves performance.
If you specifically need to use GUI Spy (Windows Automation), please confirm, as that approach would require interacting with the Excel UI elements directly.
Thank you !!
