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,867	Dec-12-2022, 08:22 PM Last Post: jh67
	Exporting Stock Fundamental Data to a CSV file with yahoo_fin	DustinKlent	2	4,709	Aug-01-2022, 06:08 PM Last Post: paulyan
	How to format Excel column with comma?	dee	0	1,358	Jun-13-2022, 10:11 PM Last Post: dee
	Converting cells in excel to JSON format	desmondtay	4	1,724	May-23-2022, 10:31 AM Last Post: Larz60+
	Need Help writing data into Excel format	ajitnayak87	8	2,503	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	How to get datetime from numeric format field	klllmmm	3	1,998	Nov-06-2021, 03:26 PM Last Post: snippsat
	Set 'Time' format cell when writing data to excel and not 'custom'	limors	3	6,275	Mar-29-2021, 09:36 PM Last Post: Larz60+
	Exporting a huge dataFrame	stylingpat	5	15,542	Mar-23-2021, 12:13 AM Last Post: stylingpat
	exporting all lines	YazeedbnMohmmed	2	2,106	Feb-24-2021, 03:29 AM Last Post: YazeedbnMohmmed
	Python code for exporting table using Selenium	gj31980	4	2,990	Aug-04-2020, 01:29 AM Last Post: gj31980

Users browsing this thread: 1 Guest(s)

View a Printable Version

Exporting dataframes to excel without loosing datetime format

User Panel Messages

Announcements