Search code examples
pythonxlwings

How do i copy the all worksheets using xlwings module in python?


I have a macro excel file, it's having 3 worksheets. I need to saveas or copy all worksheets to new excel sheet. How to do in python using xlwing module?


Solution

  • Sorry, I cannot comment yet, so I will have to "answer". For pwintypes errors it is many times caused by Trust Center setting issues. Please see this link https://docs.xlwings.org/en/stable/addin.html . Also, like NoBlockhit asked, some code would help.