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

126
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
LAST QUESTIONS
All questions
POPULAR ONLINE
jQuery Categories

Java mariadb jdbc connection with mysql_clear_password authentication

MYSQL Join two tables through relationtable

debugged at this line $('.LEGHIGH').prop('checked', 'checked');

Get object with the highest property value in PHP array

Javascript - To remove duplicates in array object for ES5 [duplicate]

READ ALSO
How do I detect bubble letter numbers
Python

How do I detect bubble letter numbers

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

 63
Is it possible to call a Python DoFn from a Java ParDo in Apache Beam?
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...

 38
Positive and Negative Regex in Python
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:

 83
Whenever I try using tensorboard I get no module found error
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

 51