python 来改变我生活的方式之一：处理统计班级日报-优化行数据

今日运行脚本统计12-28的数据，发现数据都未产生。于是调试了一下代码，发现

CountValue = len(tmp_list) -147   这行代码的计数器不准确了。接着删除掉后面147的参数，能够正常运行。接着去运行12.24的数据，发现多处147条数据。

经过严密的分析，应该是获取列数的字段出现了异常。重新调整优化。再对学号的字段做个判断。然后遍历调用。接着完美的输出。

 

def liuliu(datatime):


    filename = u"E://203班.xlsx"

    workbook = load_workbook(filename)  # 找到需要xlsx文件的位置

    sheet = workbook.get_sheet_by_name(datatime)
    #获取sheet页的行数据
    rows = sheet.rows
    tmp_list = list(rows)
    CountValue = len(tmp_list)
    for id in range(3, CountValue):
        DayTime = tmp_list[id][0]
        xuehao = DayTime.value
        if xuehao is None:
            break
        else:
          # 当日时间
          DayTime = tmp_list[id][0]
          xuehao = DayTime.value
          #每日数据
          DayTime1 = tmp_list[id][1]
          xingming = DayTime1.value
          DayTime2 = tmp_list[id][2]
          DayTime3 = tmp_list[id][3]
          DayTime4 = tmp_list[id][4]
          DayTime5 = tmp_list[id][5]
          DayTime6 = tmp_list[id][6]
        # 点时间

          if DayTime2.value == None:
             print(xuehao,xingming)
          elif DayTime3.value == None:
             print(xuehao, xingming)
          elif DayTime4.value == None:
             print(xuehao, xingming)
          elif DayTime5.value == None:
            print(xuehao, xingming)
          elif DayTime6.value == None:
            print(xuehao, xingming)
          else :

            id+=1

if __name__ == '__main__':

    #多个时间调用

    datatime = '12.28'

    print(datatime)
    liuliu(datatime)