Python Forum
openpyxl Pasting data to different cells
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
openpyxl Pasting data to different cells
#2
You could put a shift amount into this line
ws2.cell(row = i+12, column = j+1).value = c.value
to save as something else just change the save name
wb2.save('C:/newfile.xlsx')
Reply


Messages In This Thread
RE: openpyxl Pasting data to different cells - by Yoriz - Jun-15-2020, 08:14 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  openpyxl convert data to float jacklee26 13 6,194 Nov-19-2022, 11:59 AM
Last Post: deanhystad
  Why is copying and pasting a block now broken? WagmoreBarkless 2 1,441 May-05-2022, 05:01 AM
Last Post: WagmoreBarkless
  Why is copying and pasting a block now broken? WagmoreBarkless 1 1,264 May-04-2022, 11:40 PM
Last Post: Larz60+
  Openpyxl-change value of cells in column based on value that currently occupies cells phillipaj1391 5 9,951 Mar-30-2022, 11:05 PM
Last Post: Pedroski55
  How can I iterate through all cells in a column (with merge cells) with openpyxl? aquerci 1 7,561 Feb-11-2021, 09:31 PM
Last Post: nilamo
  Can you help me to merge the cells with OpenPyXL? TurboC 1 2,223 Feb-01-2021, 12:54 AM
Last Post: Larz60+
  Formatting Data/Time with Pyodbc and openpyxl bearcats6001 0 2,311 Aug-17-2020, 03:44 PM
Last Post: bearcats6001
  [openpyxl] Increment cells being pasted into Template Kristenl2784 4 3,616 Jul-16-2020, 10:00 PM
Last Post: Kristenl2784
  Copy certain cells into new workbook certain cells Kristenl2784 4 2,520 Jul-14-2020, 07:59 PM
Last Post: Kristenl2784
  copy/pasting in excel WHILE keep file format zarize 0 1,993 Jun-23-2020, 03:51 PM
Last Post: zarize

Forum Jump:

User Panel Messages

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