gistfile1.py

def generate_script_from_xls(xls_name, table, cols, types):
    cur.execute("delete from {}".format(table))

    xl_book = xlrd.open_workbook(unicode(xls_name, "utf-8"), formatting_info=True)
    sheet = xl_book.sheet_by_index(0)

    dot_index = len(xls_name) - xls_name[::-1].index('.') - 1
    script_name = xls_name[:dot_index] + ".txt"
    
    comma_separated_cols = ", ".join(cols)

    for rownum in xrange(1, sheet.nrows):
        row = []
        for colnum in xrange(sheet.ncols):
            cell = sheet.cell(rownum, colnum)
            if cell.value:
                if types[colnum] == "float":
                    cell_value = cell.value
                elif types[colnum] == "integer":
                    cell_value = int(cell.value)
                else:
                    cell_value = u"{}".format(get_excel_visible_repr(cell, xl_book))
                    cell_value = u"'{}'".format(cell_value.replace("'", "\\'"))

            else:
                cell_value = 'NULL'
            cell_value = unicode(cell_value).encode("utf-8")
            row.append(cell_value)
        comma_separated_data = ", ".join(row)
        sql =\
        "INSERT INTO {} ({}) VALUES ({});\n".format(
            table,
            comma_separated_cols,
            comma_separated_data)

        try: 
            cur.execute(sql)
        except Exception as e:
            print(e)
            print(sql)
            print(rownum)
            
    con.commit