May-31-2019, 04:44 PM
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.
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.