excel数据格式化输出

#!coding:utf-8
# Author:pymingming

import xlrd #导入excel库


class Person():
    def __init__(self, name, number, _class):
        self.name = name
        self.number = number
        self._class = _class
    def person_message(self):
        info = '''\033[31;1m
----------%s-----------\033[0m
        Name:%s
        Number:%s
        Class:%s'''%( self.name.title(), self.name.title(), self.number, self._class)
        print(info)

def read(file, sheet_index=0): #sheet_index=0 读取sheet1，等于1时读取sheet2
    workbook = xlrd.open_workbook(file) #将数据存于wookbook
    sheet = workbook.sheet_by_index(sheet_index)#sheet的一个索引
    print("工作表名称:", sheet.name, "行数:", sheet.nrows, "列数:", sheet.ncols )

    data = []
    for i in range(0, sheet.nrows): #从第几行读取，按行读取
        data.append(sheet.row_values(i))#将读取的数据追加到列表
    return data #返回列表

if __name__ == '__main__': #文件作为脚本直接执行时才会被执行，而import到其他脚本中是不会被执行
    message = (read(r'C:\Users\zhuxueming\Desktop\生物所.xls')) #输出def read（）信息

for L in message:
    every_message = Person(L[0][0]+'**', str(L[1])[:3]+'*'+str(L[1])[4:7], L[2][:2]+'*'+L[2][3:]) #定义类中的格式化数据
    every_message.person_message() #输出类中的def函数值

----------姜**-----------
        Name:姜**
        Number:215*613
        Class:C-*02

----------张**-----------
        Name:张**
        Number:215*613
        Class:C-*16

----------吴**-----------
        Name:吴**
        Number:115*605
        Class:农科*

----------徐**-----------
        Name:徐**
        Number:215*614
        Class:C-*16

----------陈**-----------
        Name:陈**
        Number:215*613
        Class:C-*14

----------刘**-----------
        Name:刘**
        Number:215*611
        Class:C-*04

----------王**-----------
        Name:王**
        Number:115*605
        Class:C-*02

----------张**-----------
        Name:张**
        Number:215*612
        Class:C-*02

----------傅**-----------
        Name:傅**
        Number:115*605
        Class:C-*04

----------吕**-----------
        Name:吕**
        Number:215*611
        Class:C-*04

----------张**-----------
        Name:张**
        Number:215*614
        Class:C-*16