python3 处理csv，xlsx

1，处理csv

import  csv
def import_csv(csvfilename):
    csvf = open(csvfilename, encoding="utf-8")
    csvr = csv.reader(csvf)
    ii = 0
    for row in csvr:
        ii = ii + 1
        if ii == 1:
            continue
        print(row)#row是每一行数据 除去第一行  具体(row[0],row[1].....)
import_csv("C:\\xxx\\xxx\\xx\\xxx.csv")

2,处理xlsx

import xlrd
def import_xlsx(xlsxfilename):
    xlsx_path = xlsxfilename
    workbook = xlrd.open_workbook(xlsx_path)
    worksheet = workbook.sheet_by_index(0)
    nrows = worksheet.nrows  # 获取该表总行数
    for i in range(nrows):  # 循环打印每一行
        if i > 0:
            row = worksheet.row_values(i)
            print(row) #row是每一行数据 除去第一行  具体(row[0],row[1].....)
import_xlsx("C:\\xxx\\xxx\\xx\\xxx.xlsx")