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_