[PYTHON]XLRD Reading 2 ways of Excel date type

There is a excle table to do some filtering and then write to the database, but the date type of the cell is taken out is a number, and then query the next solution.

Basic code structure

data = Xlrd.open_workbook (excel_path) Table = data.sheet_by_index (0) lines = Table.nrowscols = Table.ncolsprint U ' the Total line was%s, cols is%s '% (lines, cols)

To read a cell:

Table.cell (x, y). Value

X: Line

Y: Column

Row, column is starting from 0

* Time type conversion, convert Excel time to Python time (two ways)

Excel a cell 2014/7/8

Xlrd.xldate_as_tuple (Table.cell (2,2). Value, 0)   #转化为元组形式 (7, 8, 0, 0, 0) xlrd.xldate.xldate_as_datetime ( Table.cell (2,2). Value, 1)   #直接转化为datetime对象datetime. DateTime (2018, 7, 9, 0, 0) Table.cell (2,2). Value   # No conversions 41828.0

Source view:

# @param xldate the Excel number# @param datemode 0:1900-based, 1:1904-based.xldate_as_tuple (Xldate, Datemode)  

Entering a cell of a date type returns a tuple of time structure that can be composed of a time type based on that tuple.

Datemode has 2 options basically, we're going to use a 1900-based timestamp.

# # Convert An Excel date/time number into a datetime.datetime object.## @param xldate the Excel number# @param datemode 0 : 1900-based, 1:1904-based.## @return a datetime.datetime () object. #def xldate_as_datetime (xldate, Datemode)

The input parameter is the same as above, but the return value is a datetime type, and you do not need to convert the

Of course, these two functions have corresponding inverse function, the Python type into the corresponding excle time type.

This article is derived from "Orangleliu notebook " Blog, be sure to keep this source http://blog.csdn.net/orangleliu/article/details/38476881