How to use XLWINGS to Copy Range and Paste Special Including All Formatting

November 13, 2019, at 6:10 PM

What I am trying to achieve is to copy a range of cells in one workbook and paste it with the same formatting on the other workbook's specific tab. Formatting includes merged cells, borders, filling, text color, and size.

I think there is a way to do it by using api to reference VBA but I totally have no clue...

My code looks like this

import xlwings as xw
from xlwings import constants
wbOldbook = xw.Book(r"path\OLdFile.xlsm")
wbNewbook = xw.Book(r"NewFile.xlsm")
wsRackold = wbOldbook.sheets('OldTab')
wsRacknew = wbNewbook.sheets('NewTab')
CopyRack = wsRackold.range('X16:AG60').value
wsRacknew.range('X16:AG60').value = CopyRack

POPULAR ONLINE

round number instead of decimals

jQuery ajax success method not working correctly

How TO fix Recv failure: Connection was reset Error in ssl curl

Wordpress - Order by meta_value_num not working

How do I disable/remove/hide selected option in a select for other selects?

How do I detect bubble letter numbers

How should I process and then find the number out of this image:

Python

Is it possible to call a Python DoFn from a Java ParDo in Apache Beam?

Suppose I'm building a Beam pipeline in Java that will run on a DataflowRunnerIs it possible to call a Python DoFn from a Java ParDo? (or to use a Python PTransform in such a setting?) If this functionality doesn't exist out-of-the-box, what would it take to implement...

Python

Positive and Negative Regex in Python

I've been using RegEx expressions in Python for a while and I want to find out if it possible to ask RegEx to match a line that has a value in the line but also does not have a value in the same line:

Python

Whenever I try using tensorboard I get no module found error

When I run the command tensorboard --logdir runs --hostlocalhost on my windows I get an error like this ModuleNotFoundError: No module named 'tensorboardmain'; 'tensorboard' is not a package