To Copy text values to Excel using Python

[ksasi2k3]

Let me explain in step by step process.

1.I have an excel file with formulas included in columns.
2.I want to paste the values from txt file to excel file.
3.I have a column name "Text file" in the excel sheet, this columns is derived by using formulas.
4. Need to check the number in that column, example here it is "12", so check for the text file with name "12".
5. Copy the last value from text file "12" and paste it in column "Pastevalues" in excel sheet.
6. So input is from text file,reference and output is the same excel.
  sample.xlsx (Size: 9.44 KB / Downloads: 240)
  sample.xlsx (Size: 9.44 KB / Downloads: 240)