擅长:python、mysql、java
<p>尝试使用xlrd模块。比如:</p>
<pre><code>import xlrd
wb = xlrd.open_workbook(path)
sheet = wb.sheet_by_index(index)
column_list = range(0, sheet.ncols)
val_name = [sheet.cell_value(rowx=0, colx=i) for i in column_list]
channel = val_name.pop(0)
condition = val_name.pop(0)
print(channel, condition, "Value *", "Status")
lines = []
for r in range(1, sheet.nrows):
row = [sheet.cell_value(rowx=r, colx=i) for i in column_list]
channel = row[0]
condition = row[1]
values = row[2:]
lines = zip( [channel]*len(values),
[condition]*len(values),
val_name,
values)
for l in lines:
print(l)
</code></pre>