Hi heiner55, I have done this already and I am able to copy the value from Text to excel when mentioning "data_only= True".
But I need to populate without this option because, when I use this "data_only= True" it removes formulas from other columns.
Hence I tried without this option and also by giving "data_only= False" but nothing happens. No values are copied, this because the cell contains formula, hence the value in the cell is not compared with text.
I have given a screenshot, and as highlighted in cell "E2" we have formula but I need only the value "12" to be taken and go to the text file with name "12", copy value and paste it in cell "G".
12.txt (Size: 140 bytes / Downloads: 231)
sample.xlsx (Size: 9.44 KB / Downloads: 231)
Screenshot.docx (Size: 98.73 KB / Downloads: 189)
But I need to populate without this option because, when I use this "data_only= True" it removes formulas from other columns.
Hence I tried without this option and also by giving "data_only= False" but nothing happens. No values are copied, this because the cell contains formula, hence the value in the cell is not compared with text.
I have given a screenshot, and as highlighted in cell "E2" we have formula but I need only the value "12" to be taken and go to the text file with name "12", copy value and paste it in cell "G".
12.txt (Size: 140 bytes / Downloads: 231)
sample.xlsx (Size: 9.44 KB / Downloads: 231)
Screenshot.docx (Size: 98.73 KB / Downloads: 189)