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 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,206 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,176 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,727 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,775 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