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
#14
Hi,

I am able to write without removing formulas using XLwings

here is the code:
import xlwings as xw
wb = xw.Book('C:/Users/Template v5.xlsx')
sht = wb.sheets['lity']

Now I need to loop this sheet to find text called "Talk" and paste 1,2,3,4,5,6 after six rows in the same column where "Talk" word is found.
Please let me know looping in xlwings
Reply


Messages In This Thread
RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-14-2019, 11:19 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Why is the copy method name in python list copy and not `__copy__`? YouHoGeon 2 329 Apr-04-2024, 01:18 AM
Last Post: YouHoGeon
  Copy Paste excel files based on the first letters of the file name Viento 2 504 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,313 Nov-03-2023, 05:35 PM
Last Post: huzzug
  save values permanently in python (perhaps not in a text file)? flash77 8 1,319 Jul-07-2023, 05:44 PM
Last Post: flash77
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,190 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,172 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,321 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,723 May-11-2022, 07:12 AM
Last Post: normanwolf
  Want to remove the text from a particular column in excel shantanu97 2 2,189 Jul-05-2021, 05:42 PM
Last Post: eddywinch82
  Copy column from one existing excel file to another file mkujawsk 0 5,758 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