|
以读取Excel内容和创建变量,变量赋值。返回变量,接收变量为例
具体代码如下所示:
# -*- coding:UTF-8 -*- import xlrd # 获取POI以及对应的编码 def getPOIIDs(excelPath): dataExcel = xlrd.open_workbook(excelPath) # 打开Excel文件 table01 = dataExcel.sheet_by_index(0) # 获取Excel中的sheet表内容 dicPOINames = {} # 创建字典 dicPOICodes = {} # 创建字典 for i in range(1, table01.nrows): # 获取Excel的值并存入dic字典中,对字典进行赋值 dicPOINames[table01.cell_value(i, 0)] = table01.cell_value(i, 3) dicPOICodes[table01.cell_value(i, 7)] = table01.cell_value(i, 8) return dicPOINames, dicPOICodes # 返回变量 excelPath = r"C:\Users\Administrator\Desktop\WorkData\0603SJB\targetID.xls" dicPOINames = {} dicPOICodes = {} try: (dicPOINames, dicPOICodes) = getPOIIDs(excelPath) # 接收多个变量 except Exception as e: print "读取Excel数据有问题。" print e.message
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-9-19 12:43
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社