To Copy text values to Excel using Python

[ksasi2k3]

I am using Python to copy values from Text file to excel, able to succeed in that but the problem is that when pasting values to excel the existing formulas are removed.

I am using "import openpyxl" and also have a code as "data_only= False" when loading workbook. If I use this then values are pasted but formulas are removed, so changed "data_only= True" but unable to paste values corresponding to a column with formulas. Any help would be greatly appreciated. Thank you.