通过Python把Excel文件的数据生成sql脚本

import xlrd


def excel_import(inputFile, outputFilePath):
    """
    Excel文件导入处理
    :param inputFile: 导入的文件（Excel）
    :param outputFilePath: 输出的文件路径
    :return:
    """

    # 输出的文件
    outputFile = open(outputFilePath + "output_file.sql", "w+", encoding="utf-8")
    # 数据开始行（从1开始）
    start_row = 2

    excel = xlrd.open_workbook(inputFile)
    sheet = excel.sheet_by_index(0)
    for i in range(start_row - 1, sheet.nrows):
        rowsData = {}
        for j in range(len(sheet.row_values(i))):
            rowsData.__setitem__(j, sheet.row_values(i)[j])；

        print("第{}行: {}".format(i, rowsData))
        sql = genSQL(rowsData)
        outputFile.write(sql)

    outputFile.close()
    print("执行完毕。。。")


def genSQL(rowsData) -> str:
    sql = "INSERT INTO tb_name (`t_code`, `t_name`) VALUES ('{0[0]}', '{0[1]}');\n" \
        .format(rowsData)
    return sql


if __name__ == "__main__":
    inputFile = "D:\study\python3\work-script\input_files\import.xlsx"
    inputFilePath = "D:\study\python3\work-script\input_files\\"
    outputFilePath = "D:\study\python3\work-script\output_files\\"
    excel_import(inputFile, outputFilePath)