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

Question

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?

pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft Excel', 'Workbook is protected and cannot be changed.', 'xlmain11.chm', 0, -2146827284), None) — Shambulinga H, Apr 27 '22 at 06:50
Code please? Just edit your question, its going to be more readable. — NoBlockhit, Apr 27 '22 at 06:52

score 0 · Accepted Answer · answered Apr 28 '22 at 20:34

0

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.

answered Apr 28 '22 at 20:34

Eric M

131
1
6

Thank you for valuable time taken for answer to this question. – Shambulinga H Apr 29 '22 at 14:13

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

1 Answers1