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

Gribouillis

Super Moderators

Posts: 4,498

Threads: 69

Joined: Jan 2018

Reputation: 330

Jul-24-2020, 10:36 AM (This post was last modified: Jul-24-2020, 10:36 AM by Gribouillis.)

The module xlrd.xldate apparently contains various functions to convert to and from excel dates. You could use one of them to convert the timestamps to a datetime object. Also the class Cell contains a ctype member which helps you determine if the cell contains a date or not. This could be used by your program to know whether the cell's content needs conversion.

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,336	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,662	Jul-07-2021, 02:06 PM Last Post: Marbelous
	Filter Excel and Convert an Excel File	giddyhead	0	2,228	May-13-2021, 06:31 PM Last Post: giddyhead
	Importing text file into excel spreadsheet with formatting	david_dsmn	1	3,633	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,251	Mar-11-2021, 10:52 AM Last Post: buran
	Openpyxl: Excel formula & condition formatting removed	JaneTan	0	3,666	Sep-25-2020, 07:02 AM Last Post: JaneTan
	how to retain time format in df.to_csv	Mekala	2	3,183	Aug-07-2020, 07:04 AM Last Post: buran
	Convert Excel file to Text file	marvel_plato	6	19,745	Jul-17-2020, 01:45 PM Last Post: marvel_plato
	convert old excel files(xls) to xlsm	zarize	1	3,390	Jul-14-2020, 02:12 PM Last Post: DeaD_EyE
	Convert Excel to complex list	and2handles	1	2,059	Jun-23-2020, 01:51 PM Last Post: DPaul

Users browsing this thread: 3 Guest(s)

View a Printable Version

Convert Excel to CSV and retain formatting

User Panel Messages

Announcements