python中读取excel文件_在Python中读取Excel文件

这是一种方法：

from xlrd import open_workbook

class Arm(object):

def __init__(self, id, dsp_name, dsp_code, hub_code, pin_code, pptl):

self.id = id

self.dsp_name = dsp_name

self.dsp_code = dsp_code

self.hub_code = hub_code

self.pin_code = pin_code

self.pptl = pptl

def __str__(self):

return("Arm object:

"

" Arm_id = {0}

"

" DSPName = {1}

"

" DSPCode = {2}

"

" HubCode = {3}

"

" PinCode = {4}

"

" PPTL = {5}"

.format(self.id, self.dsp_name, self.dsp_code,

self.hub_code, self.pin_code, self.pptl))

wb = open_workbook('sample.xls')

for sheet in wb.sheets():

number_of_rows = sheet.nrows

number_of_columns = sheet.ncols

items = []

rows = []

for row in range(1, number_of_rows):

values = []

for col in range(number_of_columns):

value = (sheet.cell(row,col).value)

try:

value = str(int(value))

except ValueError:

pass

finally:

values.append(value)

item = Arm(*values)

items.append(item)

for item in items:

print item

print("Accessing one single value (eg. DSPName): {0}".format(item.dsp_name))

print

您不必使用自定义类,您可以简单地使用dict().但是,如果您使用类,则可以通过点符号访问所有值,如上所示.

以下是上述脚本的输出：

Arm object:

Arm_id = 1

DSPName = JaVAS

DSPCode = 1

HubCode = AGR

PinCode = 282001

PPTL = 1

Accessing one single value (eg. DSPName): JaVAS

Arm object:

Arm_id = 2

DSPName = JaVAS

DSPCode = 1

HubCode = AGR

PinCode = 282002

PPTL = 3

Accessing one single value (eg. DSPName): JaVAS

Arm object:

Arm_id = 3

DSPName = JaVAS

DSPCode = 1

HubCode = AGR

PinCode = 282003

PPTL = 5

Accessing one single value (eg. DSPName): JaVAS