Forum Discussion
1 Reply
Sort By
- TanyaYatskovskaSmartBear Alumni (Retired)
Hi Dhirendranaga,
To accomplish your task, I guess you’ll need to work with Excel via COM. Refer to the Working With Excel Files via COM article – it contains a Python sample that you can use to get started.
Also, you need to analyze Excel COM’s documentation to learn the approach you can use to copy a sheet from one file to another one. I’ve found some sample in Stackoverflow: http://stackoverflow.com/questions/29555607/python-copying-one-work-sheet-to-another-in-excel