Convert Excel to CSV and retain formatting

Thread Rating:

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

Thread Modes

Convert Excel to CSV and retain formatting

slider09
Unladen Swallow

Posts: 3

Threads: 1

Joined: Jul 2020

Reputation: 0

Jul-24-2020, 12:31 AM (This post was last modified: Jul-24-2020, 12:31 AM by slider09.)

(Jul-23-2020, 10:59 PM)Gribouillis Wrote: You say you wrote the Python script, so you are the only one to blame for the wrong output. How did you code the output of the Timestamp field?

I am not blaming anyone else.

What I was asking is, is there a way when writing out the csv to retain the formatting from Excel.

Find

Messages In This Thread

Convert Excel to CSV and retain formatting - by slider09 - Jul-23-2020, 08:25 PM

RE: Convert Excel to CSV and retain formatting - by Gribouillis - Jul-23-2020, 10:59 PM

RE: Convert Excel to CSV and retain formatting - by slider09 - Jul-24-2020, 12:31 AM

RE: Convert Excel to CSV and retain formatting - by Gribouillis - Jul-24-2020, 06:12 AM

RE: Convert Excel to CSV and retain formatting - by slider09 - Jul-24-2020, 10:02 AM

RE: Convert Excel to CSV and retain formatting - by Gribouillis - Jul-24-2020, 10:36 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Convert Excel file into csv with Pipe symbol..	mg24	4	1,370	Oct-18-2022, 02:59 PM Last Post: Larz60+
	How do I read in a Formula in Excel and convert it to do the computation in Python?	JaneTan	2	2,694	Jul-07-2021, 02:06 PM Last Post: Marbelous
	Filter Excel and Convert an Excel File	giddyhead	0	2,239	May-13-2021, 06:31 PM Last Post: giddyhead
	Importing text file into excel spreadsheet with formatting	david_dsmn	1	3,656	Apr-05-2021, 10:21 PM Last Post: david_dsmn
	Matplotlib: How do I convert Dates from Excel to use in Matplotlib	JaneTan	1	3,276	Mar-11-2021, 10:52 AM Last Post: buran
	Openpyxl: Excel formula & condition formatting removed	JaneTan	0	3,690	Sep-25-2020, 07:02 AM Last Post: JaneTan
	how to retain time format in df.to_csv	Mekala	2	3,229	Aug-07-2020, 07:04 AM Last Post: buran
	Convert Excel file to Text file	marvel_plato	6	19,872	Jul-17-2020, 01:45 PM Last Post: marvel_plato
	convert old excel files(xls) to xlsm	zarize	1	3,413	Jul-14-2020, 02:12 PM Last Post: DeaD_EyE
	Convert Excel to complex list	and2handles	1	2,074	Jun-23-2020, 01:51 PM Last Post: DPaul

Users browsing this thread: 2 Guest(s)

View a Printable Version

Convert Excel to CSV and retain formatting

User Panel Messages

Announcements