python读取excel并制表输出

#!/usr/bin/python
#coding=UTF-8

import xlrd
from prettytable import PrettyTable

def sheetRowToSlice(sheet, r, colnum):
        res = []
        for c in range(colnum):
                cell_value = sheet.cell(r, c).value
                if isinstance(cell_value, str):
                        cell_value = ‘\n‘.join(cell_value.split(‘ ‘))
                res.append(sheet.cell(r, c).value)
        return res

def appendSliceToTable(table, res):
        table.append(res)
        return

data = xlrd.open_workbook("test.xlsx")

sheet = data.sheets()[0]

nrows_num = sheet.nrows

ncols_num = sheet.ncols

for r in range(nrows_num):
        cell_value = str(sheet.cell(r, 0).value.encode("utf8"))
        if "Name" in cell_value:
                common_row_num = r
        if "合计" in cell_value:
                end_row_num = r

common_row = sheetRowToSlice(sheet, common_row_num, ncols_num)

table = PrettyTable(common_row)

table.add_row(sheetRowToSlice(sheet, common_row_num + 1, ncols_num))

print table.get_string()