xlsx 转csv 文件

 xlrd应用：

# -*- coding: utf-8 -*-
import xlrd
def open_excel(file = 'file.xls'):#打开要解析的Excel文件
    try:
        data = xlrd.open_workbook(file)
        return data
    except Exception as e:
        print(e)

def excel_by_index(file = 'file.xls', colindex = 0, by_index = 0):#按表的索引读取
    data = open_excel(file)#打开excel文件
    tab = data.sheets()[by_index]#选择excel里面的Sheet
    nrows = tab.nrows#行数
    ncols = tab.ncols#列数
    colName = tab.row_values(colindex)#第0行的值
    list = []#创建一个空列表
    for x in range(0, nrows):
        row = tab.row_values(x)
        if row:
            app = {}#创建空字典
            for y in range(0, ncols):
                app [ colName[y] ] = row[y]
            list.append(app)
    return list

def read_excel(file = 'file.xls', by_index = 0):#直接读取excel表中的各个值
    data = open_excel(file)#打开excel文件
    tab = data.sheets()[by_index]#选择excel里面的Sheet
    nrows = tab.nrows#行数
    ncols = tab.ncols#列数
    for x in range(0, nrows):
         for y in range(0, ncols):
             value = tab.cell(x,y).value
             print(tab.cell(x, y).value)
def main():
    # print('input the path of your file:')
    # a = open_excel(r'D:\smt_ioe\untitled\analysis_excel\my.xls')
    # print(a)
    b = excel_by_index(r'D:\smt_ioe\untitled\analysis_excel\my.xls', 0, 2)
    m = []
    for i in range(b.__len__()):
        c = b[i]
        # a = c['name']
    for x in c:
        if x == 'date':
            print(x)
    print('meng')
    read_excel(r'D:\smt_ioe\untitled\analysis_excel\my.xls',2)

if __name__ == '__main__':
    main()

 

 

 xlrd 转csv

# -*- coding: utf-8 -*-
"""
__title__ = 'xls2csv.py'
__author__ = 'yangyang'
__mtime__ = '2018.03.16'
"""
import  xlrd
import  csv
def xls2csv(filename):
    xlsFileData = xlrd.open_workbook(filename)  #获取xlsx 的内容
    table = xlsFileData.sheet_by_index(0)        #选择xlsx 的第一个sheet
    with open('1a.csv','w',encoding='gb18030') as fw:
        csvwrite = csv.writer(fw,dialect=("excel"))
        for line in range(table.nrows):
            line_value = table.row_values(line)  #获取每一行的值
            csvwrite.writerow(line_value)       # 把每一行的值 写到csv文件里

if __name__ == '__main__':
    xls2csv('./02.xlsx')