python excelを読み出して/xlrdモジュールを巡回

2324 ワード

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import csv
import xlrd
import xlwt

def handler_excel(filename=r'/Users/zongyang.yu/horizon/ops_platform/assets/upload/1.xlsl'):

    #     
    workbook = xlrd.open_workbook(filename)
    index = workbook.sheet_names()[0]
    sheet2 = workbook.sheet_by_name(index)
   
   #  
    nrows = sheet2.nrows
    for i in range(nrows):
        print(sheet2.row_values(i))

if __name__ == '__main__':
    handler_excel()