Python：Pandas读取excel

1.逐元素读取

1. 遍历每个sheet
2. 读取每个sheet的表格元素
3. 时间转字符串

代码：

# encoding=utf-8

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.dates as mdate


def process_file_1(file_name, sheet_names):
    # 读取文件
    sheets = pd.read_excel(file_name, sheet_name=sheet_names)
    for i in range(len(sheets)):
        # 取一个sheet
        sheet = sheets[sheet_names[i]].values
        # 逐行逐列读表
        for j in range(sheet.shape[0]):
            for k in range(sheet.shape[1]):
                # 一个元素
                item = sheet[j][k]
                # 如果是时间则转化为字符串
                if isinstance(item, pd._libs.tslibs.timestamps.Timestamp):
                    item = item.strftime('%Y/%m/%d-%H:%M:%S:%f')
                print item


if __name__ == '__main__':
    sheet_names = ['5', '8', '9', '10', '11', '12', '13', '14', '15', '17', '18', '19', '24', '36']
    process_file_1('7.16.xlsx', sheet_names)

文档(7.16.xlsx)

2.逐行读取

import pandas as pd 
 
def process_file_1(file_name):
    sheet = pd.read_excel(file_name).values
    for i in range(sheet.shape[0]):
            print(sheet[i])
 
 
if __name__ == '__main__':
    process_file_1('1.xlsx')

---