Copy certain cells into new workbook certain cells

Thread Rating:

Thread Modes

Copy certain cells into new workbook certain cells

Yoriz

Posts: 2,168

Threads: 35

Joined: Sep 2016

Reputation: 192

Jul-14-2020, 04:18 PM

you also need to call the value method on the cell you are reading on the right to put it into the cell on the left.
example

ws2['A2']=ws['A1'].value

Find

Messages In This Thread

RE: Copy certain cells into new workbook certain cells - by Yoriz - Jul-14-2020, 04:18 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	module 'openpyxl.workbook' has no attribute 'active'	lsaavedra21	5	1,968	Oct-30-2024, 06:26 PM Last Post: lsaavedra21
	Why is the copy method name in python list copy and not `__copy__`?	YouHoGeon	2	1,459	Apr-04-2024, 01:18 AM Last Post: YouHoGeon
	How to copy work sheet data one workbook to other?	sayyedkamran	2	1,654	Nov-03-2023, 09:10 AM Last Post: Larz60+
	xlwings error when reading a workbook	Mishal0488	1	2,511	Aug-01-2023, 02:05 AM Last Post: deanhystad
	getting unexpected indent errors trying to move cells up	jensengt	4	1,995	Jun-28-2023, 12:05 PM Last Post: deanhystad
	Help in opening and editing an excel workbook from a web-browser	test	4	2,697	Aug-10-2022, 02:31 PM Last Post: test
	Converting cells in excel to JSON format	desmondtay	4	3,066	May-23-2022, 10:31 AM Last Post: Larz60+
	Openpyxl-change value of cells in column based on value that currently occupies cells	phillipaj1391	5	17,149	Mar-30-2022, 11:05 PM Last Post: Pedroski55
	gspread - applying ValueRenderOption to a range of cells	dwassner	0	2,418	Jan-12-2022, 03:05 PM Last Post: dwassner
	Python “Formula” Package: How do I parse Excel formula with a range of cells?	JaneTan	1	3,732	Jul-12-2021, 11:09 AM Last Post: jefsummers

Users browsing this thread: 1 Guest(s)