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()