xls、csv文件的操作

遍历xls的sheet.py

import pandas as pd, xlrd

path = 'some_one.xls'


def openxls(path):
    b = xlrd.open_workbook(path)
    count = len(b.sheets())
    print(count)
    for sheet in b.sheets():

        try:
            f = pd.read_excel(path, header=None, sheet_name=sheet.name)
            rows, cols = f.shape
            print(rows, cols)
            print(f.head())
            for i in range(0, cols):
                x = f[i]
                print(x)
        except:
            pass


openxls(path)