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

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	1,878	Dec-12-2022, 08:22 PM Last Post: jh67
	Exporting Stock Fundamental Data to a CSV file with yahoo_fin	DustinKlent	2	4,721	Aug-01-2022, 06:08 PM Last Post: paulyan
	How to format Excel column with comma?	dee	0	1,366	Jun-13-2022, 10:11 PM Last Post: dee
	Converting cells in excel to JSON format	desmondtay	4	1,750	May-23-2022, 10:31 AM Last Post: Larz60+
	Need Help writing data into Excel format	ajitnayak87	8	2,513	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	How to get datetime from numeric format field	klllmmm	3	2,004	Nov-06-2021, 03:26 PM Last Post: snippsat
	Set 'Time' format cell when writing data to excel and not 'custom'	limors	3	6,297	Mar-29-2021, 09:36 PM Last Post: Larz60+
	Exporting a huge dataFrame	stylingpat	5	15,602	Mar-23-2021, 12:13 AM Last Post: stylingpat
	exporting all lines	YazeedbnMohmmed	2	2,120	Feb-24-2021, 03:29 AM Last Post: YazeedbnMohmmed
	Python code for exporting table using Selenium	gj31980	4	2,999	Aug-04-2020, 01:29 AM Last Post: gj31980

Users browsing this thread: 2 Guest(s)

View a Printable Version

Exporting dataframes to excel without loosing datetime format

User Panel Messages

Announcements