Paste Special with multiple arguments with Dispatch

[CaptainCsaba]

Hi!

I am trying to change some cells in excel with python. There is an error that sometimes occures in column K. Basically the "The number in this cell is formatted as text or preceded by an apostrophe". In excel you just click on the error and the click on convert to number to get rid of it.

You can't do this in Python but I figured out a way around it. If you put "1" in a cell and copy it, and the used Pastespecial on the column K with Values and Multiply as operation it fixes it. I can almost do this in Python but can't find the correct syntax for it.

sheet['Z1'] = 1
from win32com.client import Dispatch

excel = Dispatch("Excel.Application")
excel.Visible = 1
source = excel.Workbooks.Open(mainworkingdirectory + "\\XYZ.xlsm")
excel.Range("Z1").Select()
excel.Selection.Copy()
excel.Range("K:K").Select()
excel.Selection.PasteSpecial(Paste = -4163, Operation = 4)

The last line is wrong. I got the two numbers from here, -4163 stands for the "Values" and 4 is for the "Multiply":
https://analysistabs.com/vba-code/range/m/pastespecial/

It runs fine, but the problem still stands. What am i doing wrong, is there another way around this?

[Larz60+]

can't you just cast the value as int?
int(value)

[CaptainCsaba]

It's inside the excel file and I need to make the conversion in excel with the tools of excel via Python. Just converting the via "int()" did not work. Or do you mean it in another way?

[Larz60+]

Or do you mean it in another way?

No, I thought this was a python extract.