Felix Zumstein

Looks like a pywin32 bug to me, `xlwings.Sheet("Invoice").xl_sheet.PrintOut(Copies=2)` should work. What about just doing the following as a workaround? ``` copies = 2 for i in range(copies): xlwings.Sheet("Invoice").xl_sheet.PrintOut() ```

`xl_sheet` is gone since 0.9.0. `sht.api.PrintOut()` should work, the output you see is expected.

It's on the list, but currently, you'd need to go via `.api`, doing something like this: https://stackoverflow.com/a/51633063/918626

thanks for logging this. yes, xlwings can only handle df with basic types and we should be able to check for this.

Color behaves like in VBA and what you're looking for is currently not supported.

The only thing I can think of is making a small macro in VBA, then call that via the xlwings macro function: this will still loop though each cell, but...

sure, please send!

Yeah I guess we still want to add that object caching functionally at some point, it just hasn't made it to the top...

It's not just the dlls, though, is it? see also #1187, #1719

These days it's even better to do the following instead of relying on the active app: ``` win32api.MessageBox( mybook.app.hwnd, 'Hello world!', 'Info', win32con.MB_ICONINFORMATION) ``` where `mybook` is your xw.Book object....