Set 'Time' format cell when writing data to excel and not 'custom'

Thread Rating:

Thread Modes

Set 'Time' format cell when writing data to excel and not 'custom'

Larz60+
aetate et sapientia
Super Moderators

Posts: 11,877

Threads: 474

Joined: Sep 2016

Reputation: 452

Mar-29-2021, 10:30 AM

format7 = workbook.add_format({'num_format': 'mmm d yyyy hh:mm AM/PM'})
worksheet.write('A7', number, format7)       # Feb 28 2013 12:00 PM

Messages In This Thread

RE: Set 'Time' format cell when writing data to excel and not 'custom' - by Larz60+ - Mar-29-2021, 10:30 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Help with writing monitored data to mysql upon change of one particular variable	donottrackmymetadata	3	338	Apr-18-2024, 09:55 PM Last Post: deanhystad
	Python date format changes to date & time	1418	4	673	Jan-20-2024, 04:45 AM Last Post: 1418
	Export data from PDF as tabular format	zinho	5	750	Nov-11-2023, 08:23 AM Last Post: Pedroski55
	Copy data from Excel and paste into Discord (Midjourney)	Joe_Wright	4	2,133	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,143	Mar-14-2023, 07:59 PM Last Post: Jennifer_Jone
	Set string in custom format	korenron	4	1,135	Jan-16-2023, 07:46 PM Last Post: mutantGOD
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	1,950	Dec-12-2022, 08:22 PM Last Post: jh67
	Issue in writing sql data into csv for decimal value to scientific notation	mg24	8	3,127	Dec-06-2022, 11:09 AM Last Post: mg24
	Trying to Get Arduino sensor data over to excel using Python.	eh5713	1	1,759	Dec-01-2022, 01:52 PM Last Post: deanhystad
	Appending a row of data in an MS Excel file	azizrasul	3	1,214	Nov-06-2022, 05:17 PM Last Post: azizrasul

Users browsing this thread: 2 Guest(s)