How to properly format rows and columns in excel data from parsed .txt blocks

Thread Rating:

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

Thread Modes

How to properly format rows and columns in excel data from parsed .txt blocks

Pedroski55
Giant Foot

Posts: 833

Threads: 131

Joined: Jul 2017

Reputation: 25

Dec-09-2022, 10:43 PM

Quote:How would I include it in the block pattern to add to the dictionary

Just add a entry to your dictionary: key = "ItemName", value = "Terminator"

Quote:and export being in a different format?

openpyxl has formatting options for text and cells just check that out.

I don't know much about pandas, but I don't think it does formatting!

Post a few lines of your text data and an example of the desired output, then things will be clearer.

Find

Messages In This Thread

How to properly format rows and columns in excel data from parsed .txt blocks - by jh67 - Dec-09-2022, 08:00 PM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by Pedroski55 - Dec-09-2022, 10:43 PM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by jh67 - Dec-10-2022, 06:38 PM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by deanhystad - Dec-10-2022, 08:51 PM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by jh67 - Dec-11-2022, 12:11 AM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by deanhystad - Dec-11-2022, 04:21 AM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by jh67 - Dec-12-2022, 01:47 PM

RE: How to properly format rows and columns in excel data from parsed .txt blocks - by jh67 - Dec-12-2022, 08:22 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	RSA Cipher with blocks	Paragoon2	0	497	Nov-26-2023, 04:35 PM Last Post: Paragoon2
	Export data from PDF as tabular format	zinho	5	709	Nov-11-2023, 08:23 AM Last Post: Pedroski55
	how do you style data frame that has empty rows.	gsaray101	0	538	Sep-08-2023, 05:20 PM Last Post: gsaray101
	Copy data from Excel and paste into Discord (Midjourney)	Joe_Wright	4	2,078	Jun-06-2023, 05:49 PM Last Post: rajeshgk
	Reading data from excel file –> process it >>then write to another excel output file	Jennifer_Jone	0	1,118	Mar-14-2023, 07:59 PM Last Post: Jennifer_Jone
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	4,546	Jan-29-2023, 03:59 PM Last Post: eyavuz21
	Comparing two columns with same value but different font format	doug2019	1	726	Jan-08-2023, 02:58 PM Last Post: Larz60+
	(Python) Pulling data from UA Google Analytics with more than 100k rows into csv.	Stockers	0	1,242	Dec-19-2022, 11:11 PM Last Post: Stockers
	Extracting Data into Columns using pdfplumber	arvin	17	5,601	Dec-17-2022, 11:59 AM Last Post: arvin
	Trying to Get Arduino sensor data over to excel using Python.	eh5713	1	1,727	Dec-01-2022, 01:52 PM Last Post: deanhystad

Users browsing this thread: 2 Guest(s)

View a Printable Version

How to properly format rows and columns in excel data from parsed .txt blocks

User Panel Messages

Announcements