랜덤 뽑기 & excel 연동

#-*- coding: utf-8 -*-
 
import xlrd, xlwt, random2
 
# excel 파일 값 받아오기 및 랜덤 연산
def openExcel(path):
    excel = []
    wb = xlrd.open_workbook(path)
    ws = wb.sheet_by_index(0)
    num_nrows = ws.nrows
 
    for row_num in xrange(ws.nrows):
        row = ws.row(row_num)
        cols = []
        for cell in row:
            if cell.ctype == 1:
                cols.append(cell.value)
        excel.append(','.join(cols))
 
    random2.shuffle(excel)
 
    return excel
 
# excel 파일 출력
def createExcel(excel):
 
    wb = xlwt.Workbook(encoding='utf-8')
    wb.default_style.font.height = 20*11
 
    ws = wb.add_sheet('sheet1')
 
    for i in xrange(7):
        print i
        ws.write(i,0,excel[i])
 
    wb.save('result.xls')
 
 
if __name__=='__main__':
    path = 'random.xlsx'
    excel=openExcel(path)
    createExcel(excel)