python xls、xlsx转csv

import csv
import xlrd
filename1 = "jishu1.xlsx"
filename2 = "jishu2.xls"


def read_excel(fn):
    wb = xlrd.open_workbook(fn)# 打开Excel文件
    sheet = wb.sheets()[0]  # 获取第一个工作表
    data_list = []  #创建空list
    for a in range(sheet.nrows):  #循环读取表格内容（每次读取一行数据）
        cells = sheet.row_values(a)  # 每行数据赋值给cells
        data = cells[0]#因为表内可能存在多列数据，0代表第一列数据，1代表第二列，以此类推
        data_list.append(data) #把每次循环读取的数据插入到list
    return data_list

# 直接写入是“w”，追加写是“a+”
if __name__ == '__main__':
    data_list = read_excel(filename1)
    with open('jishu.csv', 'w', newline='', encoding='utf-8-sig') as f1:
        row_title = ['id', "term", 'type']  # 写入表头
        f1_writer = csv.writer(f1)
        f1_writer.writerow(row_title)
        # sentence_list = [row[0] for row in f_reader]  # 读取csv中第一列的所有数据生成列表——1273个字符串 句子 
        for j,data in enumerate(data_list):
            _id = j+1
            term = data
            type = "tech"
            f1_writer.writerow([_id, term, type])