擅长:python、mysql、java
<p>由于要检查“Rule”和“Total”的值位于列索引<code>0</code>,因此可以直接打印0</p>
<pre><code>import xlrd
wb = xlrd.open_workbook('test.xls')
sheet = wb.sheet_by_index(0)
for row_num in range(sheet.nrows):
row_value = sheet.row_values(row_num)
if row_value[0].startswith('SET') :
print(row_value[0],'-(row,col): ',row_num,",0",sep='')
if row_value[0].startswith('Total') :
print(row_value[0],'-(row,col): ',row_num,",0",sep='')
>>
SET I-(row,col): 1,0
Total-(row,col): 5,0
SET II-(row,col): 7,0
Total-(row,col): 11,0
SET III-(row,col): 13,0
Total-(row,col): 17,0
</code></pre>