Python Forum
To Copy text values to Excel using Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
To Copy text values to Excel using Python
#9
Sorry I can not help, because I do not understand your issue.
Maybe you could use my very first version:

#!/usr/bin/python3
import openpyxl as xls

#todo: read file 12.txt
tm    = [0]*6
tm[0] = 0.99999982e-01
tm[1] = 9.84491405e-08
tm[2] = 2.08444947e-16
tm[3] = 6.91223128e-24
tm[4] = 8.09480403e-31
tm[5] = 0.00000000e+00
print(tm)

#xls
wb = xls.load_workbook(filename="sample.xlsx")
ws = wb.active

ws["G2"] = tm[0]
ws["H2"] = tm[1]
ws["I2"] = tm[2]

wb.save("sample2.xlsx")
Reply


Messages In This Thread
RE: To Copy text values to Excel using Python - by heiner55 - Jun-07-2019, 03:40 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Why is the copy method name in python list copy and not `__copy__`? YouHoGeon 2 334 Apr-04-2024, 01:18 AM
Last Post: YouHoGeon
  Copy Paste excel files based on the first letters of the file name Viento 2 512 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,318 Nov-03-2023, 05:35 PM
Last Post: huzzug
  save values permanently in python (perhaps not in a text file)? flash77 8 1,323 Jul-07-2023, 05:44 PM
Last Post: flash77
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,204 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
Thumbs Up Need to compare the Excel file name with a directory text file. veeran1991 1 1,175 Dec-15-2022, 04:32 PM
Last Post: Larz60+
  is it possible to copy image from email and place into excel file? cubangt 3 1,325 Nov-30-2022, 05:11 PM
Last Post: snippsat
  Trying to use 2 values from excel in my script but getting error.. cubangt 3 1,726 May-11-2022, 07:12 AM
Last Post: normanwolf
  Want to remove the text from a particular column in excel shantanu97 2 2,193 Jul-05-2021, 05:42 PM
Last Post: eddywinch82
  Copy column from one existing excel file to another file mkujawsk 0 5,774 Apr-14-2021, 06:33 PM
Last Post: mkujawsk

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020