首页 > 代码库 > python读取excel并制表输出

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 = http://www.mamicode.com/sheet.cell(r, c).value"test.xlsx")

sheet = data.sheets()[0]

nrows_num = sheet.nrows

ncols_num = sheet.ncols

for r in range(nrows_num):
        cell_value = http://www.mamicode.com/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()

  

python读取excel并制表输出