To Copy text values to Excel using Python

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

To Copy text values to Excel using Python

ksasi2k3
Silly Frenchman

Posts: 21

Threads: 6

Joined: Jul 2018

Reputation: 0

Jun-03-2019, 04:07 PM

Thank you heiner55 for your reply.
I have attached example files.

I have a text file 12.txt as attached, I want to insert the values in this file to attached excel and in column "C" named as Finaltotal. This column has formulas and need to paste values from text file to this column.

Secondly: In excel I have column name "Textfile" this has value 12 and need to find text file with name 12, for simplicity purpose I have named the text file as "12". Need to find the value from this "Textfile" column and paste the values from 12 text to corresponding "Pastevalues" column.

Attached Files

12.txt (Size: 140 bytes / Downloads: 395)
.xlsx

sample.xlsx (Size: 9.42 KB / Downloads: 315)

Find

Messages In This Thread

To Copy text values to Excel using Python - by ksasi2k3 - May-31-2019, 04:44 PM

RE: To Copy text values to Excel using Python - by buran - May-31-2019, 04:54 PM

RE: To Copy text values to Excel using Python - by heiner55 - Jun-01-2019, 04:49 AM

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-03-2019, 04:07 PM

RE: To Copy text values to Excel using Python - by heiner55 - Jun-05-2019, 01:51 PM

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-06-2019, 11:16 AM

RE: To Copy text values to Excel using Python - by heiner55 - Jun-06-2019, 01:06 PM

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-07-2019, 03:29 PM

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

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-07-2019, 03:45 PM

RE: To Copy text values to Excel using Python - by heiner55 - Jun-07-2019, 04:15 PM

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-11-2019, 07:33 AM

RE: To Copy text values to Excel using Python - by buran - Jun-11-2019, 09:15 AM

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

RE: To Copy text values to Excel using Python - by heiner55 - Jun-25-2019, 04:31 PM

RE: To Copy text values to Excel using Python - by ksasi2k3 - Jun-26-2019, 01:23 PM

RE: To Copy text values to Excel using Python - by ashutoshdeodhar - Dec-26-2019, 11:59 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	328	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
	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,756	Apr-14-2021, 06:33 PM Last Post: mkujawsk

Users browsing this thread: 1 Guest(s)

View a Printable Version

To Copy text values to Excel using Python

User Panel Messages

Announcements