Is it possible to copy a particular sheet? If possible, how will I do it?

[juniusfree]

No description provided.

[fzumstein]

Currently not yet, but I will add this as a feature request. If you are on Windows and want to work around for now, you can do Sheet(1).xl_sheet.Copy(Before=Sheet(1).xl_sheet). But the After keyword is broken in pywin32, so if you need this, you'd have to wait until it's implemented.

[juniusfree]

Ok thanks! love to see it in the future releases.

[bersanri]

Hi!
I'm just writing you to know if this issue has been solved.

[fzumstein]

Nope, the status is on the top left - still open...

[fedterzi]

Using v0.10.4 I had to replace xl_sheet with api: Sheet(1).api.Copy(Before=Sheet(1).api)

[Elijas]

If you want to copy a sheet to the end - the workaround for the broken After keyword is broken in pywin32 is to create a temporary sheet at the end using the native xlwings sheet.add, then copy a sheet Before the newly created sheet and finally delete the newly created sheet.

[bobjoylove]

sht.api.Copy() is not in V0.11 and we have no way to copy a sheet :(

[fzumstein]

In the more recent versions of xlwings, here's an example of how to work around it:

import xlwings as xw
wb = xw.books.active
sht = wb.sheets['Sheet1']
sht.api.Copy(Before=sht.api)

[bobjoylove]

import xlwings as xw
wb = xw.books.active
sht = wb.sheets['Sheet1']
sht.api.Copy(Before=sht.api)

raise AttributeError("Unknown property, element or command: {!r}".format(name)) from e

AttributeError: Unknown property, element or command: 'Copy'

Options alphabetically at sht.api. are beginswith(operand), contains(operand) and doesnotbeginwith(operand)
Notes: fresh install at 0.11 using pip install xlwings. Do I need to install the api somehow?

[manobeeslaar]

Hi there,

Is there a work around for MAC? To copy a sheet from one workbook to another workbook?

Thank you,

[fzumstein]

On macOS, this is how it works:

import xlwings as xw

wb = xw.books.active
sht_api = wb.sheets[0].api
sht_api.copy_worksheet(before_=sht_api)

[manobeeslaar]

Thank you!

[mullimanko]

@fzumstein, I can't retrace what you wrote in your first post that After keyword is broken in pywin32. See: https://stackoverflow.com/questions/64820928/move-worksheet-within-a-workbook-to-the-end/64837195#64837195

[fzumstein]

@mullimanko gotcha, thanks for your note!

[ffisc]

Here you go:

import xlwings as xw

wb = xw.books.active
sht_api = wb.sheets[0].api
sht_api.copy_worksheet(before_=sht_api)

Hi, has the API changes by any chance? I'm trying this and getting

File "C:\Users\xxx\Anaconda3\lib\site-packages\xlwings\_xlwindows.py", line 141, in __getattr__
    self._oleobj_.GetIDsOfNames(0, item)
pywintypes.com_error: (-2147352570, 'Unknown name.', None, None)

[fzumstein]

@ffisc that's the macOS version, if you are on Windows, do: #123 (comment)