Exporting dataframes to excel without loosing datetime format

Thread Rating:

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

Thread Modes

Exporting dataframes to excel without loosing datetime format

Rafa
Unladen Swallow

Posts: 2

Threads: 2

Joined: Oct 2021

Reputation: 0

Oct-27-2021, 10:42 AM (This post was last modified: Oct-27-2021, 12:44 PM by Rafa.)

I want to export to excel a DataFrame in which the index is formated in quarters (2019-Q1,2019-Q2...). However, when I export it to excel (through ExcelWriter), it looses the formatation and becomes a regular date. How can I mantain the quarter`s format when exporting it to excel?

Find

Messages In This Thread

Exporting dataframes to excel without loosing datetime format - by Rafa - Oct-27-2021, 10:42 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[SOLVED] [datetime.strptime] ValueError: time data 'foo' does not match format 'bar'	Winfried	1	1,256	Jan-02-2025, 02:09 AM Last Post: lyly19
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	3,850	Dec-12-2022, 08:22 PM Last Post: jh67
	Exporting Stock Fundamental Data to a CSV file with yahoo_fin	DustinKlent	2	6,866	Aug-01-2022, 06:08 PM Last Post: paulyan
	How to format Excel column with comma?	dee	0	2,000	Jun-13-2022, 10:11 PM Last Post: dee
	Converting cells in excel to JSON format	desmondtay	4	2,880	May-23-2022, 10:31 AM Last Post: Larz60+
	Need Help writing data into Excel format	ajitnayak87	8	4,062	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	How to get datetime from numeric format field	klllmmm	3	2,748	Nov-06-2021, 03:26 PM Last Post: snippsat
	Set 'Time' format cell when writing data to excel and not 'custom'	limors	3	8,708	Mar-29-2021, 09:36 PM Last Post: Larz60+
	Exporting a huge dataFrame	stylingpat	5	22,517	Mar-23-2021, 12:13 AM Last Post: stylingpat
	exporting all lines	YazeedbnMohmmed	2	2,846	Feb-24-2021, 03:29 AM Last Post: YazeedbnMohmmed

Users browsing this thread: 1 Guest(s)

View a Printable Version

Exporting dataframes to excel without loosing datetime format

User Panel Messages

Announcements